Q
Problem solve Get help with specific problems with your technologies, process and projects.

TNS:listener does not currently know of service requested in connect descriptor

I installed Oracle 10gR2 on my client machine, configured my Net8 and added an ODBC system datasource which I wanted to use in connecting my ASP application to the Oracle 10gR2 Server running on HP-UX, but I keep getting this error.

I installed Oracle 10gR2 client on my client machine which runs WinXP SP2. I configured my Net8 and added an ODBC system datasource which I wanted to use in connecting my ASP application to the Oracle 10gR2 Server running on HP-UX, but I keep getting this error: "Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC driver for Oracle][Oracle]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor." What do I do? Because I can tnsping, I also can connect through SQL*Plus from my client machine.

Just today I had to deal with this exact problem. It is likely that the database uses dynamic registration to contact the listener on the database server. Yet I had to explicitly use static registration to get my ODBC connection to connect to the database. Otherwise, I received the ORA-12514 error just like you did. Look at the Net Adminstrators Guide on how to use static registration.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close