A couple of weeks ago we installed the Oracle client software on our development IIS box so that we can connect a legacy ASP application to a remote development oracle database server. An ODBC DSN was created, the connection tested okay, this DSN, plus uid and pwd was implemented into an ASP page and this did the business and was demonstrated to users with no problems.
Two weeks later and we need to test changes that I've implemented, and we're now getting the following error message:
Error Number: -2147217843;Description: [Oracle][ODBC][Ora]ORA-121
54: TNS:could not resolve the connect identifier specified
The connection string remains the same, the code works find on my development PC environment. What could have happened in the mean time to cause this error? The server has been moved to a different location, therefore rebooted etc, but no idea if anyone has installed anything else - we can remote desktop to it. We can connect to the Oracle server using SQLPlus from, the ODBC DSN still tests okay, but from ASP pages on the same box, same DSN we get the above error message.
I did a google and did read something about encryption being set in a SQLNET.ora - there was nothing related to encryption in a recently upated file (31/March/08), only a setting to SQLNET.AUTHENTICATION_SERV
ICES = (NTS)
The tnsnames.ora file appears to be okay with the server oracle listed.
What could have caused the ASP connection to fail?
Advice appreciated. I'm an Oracle novice, only picked up what I need to know from 10g XE edition.
I think the version of Oracle is v9.
Start Free Trial
