Win 2000 professional
MDAC 2.6
Oracle client 9.2
Oracle ODBC driver 9.2

I am connecting from asp page to Oracle server version 9.0.1 when i am getting the following error.

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve
service name

I have checked with the tnsnames.ora file and the service name is correctly reflected.
I also tried setting the authentication variable in sqlnet.ora file to (none) but its not working.

The connection works perfectly fine from SQLPlus, VB and MSAccess.

Its failing only from ASP.

I have given IUSR_machinename and IWAM_machinename permissions to the oracle folders on client machine.

It fails even if i use the Microsoft odbc driver for oracle version 2.5

Any help would be really great.