Can't test oracle DSN

Posted on 2004-11-08
Last Modified: 2010-05-18
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,

Question by:rahul_asanikar
    LVL 4

    Expert Comment

    Do you have multiple Oracle Homes?

    Author Comment

    No. we have only one.
    LVL 76

    Accepted Solution

    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?

    Expert Comment

     pl. just collect this three .dll from older version or new version (.2)Sqora32.dll,Sqoras32.dll,Sqresus.dll

    it will work fine.

    Expert Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now