DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC installation; test fails with IM004

395083May 20 2003 — edited May 20 2003

I'm having trouble getting an ODBC connection to a remote Oracle 8i databse. I have installed the Oracle8 ODBC Driver release 8.1.7.7.0. When I click "Test Connection" in the ODBC driver configuration window, I'm getting:

Unable to Connect
SQLState=IM004
[Microsoft][ODBC Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_ENV failed.

The PC that this is occurring on is Windows 2000 Professional. From that machine, I'm able to access the Oracle database via SQL*Plus and via JDBC. I'm also able to TNSping the Oracle database.

I'm a member of the Administrator's Group. %ORACLE_HOME%\bin is in my path. It is in the system path. I have write access to the %ORACLE_HOME% directory.

I am using the Oracle 9.1 client at the recommendation of our Oracle database hosting provider. I tried to install the 9.2.0.4 driver but that resulted in an error (no more detail than that) from the Universal Installer.

Any help would be appreciated.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2003

Added on May 20 2003

#odbc, #windows-and-net

2 comments

4,981 views