在 Windows 7 上连接到 Oracle
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3770665/
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
Connecting to Oracle on Windows 7
提问by Ashar Syed
I have installed Oracle Client 10g 32 bit and ODAC 11g R2 on my Windows 7 machine, but I cannot see any Oracle Providers in MS ODBC Administration or when I try to created a linked server to Oralce in SQL Server Management Studio or in Visual Studio 2010. Can anyone please help me out as what to do? I can connect to Oracle server through SQLPlus but get errors when connecting through VS 2010 using MS providers for Oracle.
我已在 Windows 7 计算机上安装了 Oracle Client 10g 32 位和 ODAC 11g R2，但在 MS ODBC 管理中看不到任何 Oracle 提供程序，或者当我尝试在 SQL Server Management Studio 或 Visual Studio 2010 中创建到 Oralce 的链接服务器时. 任何人都可以帮助我做什么吗？我可以通过 SQLPlus 连接到 Oracle 服务器，但是在通过 VS 2010 使用 Oracle 的 MS 提供程序连接时出现错误。
Please help!
请帮忙！
回答by DCookie
When you installed the Oracle Client, did you also install the ODBC driver? IOW, did you do a custom install and add in the ODBC driver? Unless you do a full client install the ODBC drivers are not installed.
安装Oracle Client的时候，是否也安装了ODBC驱动？IOW，您是否进行了自定义安装并添加了 ODBC 驱动程序？除非您进行完整的客户端安装，否则不会安装 ODBC 驱动程序。
回答by massimogentilini
You're not specifying if your windows 7 installation is 32 or 64 bit.
您没有指定您的 Windows 7 安装是 32 位还是 64 位。
If it's 32 bit then see the previous answer, restart Oracle installer and check that ODBC is selected.
如果是 32 位，请参阅上一个答案，重新启动 Oracle 安装程序并检查是否选择了 ODBC。
If it's 64 bit I advise you to install both the Oracle client in 32 bit (as you did) and also the Oracle 11 client in 64 bit, so that you can use the proper library.
如果是 64 位，我建议您同时安装 32 位的 Oracle 客户端（就像您所做的那样）和 64 位的 Oracle 11 客户端，以便您可以使用正确的库。
In any case I still haven't found a proper way to perform Oracle installation on Windows 7 (64 bit) that works for every client and tool combination, good luck.
无论如何，我仍然没有找到在 Windows 7（64 位）上执行 Oracle 安装的正确方法，该方法适用于每个客户端和工具组合，祝你好运。
回答by Rob Lauer
I struggled with this for a while too, best solution I found was here:
我也为此挣扎了一段时间，我找到的最佳解决方案在这里：
http://dotnetcrap.blogspot.com/2009/08/oracle-client-on-windows-7.html
http://dotnetcrap.blogspot.com/2009/08/oracle-client-on-windows-7.html
