Error using Database link

edvanwijngaarden · Post by **edvanwijngaarden** » Fri 16 Jan 2009 16:29

Hello,

In my Oracle database I have a database link to another database: WMS.
However, when I try to use this link in a TOraQuery it does not work; I get the error message: "ORA-02019: connection description for remote database not found." The link realy exists; when I use the query:
select * from USER_DB_LINKS
the link is properly listed.
The query I use is simple:
SELECT *
FROM UNIT_CONFIGURATION@WMS

It is strange that in other applications the query works fine, for example in the Oracle Enterprise Manager console or in Database Workbench (which, I think, use also your ODAC components).
I use direct database acces.
What could cause this problem?

Plash · Post by **Plash** » Tue 20 Jan 2009 09:58

Please check that you have connected under the same user in Enterprise Manager and ODAC. Maybe your database link is not public. So it is available only for an appropriate user.

Check also if the error occurs when the Direct property is set to False.