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