Access Oracle from SQL Server via Linkserver

Full graphics: Http://note.youdao.com/share/?id=e0d195e84962dbf4997925bc6e1b929b&type=note1. On the Windows operating system, install the Oracle Client. Here you can go to the official website to download the client. Here you can refer to my other article: http://blog.csdn.net/whiteoldbig/article/details/21718519

2. Set Tnsnames.oraerpdb= (Description = (address = (protocol = TCP) (host =erpdb.dji.com) (port = 1601)) (Connect_data = (sid = Erpdb)) from start-run-C md window, tnsping erpdb test if you can connect.

3. Create a new Link server object on SQL Server.




This fills in the Oracle account password, of course, we have to build this user in advance, and give the appropriate permissions.

4. Testing
SELECT * FROM OPENQUERY (xxerp, ' SELECT 3+2 from DUAL ') --Return 5

Reference article: