Devart Forums

Hi All,

We have a database we need to connect to which contains a DBLink to yet another database. The DBLink itself is fine, and indeed using the OraDirect component we can connect to the database itself.

However, when attempting to access tables over the DBLink we're getting the following error (using the SQL select * from person@xyzlink);

OracleException: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

(Yes the connection works otherwise). I also tested and received the same error using one of the sample applications.

Any ideas?

Try to execute this query using SQL*Plus.
Please check user and password information in CREATE DATABASE LINK command when you are creating link to database. Try to test it with link to the same database.

Paul,

The query works correctly with SQL PLus, as well as with other providers (we've come from ODP.net).

Any other thoughts? Is oradirect supposed to support the dblink syntax?

Please ignore my above request - we've resolved the issue.

It was our DBA turning off the link!! Very sorry to have wasted your time (and mine!!)