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

Article translations Article translations
Article ID: 286424 - View products that this article applies to.
This article was previously published under Q286424
This article has been archived. It is offered "as is" and will no longer be updated.
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.

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.

Properties

Article ID: 286424 - Last Review: October 23, 2013 - Revision: 1.5
APPLIES TO
  • Microsoft Visio 2000 Service Release 1
  • Microsoft Visio 2000 Service Release 1
Keywords: 
kbnosurvey kbarchive kbhotfixserver kbqfe kbbug kbfix kbqfe KB286424

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com