如何在不安装Oracle客户端的情况下连接到Oracle数据库

本文介绍了如何在不安装Oracle客户端的情况下连接到Oracle数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我开发了一个VB.Net应用程序，它连接到数据库，执行查询并将结果提取到文本文件中，用于进一步处理。为此，我在我的机器上安装了Oracle 11g。 现在我必须将此应用程序部署到50-60个用户将使用它的客户端。我们无法在所有计算机上安装Oracle客户端。 如果没有安装Oracle客户端，我们将收到TheOraOLEDB.Oracle提供商未在本地计算机上注册。 有没有办法在不安装Oracle客户端的情况下运行应用程序。 PS：应用程序是在64位系统上开发的。 在此先感谢， 问候， Ashish

Hi, I have developed a VB.Net application which connects to database, executes a query and fetches result in a text file, which is used for further processing. For that i had installed Oracle 11g on my machine. Now i have to deploy this application to client where 50-60 users will be using it. We can't install Oracle Client on all the machines. Without installing Oracle Client, we are getting "The "OraOLEDB.Oracle" Provider is not registered on local machine". Is there any way to run the application without installing Oracle Client. PS: Application has been developed on 64bit system. Thanks in advance, Regards, Ashish

推荐答案

没有某种客户端软件就无法访问Oracle数据库。 但是你可以简单地包含Oracle Instant Client [ ^ ]与您的软件二进制文件。 它有多种版本，你需要的版本是ODAC。 You cannot access an Oracle DB without some kind of client software. But you can simply include the Oracle Instant Client[^] with your software binaries. It comes in several flavours and the version you need is ODAC.

是的我们可以将我们的应用程序连接到oracle db而不在我们的本地pc上安装oracle客户端，它可以通过使用oracle的第三方ADO数据提供程序来完成。 市场上有很多供应商，根据我的实际经验，我建议你试试以下供应商 Devart DotConnect for Oracle / [ ^ ] Yes we can connect our application to oracle db without oracle client being installed in our local pc, it can be done by using third party ADO data provider for oracle. There are lot of providers available in the market, From my practical experience I suggest you to try this below provider Devart DotConnect for Oracle/[^]

每当你想直接说话时使用Oracle服务器，需要名为SQL * Net的专有协议，并且需要安装Oracle Client。 如果你真的无法安装Oracle客户端，例如，在很多需要与Oracle服务器通信的机器上（远程或非远程），可能需要3层，再加上VB转换为基于浏览器的应用程序。 第一层是您的客户 - 对于我们的情况，我们可以使用浏览器，现在安装在每台计算机上。这将与第2层服务器（或称为我们的自制应用程序服务器）讨论HTTP流量。并且您可以使用此工具来帮助转换： forums.asp/t/1178898.aspx?+Convert+VB+Net+Web+Site+to+Web+应用程序+项目 [ ^ ] 第二层：这是安装了Oracle客户端的Apache服务器，以及其他可以安装的组件将通过Apache Server（或任何HTTP服务器）传输的HTTP流量转换为VB客户端的流量。只需要一台2层机器。 第3层是你的数据库服务器。 Hi, Whenever you want to talk directly with the Oracle server, the proprietary protocol called SQL*Net is needed, and that comes with "Oracle Client" installation. If u really cannot install Oracle client, eg, on so many machines (remotely or not) that need to talk to the Oracle server, it is possible, then you need 3-tier, plus converting the VB to a browser - based application. First tier is your client - which for our case, we can use a browser, which is installed in every computer nowadays. That will talk HTTP traffic with a tier 2 server (or called it our homebrewed application server). And you can used this tool to help out the conversion: forums.asp/t/1178898.aspx?+Convert+VB+Net+Web+Site+to+Web+Application+Project[^] Tier two: this is a Apache server with Oracle client installed, plus other component that can convert the HTTP traffic coming via Apache Server (or any HTTP server) to that of VB client. Just one tier 2 machine is needed. Tier 3 is your database server.