asked on

How can I use Visio 2007 to reverse engineer an Oracle 11 database on Vista x64?

I'm running Vista 64 in a bootcamp partition on my MacBook Pro, accessing that partition through VMWare Fusion. I'm able to install Oracle 11 (after fixing the stupid loopback connector) and can connect to is fine. I also installed Oracle 10G later. I can't reverse engineer either database because Visio won't show me options for the appropriate ODBC driver, and when I am able to get it using a user or system DSN, Visio gives me an error that it can't see the Oracle client install or something to that effect. I googled one potential fix, but it required that I hack into my registry to get around the 64 bit ODBC client driver issues. Any help would be appreciated.

SOLUTION

Raja Jegan R

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

techhealth

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

davidgordonhill

ASKER

I downgraded from Vista 64 to Vista 32, installed Oracle 11G 32 bit Windows version, and the ODBC driver issues went away. Pretty sad solution, but I'm on a bootcamp partition on a laptop so I really didn't need the 64 bit solution, but figured it would have been best. I figured wrong about Oracle and Vista though!