Connection to Oracle XE via IIS/ASP app was working then stopped
545731Nov 15 2006 — edited Nov 15 2006I am prototyping an application for my new management here so that I can recommend they use Oracle XE.
The connection to the Oracle XE database appears to have stopped working, via an IIS/ASP application I wrote. I can still connect through ODBC using native MS Access to Oracle XE, when logged into XP, its just when I try to log in using the app via IIS I get the following error:
Unable to establish connection to database.
Error information:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified
It was working for a while, like the whole first week. It might be related to the fact that that I finally rebooted, not sure.
I have tried many, many things. I made the IUSR account an admin on the box hoping that maybe it had just lost access to the local ODBC/TNSNAMES. Right now all the components are local to my development box, from the IIS server to the Oracle eXtended Edition database (XE, free). Like I said, it was working. I did have this same message I believe early on, which turned out due to the fact that my ODBC DSN was a local DSN, instead of a System DSN, which I overcame at that time. But it just started happening again, possibly after a reboot.
I also tried switching to a local MS Access database, and I got a similar message. I moved the Access db to c: root, and it appears to work, so it appears to be a file/directory access issue.
But I'm not sure how to resolve it because I would much prefer to use the Oracle database.
Thoughts?