oracle数据库的可连接性 [英] oracle database connectibity

问题描述

我已经在计算机上安装了oracle 11g，我想连接数据库"xyz".
使用我的asp.net Web应用程序.
我的连接字符串.

i have install oracle 11g in my computer and i want to connect my database "xyz "
with my asp.net webapplication.
my connection string.

<connectionstrings>
  <add name="OracleDatabase">
     connectionString="Data Source=xyz ;User ID=SCOTT;Password=tiger;"/&gt;
</add></connectionstrings>

当我尝试运行我的程序时，出现错误
未在ConnectionString中指定OLE DB提供程序.一个示例是''Provider = SQLOLEDB;''

请帮忙.

And when iam trying to run my program i am getting an error
An OLE DB Provider was not specified in the ConnectionString. An example would be, ''Provider=SQLOLEDB;''

please help.

推荐答案

我想您已经忘记为连接字符串包括providerName了.

如果您使用的是ODT，它应该看起来像这样

I guess you have forgotten to include the providerName for your connection string.

If you are using ODT it should look something like this

<add name="ConnectionString" connectionstring="Data Source=xyz;User Id=SCOTT;Password=tiger;" providername="Oracle.DataAccess.Client" />

或者您正在使用ms oracle提供程序应该是这样的:

Or of you are using the ms oracle provider is should look like this:

<add name="ConnectionString" connectionstring="Data Source=xyz;User Id=SCOTT;Password=tiger;">
providerName="System.Data.OracleClient" />
</add>

最好的问候
Espen Harlinn

Best regards
Espen Harlinn

这篇关于oracle数据库的可连接性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！