哪个Oracle驱动程序适用于必须与Oracle 9,10和11服务器通信的Windows 2008 R2服务器 [英] Which Oracle driver is appropriate for a Windows 2008 R2 server that must talk to an Oracle 9, 10 , and 11 server

问题描述

哪个Oracle驱动程序适用于必须与Oracle 9,10和11服务器通信的Windows 2008 R2服务器？一旦我们知道哪个驱动程序可以与这三个驱动程序通信，我就需要安装在服务器上。

Which Oracle driver is appropriate for a Windows 2008 R2 server that must talk to an Oracle 9, 10 , and 11 server? I need that installed on a server once we know which driver can talk to all three.

推荐答案

使用最新的（12c） - 它也适用于旧的驱动程序...

http://www.oracle.com/technetwork /topics/dotnet/utilsoft-086879.html [ ^ ]

Use the latest (12c) - it will work with old-ones too...
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html[^]

如果说： Windows 2008 R2服务器必须与Oracle 9,10 通信，则表示链接服务器...



......答案就在这里： OLE DB的OLE提供程序 [ ^ ]

确保运行Microsoft的服务器上的Oracle客户端软件SQL服务r处于提供者要求的级别。 Oracle DB for OLE DB（8.1.7.3.0）需要Oracle Client 8.1.7.0。

其他信息：

如何设置链接服务器并对SQL Server中的Oracle数据库进行故障排除 [ ^ ]

在64位SQL Server中为Oracle创建链接服务器 [ ^ ]



如果没有（您想要安装Oracle服务器），请参阅官方文档： Oracle安装指南Windows.pdf [ ^ ]

If by saying: "Windows 2008 R2 server that must talk to an Oracle 9, 10" you mean linked server...

...the answer is here: Oracle Provider for OLE DB[^]
Make sure the Oracle client software on the server that is running Microsoft SQL Server is at the level required by the provider. The Oracle Provider for OLE DB (8.1.7.3.0) requires Oracle Client 8.1.7.0.
Additional info:
How to set up and troubleshoot a linked server to an Oracle database in SQL Server [^]
Creating a Linked Server for Oracle in 64bit SQL Server [^]

If not (you want to install Oracle server), please, see official documentation: Oracle installation guide for MS Windows.pdf[^]

这篇关于哪个Oracle驱动程序适用于必须与Oracle 9,10和11服务器通信的Windows 2008 R2服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！