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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close