/************* Oracle **************/
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)
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)
这是我原来的写法,可是总是提示未能找到 OLE DB 提供程序 。
'Oracle',
'MSDAORA',
'ORA9I'
go
***************************
exec sp_addlinkedsrvlogin 'orasvr', 'false', NULL,'name', 'pwd'
go
**********************
select * from OPENQUERY(orasvr,'select column1,column2 from table ')