OraOLEDB.Oracle 未显示在 SQL Server Management Studio 提供程序中
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4260413/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
OraOLEDB.Oracle not showing in SQL Server Management Studio providers
提问by BC.
I'm trying to add an Oracle server as a linked server to SQL Server. I've downloaded and installed Oracle's instant client and ODAC software. However, OraOLEDB.Oracle does not show up in the list of providers in SSMS. My machine is running Windows 7 (64 bit) and MSSQL Server 2008 R2.
我正在尝试将 Oracle 服务器作为链接服务器添加到 SQL Server。我已经下载并安装了 Oracle 的即时客户端和 ODAC 软件。但是，OraOLEDB.Oracle 不会显示在 SSMS 的提供程序列表中。我的机器运行的是 Windows 7（64 位）和 MSSQL Server 2008 R2。
回答by kg.
I am trying to fix this same issue. I found this detailed set of instructions, however they didn't work for me. I encountered some installation errors with ODAC. Perhaps they can be of help to you though.
我正在尝试解决同样的问题。我找到了这套详细的说明，但是它们对我不起作用。我在使用 ODAC 时遇到了一些安装错误。或许他们可以帮到你。
Installing 64-bit Oracle ODAC 11.2 to Microsoft SQL Server 2008 R2 x64http://nampark.wordpress.com/2011/01/20/installing-64-bit-odac-11-2-to-microsoft-sql-server-2008-r2-x64-for-replication/
将 64 位 Oracle ODAC 11.2 安装到 Microsoft SQL Server 2008 R2 x64 http://nampark.wordpress.com/2011/01/20/installing-64-bit-odac-11-2-to-microsoft-sql-server- 2008-r2-x64-for-replication/
回答by ejazazeem
OraOLEDB provider is not installed with instant client. You have to install the full client.
OraOLEDB 提供程序未与即时客户端一起安装。您必须安装完整的客户端。
