DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12504: TNS:listener was not given SERVICE_NAME -- ASP.NET Connection

622606Jun 25 2009 — edited Jul 6 2009

I am trying to query an Oracle DB on UNIX from a MS SharePoint ASP.NET connection and I get the error ORA-12504: TNS:listener was not given SERVICE_NAME in CONNECT_DATA.

I CAN view the contents of the DB on this PC with the Oracle SQL Developer tool.

When I created the ASP.NET connection, it first reported that it did not have an Oracle Client to connect to. So I installed the instant client. Now I am stuck on this TNS problem which I have seen when a tnsnames.ora file needs to be updated. However, I do not see a tnsnames.ora file on this PC.

Could someone please guide me on the next thing to try?

Thanks,
/wws

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 3 2009

Added on Jun 25 2009

#oracle-providers-for-asp-net, #windows-and-net

4 comments

8,272 views