34,593
社区成员
发帖
与我相关
我的任务
分享sql server 2008 r2的oracle数据库驱动问题
公司刚换的服务器,把数据库也升成了 2008 R2,但是在建立链接服务器时,找不到oracle 数据库驱动，也就是Microsoft OLE DB Provider for Oracle ，请问各位大虾如何解决阿？
...全文
请发表友善的回复…
发表回复
wdearcai 2012-02-21
- 打赏
- 举报
我也遇到这样的问题，在创建链接服务器的时候，访问接口那没有 Microsoft OLE DB Provider for Oracle的选项，您写得英文我看的不是太明白，能用中文再写下解决方法吗
jackluo1981 2011-05-18
- 打赏
- 举报
问题解决了,谢谢大家.同时跟大家分享一下.
1. I downloaded and installed the Oracle 10.2.0.4 64-bit client for Windows 2008 64-bit http://www.oracle.com/technetwork/database/10204-winx64-vista-win2k8-082253.html (need OTN license). Installed the runtime client as well as the windows interfaces (2 installs, same oracle home). I used the same administrative user for both my Oracle client and SQL Server installations, this user also runs my SQL database service.
2. Added the tnsnames.ora entry on the server, sucessfully tested a tnsping <tns entry name> and was able to create and sucessfully test and ODBC connection, and connected via sqlplus remotely to the Oracle database (sqlplus username/pw@<tns entry name>
3. Granted my install account full permissions on my oracle installation folder (F:\Oracle in my case) and c:\windows\temp. This was due to an error with OraOLEDBpus10.dll when I initially tried to setup my linked server.
4. Ran the suggested SQL above when I still was able to test the connection successfully but still got a Microsoft SQL Sevrer Error: 7399, cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB Provider "OraOLEBB.Oracle" for Linked Server.
USE [master]
GO
EXEC master.dbo.sp_MSset_oledb_prop N'OraOLEDB.Oracle', N'AllowInProcess', 1
GO
5. After the above steps, my Linked Server now appears to work.
1. I downloaded and installed the Oracle 10.2.0.4 64-bit client for Windows 2008 64-bit http://www.oracle.com/technetwork/database/10204-winx64-vista-win2k8-082253.html (need OTN license). Installed the runtime client as well as the windows interfaces (2 installs, same oracle home). I used the same administrative user for both my Oracle client and SQL Server installations, this user also runs my SQL database service.
2. Added the tnsnames.ora entry on the server, sucessfully tested a tnsping <tns entry name> and was able to create and sucessfully test and ODBC connection, and connected via sqlplus remotely to the Oracle database (sqlplus username/pw@<tns entry name>
3. Granted my install account full permissions on my oracle installation folder (F:\Oracle in my case) and c:\windows\temp. This was due to an error with OraOLEDBpus10.dll when I initially tried to setup my linked server.
4. Ran the suggested SQL above when I still was able to test the connection successfully but still got a Microsoft SQL Sevrer Error: 7399, cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB Provider "OraOLEBB.Oracle" for Linked Server.
USE [master]
GO
EXEC master.dbo.sp_MSset_oledb_prop N'OraOLEDB.Oracle', N'AllowInProcess', 1
GO
5. After the above steps, my Linked Server now appears to work.
Austindatabases 2011-05-17
- 打赏
- 举报
去ORACLE 的网站上下载64BIT 的驱动，我们同事在上个月已经下载了，并在生成环境中使用
jackluo1981 2011-05-17
- 打赏
- 举报
怎么没人回答呢?
jackluo1981 2011-05-13
- 打赏
- 举报
[Quote=引用 3 楼 fredrickhu 的回复:]
引用楼主 jackluo1981 的回复:
公司刚换的服务器,把数据库也升成了 2008 R2,但是在建立链接服务器时,找不到oracle 数据库驱动，也就是Microsoft OLE DB Provider for Oracle ，请问各位大虾如何解决阿？
有没有相应驱动??
[/Quote]
在系统管理工具的ODBC里也看不见，应该是没有。
引用楼主 jackluo1981 的回复:
公司刚换的服务器,把数据库也升成了 2008 R2,但是在建立链接服务器时,找不到oracle 数据库驱动，也就是Microsoft OLE DB Provider for Oracle ，请问各位大虾如何解决阿？
有没有相应驱动??
[/Quote]
在系统管理工具的ODBC里也看不见，应该是没有。
jackluo1981 2011-05-13
- 打赏
- 举报
[Quote=引用 1 楼 qianjin036a 的回复:]
到ORQCLE网站上下载.
装MSSQL并不默认安装ORQCLE驱动的.
[/Quote]
R2是64位的阿，oracle网站提供的都是32位的驱动安装不上啊
到ORQCLE网站上下载.
装MSSQL并不默认安装ORQCLE驱动的.
[/Quote]
R2是64位的阿，oracle网站提供的都是32位的驱动安装不上啊
--小F-- 2011-05-13
- 打赏
- 举报
[Quote=引用楼主 jackluo1981 的回复:]
公司刚换的服务器,把数据库也升成了 2008 R2,但是在建立链接服务器时,找不到oracle 数据库驱动，也就是Microsoft OLE DB Provider for Oracle ，请问各位大虾如何解决阿？
[/Quote]
有没有相应驱动??
公司刚换的服务器,把数据库也升成了 2008 R2,但是在建立链接服务器时,找不到oracle 数据库驱动，也就是Microsoft OLE DB Provider for Oracle ，请问各位大虾如何解决阿？
[/Quote]
有没有相应驱动??
-晴天 2011-05-13
- 打赏
- 举报
手指安错地方...A~Q.
-晴天 2011-05-13
- 打赏
- 举报
到ORQCLE网站上下载.
装MSSQL并不默认安装ORQCLE驱动的.
装MSSQL并不默认安装ORQCLE驱动的.
