Learn how to a build a cloud-first strategyRegister Now

x
  • 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,
Rahul

0
rahul_asanikar
Asked:
rahul_asanikar
1 Solution
 
boriskalavskyCommented:
Do you have multiple Oracle Homes?
0
 
rahul_asanikarAuthor Commented:
No. we have only one.
0
 
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?
0
 
nitishcalCommented:
 pl. just collect this three .dll from older version or new version (.2)Sqora32.dll,Sqoras32.dll,Sqresus.dll

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

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