Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1447
  • Last Modified:

Can't test oracle DSN

I have win2k OS with oracle client version 9.0.2. I have installed Oracle ODBC driver 9.0.15. I am trying to create a DSN for a database server which is on other machine.

When I connect to database using SQL plus, it connects properly. However, when I add a DSN, and click 'test connection' it throws error saying
SQL state=IM004 ERROR Driver's SQLallochandle on SQL_HANDLE_ENV failed.

I have already done the following which I found on net.

I removed and reassigned the permissions of read and execute on oracle home directory and restarted the machine.

Does anyone know what is the solution for this?

Best regards,

1 Solution
Do you have multiple Oracle Homes?
rahul_asanikarAuthor Commented:
No. we have only one.
slightwv (䄆 Netminder) Commented:
The 9.0 version of Oracle has MANY bugs.  I'm guessing that you are probably hitting one.  Can you install 9.2 client on another machine and test it?
 pl. just collect this three .dll from older version or new version (.2)Sqora32.dll,Sqoras32.dll,Sqresus.dll

it will work fine.
if you install Oracle ODBC driver, it should be compatible with the client version. An alternative is to install the same version.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now