Visio database modeling samples do not have a matching data source (313516)



The information in this article applies to:

  • Microsoft Visio 2000 Professional Edition
  • Microsoft Visual Studio .NET (2002), Academic Edition
  • Microsoft Visual Studio .NET (2002), Enterprise Architect Edition
  • Microsoft Visual Studio .NET (2002), Enterprise Developer Edition
  • Microsoft Visual Studio .NET (2002), Professional Edition
  • Microsoft Visual Studio .NET (2003), Academic Edition
  • Microsoft Visual Studio .NET (2003), Enterprise Architect Edition
  • Microsoft Visual Studio .NET (2003), Enterprise Developer Edition
  • Microsoft Visual Studio .NET (2003), Professional Edition

This article was previously published under Q313516

SYMPTOMS

When you work with the ChampionZone database example in either Visio 2002 Professional Edition or Visual Studio .NET, no data source is attached to the Championzone Database.vsd file. Without a data source, you cannot use the database Refresh feature.

RESOLUTION

To resolve this problem, create your own data source (DSN) to establish a connection to the sample databases. For more information on how to accomplish this, see the "More Information" section.

Alternatively, see the "Create a data source by using the ODBC Data Source Administrator (Database model)" topic in the Visio Help.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

  1. In Windows Explorer, double-click the Visio Championzone Database .vsd (drawing) file. The default folder is C:\Program Files\Microsoft Office\Visio10\1033\Samples\Database\.

    NOTE: In the United States, the file name is Championzone Database (US units).vsd.
  2. After Visio starts, and the drawing is loaded, click Database.
  3. In the drop-down menu, click Refresh Model. The Refresh Model Wizard dialog box appears.NOTE: You should see Microsoft Access listed in the Installed Visio drivers drop-down list. If you do not, click Setup, select Microsoft Access Driver (*.mdb) in the ODBC Drivers list, and then click OK to close the dialog box.

  4. By default, the Refresh Model Wizard data sources list does not show a data source that relates to the Championzone Database.mdb file. To provide this information, follow these steps:
    1. To the right of the Data Sources list, click New.
    2. In the Create New Data Source dialog box, select User Data Source, and then click Next.

      NOTE: Visio supports only user and system DSNs. It does not support data sources that are created as file DSNs.
    3. In the Select a driver for which you want to set up a data source list, select Microsoft Access Driver, and then click Next.
    4. Verify the information on the next form, and then click Finish.
    5. The ODBC Microsoft Access Setup dialog box appears. For Data Source Name, type a meaningful name for your DSN, such as Championzone.
    6. For Description, type any meaningful description that you choose.
    7. In the Database section of the dialog box, click Select.
    8. In the Select Database dialog box, select Championzone Database in the Database Name list. (Note that you may have to browse to the correct folder in the Directories list.) Click OK to close the Select Database dialog box and return to the ODBC Microsoft Access Setup dialog box. The abbreviated path and database name should appear as a label caption immediately above the row of buttons in the Database frame of the dialog box. Click OK.
    9. In the Refresh Model Wizard dialog box, you should see the DSN name that you typed in the ODBC Microsoft Access Setup dialog box. Click Next.
    10. In the Connect Data Source dialog box, type or verify the user and password data. Click OK.
    11. The Refresh Model Wizard dialog box displays the following message:
      No conflicts were found between the database and the database image stored in model.
      Click Next.
    12. The Refresh Model Wizard dialog box displays the following message:
      There will be no changes made to the model.
      Click Finish.
  5. Click Database and then click Refresh Model. When the Refresh Model Wizard dialog box appears, select your DSN name and click Next. Verify the user name and password in the Connect Data Source dialog box, and the Championzone Database drawing is updated by any changes in the database.

Modification Type:MinorLast Reviewed:8/12/2005
Keywords:kbvs2002sp1sweep kbbug kbpending KB313516