In SQL SERVER 2005 I tried this:
Then I connected to remote server. So that I can do insert, update, delete, select to remote server. There is no problem for this issue. The connection is normal.
When I use update, delete, insert commands in a trigger, trigger created successfully. But for example; after inserting to a SQL SERVER table, trigger gives error. error is:
OLE DB provider "MSDAORA" for linked server "SAMPLESERVER" returned message "ORA-01041:internal error. hostdef extension doesn"t exist
my trigger is :
NOTE: the insert code runs successfully without trigger.
asked Feb 22 '10 at 11:30 AM in Default
This forum is for MS Sql Server only. Try posting your question on a forum for Oracle - like dbforums.com
For sql server you wouldn't want to put a linked server call inside a trigger for various reasons. Sounds like replication would be a better sql server solution in this case.
answered Feb 22 '10 at 12:51 PM
thanks a lot for your advice, I will try sql server replication.
answered Feb 22 '10 at 06:04 PM