Problems reverse Engineering and Oracle 10g database

[Robert Tisljar]

Has anybody figured out how to get rid of the error below, in Visio 2003,
after converting from Oracle 9i to 10g?

Error Msg box: MS-Visio - Encountered a fatal error during reverse engineer
of information from database.

Thanks.

 

[Barb Way]

Visio's drivers are only rated to support Oracle versions up to 8.x. So
newer constructs, data types and objects found in the more recent versions
of Oracle cannot be reverse engineered many times.

As a workaround, you can try using the 'Generic ODBC' driver in Visio as
the connector instead of the Oracle driver. This has its own shortcomings
as well, but it may provide enough detail to do what you wish and avoid the
errors.

Barb

Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]

--------------------

Has anybody figured out how to get rid of the error below, in Visio 2003,
after converting from Oracle 9i to 10g?

Error Msg box: MS-Visio - Encountered a fatal error during reverse engineer
of information from database.

Thanks.

 

[D. Sean Kelly]

I found that if I do the reverse engineering thing three times in a row it
will grab the tables. Not sure what is special about that, but it seems to
work.

Now, if I try to Refresh Model off the Database menu option Visio will hang
indefinitely. Almost like an error message was going to appear, but there is
no feedback other than an unresponsive Visio window.

Oracle 10g, Oracle ODBC Drivers, Logging on as a 'normal' user (eg not
System), Visio 2003 SP3, Windows XP.

 

[Barb Way]

Yes - as I mentioned previously, our drivers do not support the recent
versions of Oracle, so there is no good way to get a clean Reverse Engineer.
You might also try the Generic driver to see if the Refresh works in your
case.

Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------

From: <[email protected]
Subject: RE: Problems reverse Engineering and Oracle 10g database
Date: Wed, 28 May 2008 07:00:04 -0700


I found that if I do the reverse engineering thing three times in a row it
will grab the tables. Not sure what is special about that, but it seems to
work.

Now, if I try to Refresh Model off the Database menu option Visio will hang
indefinitely. Almost like an error message was going to appear, but there
is
no feedback other than an unresponsive Visio window.

Oracle 10g, Oracle ODBC Drivers, Logging on as a 'normal' user (eg not
System), Visio 2003 SP3, Windows XP.