在SQL Server2008 上建立Oracle 链接服务器
来源:互联网 发布:mac word 选项 编辑:程序博客网 时间:2024/05/29 11:08
- Install Oracle Database 10g Client Release 2
- Install using the InstantClient option
- Install Oracle 10g Release 2 ODAC (64-bit, 32-bit)
- Select the Oracle Data Access Components option (not .NET!)
- Edit TNSNAMES.ora
- <install directory>Product10.2.0ClientnetworkADMINTNSNAMES.ora (i.e. C:OracleProduct10.2.0ClientnetworkADMINTNSNAMES.ora)
- There is a very specific format to the network configuration file. Here is an example to get you started (just copy & paste multiple entries if necessary):
DMDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVERNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FRIENDLYNAME)
)
)There are a couple of things you need to change:
- HOST = SERVERNAME. The value SERVERNAME should be changed to reflect the actual address or hostname of the target system.
- SERVICE_NAME = FRIENDLYNAME. FRIENDLYNAME is the name by which you refer to this actual connection.
- REBOOT!
- Configure provider in SQL Server
- Databases→DBName→Server Objects→Linked Servers→Providers→OraOLEDB.Oracle→Properties→Enable “Allow inprocess”
- Create a linked server to the Oracle Database
- General
- Linked Server: A name of your choosing which you will use when querying using four-part naming conventions.
- Provider: Oracle Provider for OLE DB
- Product Name: “Oracle” is fine here
- Data Source: This should match the HOST you defined in TNSNAMES.ora
- Security
- Select Be made using this security context and supply the remote login and password
- General
- Query the linked server:select * from openquery (TESTKM,'select * from DOC_SUBJECT')
- 在SQL Server2008 上建立Oracle 链接服务器
- SQL Server2008访问Oracle时建立OLE_DB链接报错
- SQL Server2008新建ODBC链接服务器
- SQL建立链接服务器
- Sql Server上建Oracle链接服务器
- 如何在Sql Server中建立到Oracle数据库的链接服务器
- 在局域网服务器和互联网上建立链接
- 在Delph上i建立InterBase链接服务器
- 在windows server2008上安装oracle
- sql server建立链接服务器
- PL/SQL Developer链接服务器上的Oracle
- 在SQL Server 2000中添加Oracle链接服务器
- 在SQL Server 2000中添加Oracle链接服务器
- 建立sqlserver指向oracle的链接服务器
- sql server 2005 建立链接服务器
- SQL Server 2012建立链接服务器
- 12、sql server建立链接服务器
- SQL server2008的链接问题
- Tomcat部署web应用的几种方法
- 拯救你的字符串:微有瑕疵的终极救赎
- PDM中BOM管理技术的研究及其应用
- MFC 子对话框向父对话框传递数据
- php获取客户端ip总结
- 在SQL Server2008 上建立Oracle 链接服务器
- 学习FPGA verilog的心得--编程技巧--如何写代码减少逻辑单元的使用数量
- JSP中include指令和include行为的区别
- vmware workstation 7安装MAC操作系统
- opencv 检测直线、线段、圆、矩形
- vc知识积累(2.操作Excel数据库)
- vs 错误1------"无法启动程序'...debug/abc.exe',系统找不到指定文件"的问题!
- BMP格式的分析
- CAB 制作