Visio2000: Visio Stops Responding When You Update a Reverse-Engineered Oracle DB Schema

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q286424

Expand all | Collapse all

SYMPTOMS

When you update a reverse-engineered Oracle 7.3 database by using the Visio Update Database Wizard, Microsoft Visio 2000 SR-1 may stop responding.

Back to the top

A supported, post-Visio 2000 SR-1 update that corrects this problem with an Oracle 7.x Server is now available. A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that this article describes. Apply it only to systems that are experiencing this specific problem.

To resolve this problem, contact Microsoft Product Support Services to obtain the hotfix. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support (http://support.microsoft.com/contactus/?ws=support)

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this fix should have the following file attributes or later:

   Date     Time    Version      Size    File name     Platform
   -------------------------------------------------------------
   3/1/01   3:56PM  5.0.2920.0   294672  Q286424.exe   x86

After the hotfix is installed, the following files will have the listed attributes or later:

   Date     Time     Version     Size    File name     Platform
   -------------------------------------------------------------
   2/27/01   1:04PM  6.1.0.1427  647168  Extract.dll   x86
   2/27/01  12:47PM  6.1.0.1427  294912  Ixoracle.pdl  x86

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 Oracle database driver for Visio (the Oracle.pdl file) connects to the Oracle Database Management System (DBMS) and allows Visio to do the following:

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

Visio uses this database driver 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 generated SQL scripts

The updated Oracle driver for Visio (Ixoracle.pdl) is designed to work with Oracle Server 7.3. Therefore, issues may exist with extended or new features, such as namespaces, or with constraints that are applied to tables. These issues can result in validation failures and other problems.

Microsoft recommends that you not apply constraints to tables, and that you use an American National Standards Institute (ANSI) implementation and configuration of SQL DDL scripts, to reduce validation errors on an update.

Back to the top

APPLIES TO

Microsoft Visio 2000 Service Release 1

Back to the top

kbhotfixserver kbqfe kbbug kbfix kbqfe KB286424

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