Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Unable to Connect SQLState IM004 MS ODBC Driver Manager SQLAllocHandle on SQL_Handle_Env failed

Posted on 2008-10-23
3
Medium Priority
?
9,512 Views
Last Modified: 2013-12-18
Hello,

We have a Windows 2000 Server that has Oracle 9.2 installed on it. We run an ASP Application on it. This morning users were getting the error - tns could not resolve service name on the ASP pages. When I try to "test" the odbc dsn using ODBC Data Source Administrator I get the following error -

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

As far as I know nothing has been changed on this server - no updates, no one messed with the tnsnames.ora file, etc. We have another server (similar in configuration) that is hosting the ASP app now and it has no issues connecting with the databases.

I have looked at the following -
System Environment Variables - the oracle home bin directory is there in the path (I have compared it with the other server that's working and they are the same)
Permissions for the Oracle folder - Administrators and Authenticated Users had access and I have now added the IUSR_machinename and IWAM_machinename as well

Is there anything else I can check? Not sure if ths is related  but while rebooting the server I got a message saying one of the services had failed to start - when I looked at the event viewer it had the following - WMI ADAP was unable to process the RemoteAccess performance library due to a time violation in the open function (EventID 61)

Any help would be appreciated. Thanks.
0
Comment
Question by:vineethias
3 Comments
 
LVL 3

Accepted Solution

by:
richard_crist earned 500 total points
ID: 22813587
The link below discusses the same problem:

http://www.orafaq.com/forum/t/38079/0/

However, it looks like you have addressed the issues that they discuss.  You might glean more information out of the discussion, however.

I have in the past had problems where my tnsnames.ora file was still there but I got tns resolution errors.  Sometimes it turned out that someone somehow added a tnsnames.ora file to a directory that happened to be higher in the path and it found that one first.

Again, maybe the above link might have some information that turns out to be useful.

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

886 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