When you generate a new database or reverse engineer an existing Microsoft SQL Server 2000 database, Microsoft Visio may stop responding within the database design wizards. In addition, when you use the database design features within Visio 2000 Service Release 1 (SR-1) against a Microsoft SQL Server 2000 database, you do not receive the expected results.

Back to the top

The SQL Server driver that is included with Visio 2000 SR-1 is designed to interact with SQL 4.2, 6.x, and 7.0 database servers. SQL Server 2000 introduces several changes that affect the database design features in Visio. The following list contains some of the SQL Server 2000-specific areas that the database driver addresses:

•	Changes in version information
•	Support for the new data type, BIGINT, introduced in SQL Server 2000
•	Support for the ROWGUIDCOL attribute
•	The ability to extract SQL Server 2000 table and column descriptions

Back to the top

A supported, post-Visio 2000 SR-1 update that corrects the potential for these problems is now available from Microsoft. The following file is available for download from the Microsoft Download Center:
After you have downloaded the update, close all instances of Visio before you install the update. To install the update, double-click Q286026.exe in Windows Explorer.

IMPORTANT: A Microsoft Visio U.S. English or International English edition of SR-1 must be present on each computer to which you apply this update.

The English version of this installation package has the following file attributes or later:

   Date    Time    Version     Size    File name     Platform
   -------------------------------------------------------------
   3/6/01  2:52PM  5.0.2920.0  312080  Q288537.exe   x86
				

NOTE: The installation file has an option that you can use to run it silently from a command prompt. The /Q:A switch enables silent mode and assumes that the person that runs this installation package is either an administrator or is running it as an SMS package. This installation performs no checking for administrator rights or disk space, and displays no prompts or error messages. The following example demonstrates how to run this installation package from a command prompt in silent mode. The command assumes that the file is in the root directory of drive C, or in the Path environment variable: The Q286026.exe file updates the computer with the following file versions or later:

   Date     Time     Version     Size    File name
   -------------------------------------------------------
   2/1/01   3:29PM   6.1.0.1401  118784  Ixssrv.pdl
   2/1/01   10:11AM  6.1.0.1401  159744  Sqlshare.dll
				

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

Back to the top

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

Back to the top

The Visio database driver (.PDL) file interfaces with your Database Management System (DBMS) to:

•	Reverse engineer a database model
•	Refresh a model from a database
•	Generate a new database
•	Update an existing database

Visio uses these database drivers in conjunction with vendor-supplied 32-bit Open Database Connectivity (ODBC) drivers to connect directly to a specific DBMS. Each driver informs and provides support to Visio for the following:

•	Reverse engineer DBMS-specific information
•	Map data types and constraints
•	Specify extended attributes for your particular database application
•	Format of DDL (Data Definition Language) in generation of the SQL script

The SQL Server driver was updated to provide the same type of support for Microsoft SQL Server 2000 as was available for Microsoft SQL Server 4.2, 6.x and 7.0 database servers that use the Visio 2000 database features. This update adds no new features other than those listed above. After you install the updated driver for Microsoft SQL Server 2000, you can make it the default configuration for Visio. To configure the default Visio 2000 usage of the new SQL Server 2000 option under the SQL database driver settings, follow these steps:

1.	Open Visio 2000. On the File menu, point to New, point to Database, and then click Database Model Diagram.
2.	On the Database menu, point to Options, and then click Drivers.
3.	Under Installed Visio Drivers click Microsoft SQL Server, and then click Setup.
4.	On the Preferred Settings tab, select 2000 in the Preferred Version for DDL Generation box.
5.	Click OK twice to accept the changes.

Back to the top