Iam having Public synonym for DBLINK remote database ,
When i execute a query iam getting the following error...
[Oracle][ODBC][Ora]ORA-02041: client database did not begin a transaction.
I use ADO - 2.1 , Oracle 8.1.7 , Vb 6.0
Set cm.ActiveConnection = GetConnection
cm.CommandText = "SELECT RTRIM(agt_cd) agt_cd FROM pragent ORDER BY agt_name"
Set GetAllAgentCodes = cm.Execute
(PRAGENT table is synonym for remote database table)
Can you help to solve ??????