Sql2005 a linked server to an Oracle server

One: Install Oracle client on sqlserver2005 server, run NETCA create Tnsname

Second: Fill in as shown

Where the first line is filled in

Second, three lines: fill in the diagram

Line four: Fill in the Tnsname

650) this.width=650; "style=" width:486px;height:328px; "title=" 1.png "src=" http://s3.51cto.com/wyfs02/M00/6F/4D/ Wkiom1wxu4vgi72caaiyy6px_ku343.jpg "width=" 665 "height=" 491 "alt=" Wkiom1wxu4vgi72caaiyy6px_ku343.jpg "/>

Three: Fill in the following, database login name:

650) this.width=650; "title=" 2.png "src=" Http://s3.51cto.com/wyfs02/M01/6F/4D/wKiom1WXvAbQFXiFAAJZVSAoA-I087.jpg " Width= "689" height= "531" alt= "wkiom1wxvabqfxifaajzvsaoa-i087.jpg"/>

This article is from "one van" blog, please be sure to keep this source http://1336014.blog.51cto.com/1326014/1670943

Sql2005 a linked server to an Oracle server