Microsoft KB Archive/320706

= PRB: Cannot Use File DSN in Database Model in Visio 2002 =

Article ID: 320706

Article Last Modified on 11/18/2003

-

APPLIES TO


 * Microsoft Visio 2002 Professional Edition
 * Microsoft Visio for Enterprise Architects 2002, when used with:
 * Microsoft Visual Studio .NET 2002 Enterprise Architect

-



This article was previously published under Q320706



SYMPTOMS
The file data source names (DSNs) do not appear in the list of available data sources in the following wizards:
 * Reverse Engineering Wizard in Visio 2002 Professional and Visio for Enterprise Architects (2002)
 * Update Wizard in Visio for Enterprise Architects (2002)
 * Generate Wizard in Visio for Enterprise Architects (2002)

Although you can create a new file DSN successfully in the ODBC dialog box that these wizards generate, the DSN does not appear in the list of data sources. When you try to type the full path of this file, you receive the following error message:

Specify a valid data source before you can proceed



CAUSE
Visio 2002 does not support file data sources. For a data source to appear in the Data Source list in the wizard, the data source must be a user data source or a system data source.



RESOLUTION
To resolve this problem, use a user data source or a system data source to connect to external databases.



MORE INFORMATION
These wizards are accessible from the Database menu when you design a database model in Visio 2002.

Steps to Reproduce the Behavior

 * 1) Start Visio 2002 Professional Edition or Visio for Enterprise Architects (2002), and then create a new Database Model Diagram.
 * 2) On the Database menu, click Reverse Engineer.
 * 3) In the Reverse Engineer Wizard, click New.
 * 4) On the Create New Data Source page, click to select the File Data Source check box, and then click Next.
 * 5) In the Select a driver for which you want to set up a data source list, click SQL Server, and then click Next.
 * 6) Type a name for the data source, and then click Next.
 * 7) Click Finish. The Create a New Data Source to SQL Server Wizard opens.
 * 8) In the Create a New Data Source to SQL Server Wizard, type a valid name for a server that is running Microsoft SQL Server, and then click Next.
 * 9) Select your authentication method, and then click Next.
 * 10) Change the database to Pubs, and then click Next.
 * 11) Click Finish.
 * 12) Click OK. Notice that the data source that you created does not appear in the Data Source list.

Keywords: kbprb KB320706

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.