ADO.NET对服务器进行连接Oracle数据库 [英] ADO.NET for connecting Oracle Database on server

问题描述

最近，我们开发了连接到Oracle数据库中获取记录的应用程序。有关读取记录，我们使用的是OLEDB甲骨文。应用程序运行正常我的机器上用甲骨文connectng正确，因为我有Oracle客户端安装在我的机器上。现在，我试图在另一台机器，它亘古不变的有任何Oracle实例/客户端安装在他的机器上进行测试的应用程序。应用程序将无法连接到Oracle中央数据库服务器。是否有必要为用户在其计算机上安装Oracle客户端之前的应用程序与Oracle通信。

Recently we have developed an application which connects to oracle database for fetching records. For fetching records, we are using OLEDB for Oracle. Application runs fine on my machine by connectng properly with Oracle ,since i have oracle client installed on my machine. Now i tried to test application on another machine, which doesnot have any oracle instance/Client installed on his machine. Application fails to connect to oracle central DB Server. Is it necessary for users to install oracle client on their machine before the application communicates with Oracle.

下面是连接字符串

的connectionString =供应商= MSDAORA;数据Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XYZ)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=abc.com)));Persist安全信息= FALSE;用户ID = mahens;密码= XXXXXXXXX的providerName =System.Data.SQLOLEDB/>

connectionString="Provider=msdaora;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XYZ)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=abc.com)));Persist Security Info=False;User Id=mahens; Password=XXXXXXXXX" providerName="System.Data.SQLOLEDB"/>

以上code是OLEDB甲骨文。有什么事情我需要安装用于连接到中央Oracle数据库服务器从我的Windows应用程序（安装在本地计算机上的.NET应用程序）。

The above code is for OLEDB for oracle. Is there any thing i required to install for connecting to central Oracle DB server from my windows application(.NET application installed on local machine).

如果我们试图用ODP.NET DLL和包括dll的沿内BIN目录，将这项工作？..可以any1能告诉我一个方法，其中用户不需要自己的机器上安装任何Oracle客户端和通信服务器。

If we try to use ODP.NET dll and include those dll's along within BIN directory,will that work?..Can any1 tell me a way wherein user need not install any oracle Client on their machine and communicate to server.

-Mahender

-Mahender

推荐答案

我相信你总是需要安装Oracle客户端的一切都在.NET最终使用ODP.NET。但是，您可以使用 Oracle即时客户端，以使您的用户安装过程变得更加容易。

I believe you always need the oracle client installed as everything in .net ultimately uses ODP.NET. However, you can use the Oracle Instant Client to make your users' setup process easier.

这篇关于ADO.NET对服务器进行连接Oracle数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！