Visio 2000 SR-1 & Oracle 9i

[Paul Moloney]

I've attempted to reverse engineer Oracle 9i
in Visio 2000 (SR-1) without any success;
Oracle 8 works. However, I've seen other postings
saying that they have managed to use the above
combination successfully. Does anyone know how?
Or if a later version of Visio works with 9i?

Thanks,

P.

 

[Paul Moloney]

Just to add more information, every time I attempt to reverse engineer,
I get the error:

"Encountered a fatal error during reverse engineer of information from
the database".

This occurs even when I try on one simple test table. I'm no
trouble connecting to the database; the connection test returns
OK.

P.

 

[Kevin Nechodom]

As you can see from the minimal response to my 6/23 posting,
there does not seem to be a lot of traffic for Oracle/Visio
combinations.

I can (with obstacles) reverse-engineer Oracle 9i tables
using Visio for Enterprise Architects 2002 (bundled with
VS.NET Enterprise Architects 2003).

Kevin

 

[Paul Moloney]

As you can see from the minimal response to my 6/23 posting,
there does not seem to be a lot of traffic for Oracle/Visio
combinations.

I can (with obstacles) reverse-engineer Oracle 9i tables
using Visio for Enterprise Architects 2002 (bundled with
VS.NET Enterprise Architects 2003).

Hi there,

What kind of obstacles? Would you recommend upgrading?

P.

 

[Kevin Nechodom]

The problems I had are outlined in my 6/23 post. Unique
constraints appear to be a problem. My guess is that it is
due to the fact that you can have BOTH a constraint AND an
index, and they have the same name.

I would verify that the latest service release (SR-2) is
available for Visio 2000. If not, that's a vote for an
upgrade. Secondly, do you need database round-trip changes?
If so, then the upgrade MUST be to VS.NET EA 2003. It is
the only current version to have that feature. Be aware
that it is based on Visio 2002, not Visio 2003.

In my situation, I am moderately pleased with the upgrade,
with the release of SR-2. The price was right (academic).
Though there are still problems, I can work around them.

Kevin

 

[Neal]

I run into the same problem every time I run reverse
engineering for the first time. Once it fails, I try re-
running it again and for some reason, it works!