Q

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.

This was first published in June 2007

Dig Deeper

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close