EXEC sp_addlinkedserver 'OracleSvr',
'Oracle 7.3',
'MSDAORA',
'ORCLDB'
GOdelete from openquery(mailser,'select * from yulin')select * from openquery(mailser,'select * from yulin')update openquery(mailser,'select * from yulin where id=15')set disorder=555,catago=888insert into openquery(mailser,'select disorder,catago from yulin')values(333,777)
'Oracle 7.3',
'MSDAORA',
'ORCLDB'
GOdelete from openquery(mailser,'select * from yulin')select * from openquery(mailser,'select * from yulin')update openquery(mailser,'select * from yulin where id=15')set disorder=555,catago=888insert into openquery(mailser,'select disorder,catago from yulin')values(333,777)
我建议你用分析器看看返回值是1或0!如果为0,你可以用sp_configure 设置一下!
还有一点就是权限的问题!
只有 sysadmin 和 setupadmin 固定服务器角色的成员(SA)才能执行 sp_serveroption!
所以我建立你配置CONNECION TIMEOUT,而QUERY TIMEOUT使用ORACLE的默认值,
EXEC sp_serveroption 'TEST', 'CONNECTION timeout', '100'
GO关于ORACLE的QUERY TIMEOUT的配置,你可以看看:http://expert.csdn.net/Expert/topic/2219/2219776.xml?temp=.696026
SET MIN_SALARY = 25000
WHERE JOB_TITLE = 'President'
我想也许使用Oracle的驱动可以设置其query timeout属性,等我再试试
UPDATE HR.JOBS SET MIN_SALARY = '25000' WHERE JOB_TITLE = 'President';然后在查询分析器中执行
UPDATE OPENQUERY(TEST, 'SELECT * FROM HR.JOBS') SET MIN_SALARY = '20000' WHERE JOB_TITLE = 'President'这时候就会发生阻塞。我希望这个查询有一个timeout设置,等待一定时间后自动断开
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q280106
帮你顶