This discussion is archived
0 Replies Latest reply: Oct 28, 2012 8:34 AM by Pan.Tian RSS

ODBC cann't connect Oracle DB

Pan.Tian Newbie
Currently Being Moderated
Dear Expert,
I can't connect Oracle DB from ODBC,
Control Panel > ODBC > Select 'Oracle in OraDb11g_home1' as driver >Input instance information(instance,user/password),
then click 'Test Connection', It raise error:

Unable to connect
SQLState=IM004
*[Microsoft][ODBC Driver Mangement]Driver SQLAllocHandle on SQL_HANDLE_ENV Fail*

Using cmd window, I can connect to instance, command like:
sqlplus user/password@instance

Env:
My Client is: Win 7(64 bit)
Oracle DB Version:11g

Is there anyone know how to resolve this error

Thanks in advance.
Pan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points