Page 1 of 1

Problem with synonyms and Database-Link

Posted: Mon 22 May 2006 11:18
by Henry
Hello
-Delphi 7, ODAC + NET-Option
-We have two DB-Instances. "A" and "B"
-We have User "UA" on DB "A" and we have User "UB" on DB "B" -Create a Database Link from "UB" to "UA"
(CREATE DATABASE LINK MYLINK connect to UA identified by UA using 'A';)
-Create a Synonym for user "UB" for access a table from user "UA" (create synonym Syn_Name for UA.Table_Name@MYLINK;)
-Now you can select data from Table_Name over Sys_Name

With older version of ODAC I can select an change data with TSmartQuery. No problem.
But with the latest version i get Error "Cannot change data in read only dataset". Whats wrong?

I can try to analyse since which version of ODAC the problem occures.
Unfortunately I deleted the former installation-packages of ODAC.

Henry

Posted: Mon 22 May 2006 14:38
by Henry
Have received a mail from Support Team.
Problem will be fixed in next build of ODAC.

Thanks to ODAC-Team.

Henry