Within SQL it is possible to create a Linked Server to connect to an Oracle database server. In previous versions of SQL, this was done by using the OLE DB Provider for Oracle. But this is this component is currently in maintenance mode. No new updates are planned for future releases of these components including […]
Unable to connectSQLstate=IM004[Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed 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.