PRB: Cannot Use File DSN in Database Model in Visio 2002 (320706)


The information in this article applies to:

  • Microsoft Visio 2002 Professional
  • Microsoft Visio for Enterprise Architects (2002), when used with:
    • Microsoft Visual Studio .NET (2002), Enterprise Architect Edition
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.
Modification Type:MajorLast Reviewed:11/18/2003
Keywords:kbprb KB320706
©2003 Microsoft Corporation. All rights reserved.