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....
Oracle DatabaseMiscellaneousWindows Vista

Avatar of undefined
Last Comment
jknj72

8/22/2022 - Mon
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.
jknj72

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

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
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
jknj72

ASKER
great job
slightwv (䄆 Netminder)

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.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
jknj72

ASKER
understood