请教:sql server触发器里往ORACLE数据库写数据有办法吗?
如题
[解决办法]
http://blog.csdn.net/fengfangfang/archive/2006/07/28/993882.aspx
[解决办法]
类似这样：
USE master
GO
EXEC sp_addlinkedserver
'svr_lnk ',
'Oracle ',
'MSDAORA ',
'MyServer '
GO
EXEC sp_addlinkedsrvlogin 'LONDON Mktg ', 'false ', 'sa ', 'Admin ', NULL
GO
CREATE TRIGGER TR_1 ON TABLE1
AS
INSERT svr_lnk.dbname.dbo.table2 value(...)
[解决办法]
类似这样：
USE master
GO
EXEC sp_addlinkedserver
'svr_lnk ',
'Oracle ',
'MSDAORA ',
'MyServer '
GO
EXEC sp_addlinkedsrvlogin 'svr_lnk ', 'false ', 'sa ', 'Admin ', NULL
GO
CREATE TRIGGER TR_1 ON TABLE1
AS
INSERT svr_lnk.dbname.dbo.table2 value(...)
