Originally posted by dgodwin
I have a web application on a Win2K web server connecting to an Oracle 8 database.
When I access the site from the web server i.e. http://localhost/site it works correctly.
When I attempt to access the site from a remote client i.e. http://<servername>/site
I get the following error
"Error while trying to retrieve text for error ORA-12154"
This seems to be a configuration issue since local connections work and remote connections don't.
Does anybody have any suggestions on this issue?
Thanks a bunch!
I think this is because, there is no TNS entry for that particular,
Oracle database in the tnsnames.ora file.(on the web server)
You should make the entry in the web server.
If you are able to connect from your local machine, then
copy that TNS entry from your local machine's tnsnames.ora file
and add it to the tnsnames.ora file in your web server.