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


The information in this article applies to:

  • Microsoft Visio 2000 Professional Edition Service Release 1 (SR-1)
  • Microsoft Visio 2000 Enterprise Edition Service Release 1 (SR-1)
This article was previously published under Q286424

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.

RESOLUTION

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

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

STATUS

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

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.
Modification Type:MinorLast Reviewed:10/12/2005
Keywords:kbHotfixServer kbQFE kbbug kbfix kbQFE KB286424
©2004 Microsoft Corporation. All rights reserved.