This article was previously published under Q286026
This article has been archived. It is offered "as is" and will no longer be updated.
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.
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
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 188.8.131.521 118784 Ixssrv.pdl 2/1/01 10:11AM 184.108.40.2061 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:
119591 How to Obtain Microsoft Support Files from Online Services
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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
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:
Open Visio 2000. On the File menu, point to New, point to Database, and then click Database Model Diagram.
On the Database menu, point to Options, and then click Drivers.
Under Installed Visio Drivers click Microsoft SQL Server, and then click Setup.
On the Preferred Settings tab, select 2000 in the Preferred Version for DDL Generation box.