Link to home
Start Free TrialLog in
Avatar of luyan
luyan

asked on

Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

We installed Oracle client 10.2.0.3 on a window 2003 64bit server. When I set up Oracle ODBC Driver Configuration, got the following error message in testing connection.
Unable to connect
SQL State=IM004
Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

How to pass the testing of connection in ODBC configuration?
Thanks!
Avatar of mrjoltcola
mrjoltcola
Flag of United States of America image

Did you setup the client prior to configuring the ODBC DSN?

https://www.experts-exchange.com/questions/24393666/How-to-create-Oracle-ODBC-connection-in-Windows.html

Are you using 64-bit binaries?
Avatar of luyan
luyan

ASKER

Yes, I installed Oracle Client, and then set up ODBC.
And got the error message when I clicked the button "Test connection" in Oracle ODBC Driver Configuration.
Unable to connect
SQL State=IM004
Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
ASKER CERTIFIED SOLUTION
Avatar of mrjoltcola
mrjoltcola
Flag of United States of America image

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