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-12514: TNS:listener does not currently know of service requested

569109Mar 27 2007 — edited Sep 9 2009

I'm currently trying to set up a reporting data source in VS2005 in a Reporting project. Now when I try to create a new report using my Oracle based data source I get the following:
A connection cannot be made to the database.
Set and test the connection string.
ERROR [NA000] [Microsoft][ODBC driver for Oracle][Oracle]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

I've installed the data tools for VS2005 as well as the 10g client.

I can tsnping the database, as well as connect to it using the SQLPlus tool. I only seem to have an issue when connecting through VS2005.

Anyone able to shed some light??

Greg

P.S. I'm using XP Pro.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 7 2009

Added on Mar 27 2007

#odbc, #windows-and-net

7 comments

38,651 views