Bug with DATABASE LINKS and TSmartQuery

[Henry]

Dear CRLAB-Support,

-ODAC 5.70.1.33 with NET-OPTION
-Delphi 7
-Oracle 9.2.0

Unfortunely, the bug with using database links in TSmartQuery (11608)
still exists. There is no problem anymore when both DB-instances are on
the same computer. But it still exists when the DB-instances are on
different computers.

Could you please check that and give me response as fast as possible?
Thank you for your efforts.

Best regards, Henry

To reproduce the problem try the following:


-- CREATE DATABASE LINK ---------------------------------------------
create database link TEST1
connect to user1 identified by user1
using 'LOCDELL';

--------------------------------------
LOCDELL is a entry in TNSNAMES.ORA like this one:

LOCDELL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = NOTEBOOK2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LOC)
)
)

-- CREATE SYNONYM for a table in the remote database
create synonym CU
for CU_STAMM@Test1;

-- SELECT DATA WITH TSmartQuery
you can select data, but you can't change the data in the dataset

[Plash]

To solve this problem try to include schema name in synonym:

Code: Select all

CREATE SYNONYM CU
FOR USER1.CU_STAMM@TEST1

[Henry]

With more than two users the problem still exists.

[UserA on DB1]--- with synonyms and Database Link -->[UserB on DB2]--- with synonyms -->[UserC on DB2 (here are the data tables)]

[Plash]

This situation will be supported in the next build of ODAC.