Monthly Archives: August 2015

Creating a SQL Linked Server to an Oracle database server

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 … Continue reading

Posted in Microsoft General | Tagged , , | Leave a comment

Oracle ODBC Drive Configuration error

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 … Continue reading

Posted in Microsoft General | Tagged , | 1 Comment