Have Geek Brain

Problem connecting to Oracle database via ASP.NET page in IIS

I am having a problem getting a simple ASP.NET web page. The page contains a GridView with a SqlDataSource connected to an Oracle database.

When I run the page in the VS debugger (cassini web server) everything works fine, but when I publish the application to my local IIS server (same computer) I get the following error:

ORA-12154: TNS: unable to determine the specified connection id

If it was a different machine, I could figure out that it might be tnsnames.ora or some other problem that I could investigate with tnsping. I also set up security in the folder containing the Oracle drivers, "Everybody", and set the web application to run under the "Priviliged" AppPool (Identity as Administrator), but no success.

Does anyone have any ideas?

0


a source to share


3 answers


this guide is the bible for problems like this :)



Actually, I printed one copy of this tutorial and circulated it for every IIS ASP.NET related consultant on ORACLE connection problems. The checklist will probably help solve your problem, unless you have a problem in code that does not appear to be based on your scenario.

+2


a source


I think you have more than one Oracle client. You need to find ALL tnsnames.ora files using Windows Explorer and compare and sync ALL those files.



0


a source


maybe you need to specify the IP

-1


a source






More articles:


All Articles