Link to home
Start Free TrialLog in
Avatar of jknj72
jknj72

asked on

Trying to connect to Oracle database from Visio

When trying to connect to an Oracle database from Visio I get the following error:
"Drivers SQLAllocHandle on SQL_HANDLE_ENV failed. "

I tried to set up a datasource with the "Oracle in OraClient 11g_home 1" driver and when prompted in Visio I use this DSN and I get the error above.

Please note that I have 10g and 11g installed. I tried to get rid of 10g but I do not see the 10g in the list of programs? Im lost and I could really use some help....
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Are you using the ODBC drivers?

Make sure the bit versions match what you are using.  If Visio is 32Bit, you need the 32Bit Oracle drivers.

If your machine is 64Bit, there are two version of the ODBC admin tool:
http://support.microsoft.com/kb/942976

I saw some references to that error and it was a PATH issue.  the PATH was pointing to the wrong Oracle folders first.

>> tried to get rid of 10g but I do not see the 10g in the list of programs?

Oracle has it's own installer that you need to use to uninstall it.
Avatar of jknj72

ASKER

where would I find the installer so I can uninstall?
Also, I am running Vista 32 bit
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jknj72

ASKER

I have attached a pic of my Start menu so you can see what I have as far as Oracle10g on my machine. I saw the installer for the Oracle10g_home(?) and I used it to unistall all the 10g stuff that I saw but it still has this on the start menu?

I am running 32 bit on my machine and from what I read, if I just have a lib folder in my C:\ORACLE\ORA112\ directory then I have 32 bit installed. But then I checked your link and now Im concerned I might have 64 bit?

How would I change the path that you described above?

I am desperate at this point so whatever I need to do please just let me know.

THANKS!!!
Start-menu.jpg
Avatar of jknj72

ASKER

Slight,

I just created a User DSN(again!) and then I went into Visio and used it to connect to my DB and voila!! It worked.....I have no idea how or why, cause I didnt do anything today that I havent done already?
You totally helped me out and I appreciate it very much.

Thanks
JK
Avatar of jknj72

ASKER

great job
Glad to help.

>>cause I didnt do anything today that I havent done already?

You did uninstall 10g?

>>unistall all the 10g stuff that I saw but it still has this on the start menu?

Oracle is famous for their 'uninstall' to not actually remove everything.  When you have time and get a little more comfortable with Oracle a manual install is almost always faster and more complete.

There are a LOT of links/blogs/steps out there on how to do a manual uninstall.  The dangerous part comes in because you have to edit the registry.
Avatar of jknj72

ASKER

understood