Visio2000: Database Design Features Update for SQL Server 2000

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q286026

Expand all | Collapse all

SYMPTOMS

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

CAUSE

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

RESOLUTION

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:

Collapse this imageExpand this image

Download Q286026.exe now (http://download.microsoft.com/download/visio2000enterprise/update/2000/win98me/en-us/q286026.exe)

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:

Q286026.exe /Q:A

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:

119591 (http://support.microsoft.com/kb/119591/EN-US/ ) 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.

Back to the top

STATUS

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

MORE INFORMATION

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.
Click OK twice to accept the changes.

Back to the top

APPLIES TO

Microsoft Visio 2000 Service Release 1

Back to the top

kbhotfixserver kbqfe kbdownload kbbug kbfile kbfix kbgraphxlink kbqfe KB286026

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top