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