0 Replies Latest reply: Oct 28, 2012 10:34 AM by Pan.Tian RSS

    ODBC cann't connect Oracle DB

      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
      *[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

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

      Is there anyone know how to resolve this error

      Thanks in advance.