http://download.csdn.net/detail/u014019244/9061209
①.「訪問接口」選擇「Oracle Provider for OLE DB」;
②.「產品名稱」輸入「oracle」;
③.「數據源」輸入:(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.247.5)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)))
④.在「安全性」界面,勾選「使用此安全上下文建立連接」,輸入「遠程登錄」和「使用密碼」(oracle的登錄名和密碼):
⑤.「服務器選項」的界面的設置如下圖:
SELECT * FROM OPENQUERY(his,'select * from HIS.r_patientinfo WHERE ROWNUM < 100')