We help IT Professionals succeed at work.

Trying to connect to Oracle database from Visio

1,669 Views
Last Modified: 2014-05-16
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....
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
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.

Author

Commented:
where would I find the installer so I can uninstall?
Also, I am running Vista 32 bit
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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

Author

Commented:
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

Author

Commented:
great job
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
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.

Author

Commented:
understood

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.