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

SearchDataManagement
SearchBusinessAnalytics
SearchSAP
SearchSQLServer
TheServerSide.com
SearchDataCenter
SearchContentManagement
SearchHRSoftware
Close