今天需要在SQL Server上创建linked server,使其能访问Oracle数据库,其主要步骤如下:
http://www.mssqltips.com/sqlservertip/1433/how-to-setup-linked-servers-for-sql-server-and-oracle-64-bit-client/
注意,由于SQL Server,OS都是64位的,所以必须得使用64位的Oracle client,不要装instant client,要装Administrator client。
- Install Oracle 10g Release 2 64-bit client software (available from Oracle website)
- Install Oracle 10g Release 2 64-bit ODAC software (available from Oracle website)
- Restart SQL services
- Configure OraOLEDB.Oracle provider
- Create linked server
- Add remote logins for linked server
http://www.mssqltips.com/sqlservertip/1433/how-to-setup-linked-servers-for-sql-server-and-oracle-64-bit-client/
注意,由于SQL Server,OS都是64位的,所以必须得使用64位的Oracle client,不要装instant client,要装Administrator client。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26277071/viewspace-711622/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26277071/viewspace-711622/