Thanks for your reply Paszt.
I am using Oracle to Oracle database link. I have created database link and its working fine from SQL*Plus.
When I place a new OracleDataAdapter onto the form and start configuring it, the following sql statement
SELECT * FROM T1@MyLink
(T1 is the table name and MyLink is the link name)
its giving error "
There were errors configuring the data adapter."
For the same table I have created a synonym from oracle as
CREATE SYNONYM S_FIRST FOR T1@MyLink
then given following sql statement in adapter configuration
SELECT * FROM S_FIRST
Now the error is "
No data exists for the row or column."
So, thats the story. Hope I am clear.
Thanks in advance.