SQL :: Linked Server and Oracle

SQL :: Linked Server and Oracle

記錄一下 Linked Server and Oracle 相關資訊

目前 Select * From Oracle9i..HR.DEPARTMENTS 有錯誤

但使用 SELECT * FROM OPENQUERY(Oracle9i, ‘SELECT * FROM HR.DEPARTMENTS) 是可行的

 

如何在 SQL Server 中設定並疑難排解 Oracle 資料庫的連結伺服器

http://support.microsoft.com/kb/280106/zh-tw

How to setup linked servers for SQL Server and Oracle 64 bit client

http://www.mssqltips.com/tip.asp?tip=1433

Linked Severs on MS SQL Part 4, Oracle

http://www.databasejournal.com/features/mssql/article.php/10894_3290801_2/Linked-Severs-on-MS-SQL-Part-4-Oracle.htm

如何在 SQL 2005 中設定連結的伺服器(Linked Server)

http://blog.miniasp.com/post/2008/07/How-to-setup-Linked-Server-in-SQL-Server-2005.aspx

Setting Up an Oracle Linked Server
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=49687&DisplayTab=Article