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

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.
vineethiasAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
richard_cristConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.