Diaboliciq
New Member
Hi,
I have MS sql Server and OpenEdge 10.2B DB. I add OpenEdge db on linked server with ODBC driver.
I need near real time replication Sql to Progress.I try to ddl triggers on linked server but it didnt fire Openedge tables for insert,update,delete. I try every possibility but i get an error like this :
OLE DB provider "MSDASQL" for linked server "XX DB" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Optional feature not implemented.".
Msg 7391, Level 16, State 2, Procedure Deneme, Line 8
The operation could not be performed because OLE DB provider "MSDASQL" for linked server "XX DB" was unable to begin a distributed transaction.”
Sql Options RPC,RPC out,Enable Promotion of Distributed Transactions for RPC True and Distributed transaction coordinator service is active.
How can i fix this.Is it possible MS SQL to Openedge db Replication please help me.
Thanks.
I have MS sql Server and OpenEdge 10.2B DB. I add OpenEdge db on linked server with ODBC driver.
I need near real time replication Sql to Progress.I try to ddl triggers on linked server but it didnt fire Openedge tables for insert,update,delete. I try every possibility but i get an error like this :
OLE DB provider "MSDASQL" for linked server "XX DB" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Optional feature not implemented.".
Msg 7391, Level 16, State 2, Procedure Deneme, Line 8
The operation could not be performed because OLE DB provider "MSDASQL" for linked server "XX DB" was unable to begin a distributed transaction.”
Sql Options RPC,RPC out,Enable Promotion of Distributed Transactions for RPC True and Distributed transaction coordinator service is active.
How can i fix this.Is it possible MS SQL to Openedge db Replication please help me.
Thanks.