为了在 .NET 应用程序中使用 Oracle 而需要安装的 Oracle 客户端组件
我必须从我的 .NET 应用程序连接 Orcle DB（虚拟机）。在阅读了一些教程和文档后，我认识到可以/应该安装几个组件： - Oracle 客户端（不是 Oracle Instant 客户端，因为它没有 tnsping） - ODP.NET 2.0 - ODP.NET 4.0 - Oracle Developer Tools for Visual Studio（包括 Oracle 数据访问组件）
我的建议是安装 Oracle Client 11g（约 601 MB）。然后我发现它不包含 ODP.NET 4.0。
仅安装 Oracle Data Access Components 即可提供 ODP.NET 2.0 和 4.0 位，它使用不包含 tnsping 工具的即时客户端。我需要该工具来检查虚拟机中数据库的连接。
相继安装这两个软件包会禁用之前的配置，因此之后一切都无法正常工作。
您能告诉我到底需要安装什么以及按什么顺序安装吗？正如我所说，我需要 Oracle 连接、tnsping 以及从 Visual Studio 打开连接来检查数据库数据的可能性。
提前致谢。
I have to connect an Orcle DB (virtual machine) from my .NET application. After reading some tutorials and docs I recognized that there are several components which could/should be installed:
- Oracle Client (not Oracle Instant client since it doesn't have tnsping)
- ODP.NET 2.0
- ODP.NET 4.0
- Oracle Developer Tools for Visual Studio (incl. Oracle Data Access Components)
My suggestion was just to install the Oracle Client 11g (ca. 601 MB). Then I fogured out that it doesn't include ODP.NET 4.0.
Only installing Oracle Data Access Components delivers ODP.NET 2.0 and 4.0 bit it uses the instant client that doesn't include the tnsping tool. I need the tool to check the conenctin to the DB in the virtual machine.
Installing both packages after another disables the previous configuration so after it nothing works properly.
Can you tell me what exactly I have to install and in which order? As I said, I need Oracle connecntion, tnsping and some possibility to open connection from Visual Studio to inspect the DB data.
Thanx in advance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我要做的第一件事是确保您获得名为“ODAC [版本] with Oracle Developer Tools for Visual Studio”的最新 Visual Studio 工具包。目前，它位于 http://www.oracle.com/ technetwork/database/windows/downloads/index-101290.html 但这可能会在几年后发生变化。
然后我会安装新下载的安装程序中的所有组件。您确实无需担心普通开发人员桌面上的磁盘空间，因为截至目前下载量仅为 230 MB 左右。 （撰写本文时最新版本为 11.2.0.2.1。）
The first thing I'd do is make sure you get the latest Visual Studio tools package called "ODAC [version] with Oracle Developer Tools for Visual Studio". Currently, it's located at http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html but that may change years from now.
Then I'd install ALL of the components from your newly downloaded installer. You really don't need to worry about the disk space on your average developer's desktop, as it's only around a 230 MB download as of today. (Version 11.2.0.2.1 is current at the time of this writing.)