Oracle ODBC Drive Configuration error

Posted on Posted in Microsoft General

Unable to connect
SQLstate=IM004
[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed

image

 

Solution(s):

  • Check the system variable ORACLE_HOME, it should point to the installation folder of the Oracle client
  • Check the system variable PATH, it should contain ;%ORACLE_HOME%\bin;.
  • There is a . (dot) behind the ; sign in the PATH system environment variable.

One thought on “Oracle ODBC Drive Configuration error

Leave a Reply

Your email address will not be published. Required fields are marked *