BorlandTalk.com

20100 · Guest

Hello,

my configuration is
DELPHI 6.1 +
2 Oracle Data Base (B1 and B2) on 2 distinct servers

With sql+ I have create a data base link.

With sql+ on B1, the following query is Ok:
select * from MyTabB1@B2; --> OK

It's also Ok with Delphi and a component TQuery:

MyQuery:=TQuery.Create(Nil);
MyQuery.databasename='B1'
MyQuery.add('select * from MyTabB1@B2');
MyQuery.Open -->OK

But with TSQLQuery or TSQLClientDataSet:

Var
MySQLQuery: TSQLQuery;
B1_SQLConnection: TSQLConnection;
Begin
....
MySQLQuery:=TSQLQuery.Create(Nil);
MySQLQuery.SQLConnection:=B1_SQLConnection;
MySQLQuery.add('select * from MyTabB1@B2');
MySQLQuery.Open ; --> KO

The message is :
ORA - 02041 : Client Database not begin a transaction

So, I have declared a new variable TD : TTransactionDesc:

....
B1_SQLConnection.StartTransaction(TD);
MySQLQuery:=TQuery.Create(Nil);
MySQLQuery.SQLConnection:=B1_SQLConnection;
MySQLQuery.add('select * from MyTabB1@B2');
MySQLQuery.Open ; --> KO

The message is :
ORA - 24777 : Use of non-migratable database link not allowed

HELP ME!!!!

--- posted by geoForum on http://delphi.newswhat.com