Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insert to XE from sql server 2005 ...

470589Dec 13 2007 — edited Dec 13 2007
Hi,

is it possible to create a trigger on Sql Server 2005 to insert a row to Oracle XE ?

I want to create a update/insert trigger on sql server 2005 which will insert the data into a Oracle XE table.

I have a Linked Servers in Sql Server to Oracle XE and this link works with simple sql statement from sql server like :
INSERT INTO [NEW_OR]..[Adam_user].[DUMMY] (AA) VALUES('Dummy String Data')
---------------------------
But the same statement does not work when in trigger. the following error occurs in Sql Server 2005...

Msg 8501, Level 16, State 3, Procedure deneme, Line 5
MSDTC on server 'Adam_user' is unavailable.

Any suggestions?
Thanks in advance.....

Adam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 10 2008
Added on Dec 13 2007
3 comments
224 views