oracle odac 11.2.0.4 xcopy 在 vs2012 中安装并连接到数据库
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21994647/
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
odac 11.2.0.4 xcopy install and connect to database in vs2012
提问by Lavandil
I had oracle 11.2.0.3 x32 that have odac with universal installer. After installing odac I could see oracle provider in Visual Studio 2012 Connect to Database window. Now with oracle 11.2.0.4 x64 after installing odac 64-bit ODAC 11.2 Release 5 (11.2.0.3.20) Xcopy for Windows (http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html) I don't see oracle provider in Connect to database window of VS2012. I tried this:
我有带有通用安装程序的 odac 的 oracle 11.2.0.3 x32。安装 odac 后，我可以在 Visual Studio 2012 Connect to Database 窗口中看到 oracle provider。现在在安装 odac 64 位 ODAC 11.2 第 5 版 (11.2.0.3.20) Xcopy for Windows 后使用 oracle 11.2.0.4 x64 ( http://www.oracle.com/technetwork/database/windows/downloads/index-090165. html) 我在 VS2012 的连接到数据库窗口中没有看到 oracle 提供程序。我试过这个：
install.bat all c:\odacpath odac
"where "odac" is the Oracle Home Name that was used at install time".
“其中“odac”是安装时使用的 Oracle Home 名称”。
I changed odac to "\app\Admin\product\11.2.0\client_1", and "OraClient11g_home1", but this didn't help.
我将 odac 更改为“\app\Admin\product\11.2.0\client_1”和“OraClient11g_home1”，但这没有帮助。
I need explanation how to do this right, maybe I have to set environment variables or do something else.
我需要解释如何正确地做到这一点，也许我必须设置环境变量或做其他事情。
EDIT:I can't find odac with oracle developer tools for my version of oracle(11.2.0.4).
编辑：对于我的 oracle(11.2.0.4) 版本，我找不到带有 oracle 开发人员工具的 odac。
回答by Nick Krasnov
To be able to connect to an Oracle instance using Visual Studio's Database explorer\Data connectionsyou need to install appropriate version of ODAC with Oracle Developer Tools. xCopy version of ODAC provides you only with Oracle Data Access Components. Also note, as Visual Studio Express does not support add-ins, you won't be able to use ODAC with ODT with express version of visual studio 2012.
为了能够使用 Visual Studio 连接到 Oracle 实例，Database explorer\Data connections您需要使用 Oracle Developer Tools安装适当版本的ODAC。ODAC 的 xCopy 版本只为您提供 Oracle 数据访问组件。另请注意，由于 Visual Studio Express 不支持加载项，因此您将无法将 ODAC 与 ODT 与 Visual Studio 2012 的快速版本一起使用。
