var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ASP to Oracle connectivity
Win 2000 professional
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
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.