c#访问oracle问题

[chuifengde]

用ole能连oracle,用System.Data.OracleClient.dll方法就不行，老报需要817版客户端或更高版本，我机器是xp的，装了oracle10g的客户端，也装了oracle_net.msi

[liuxum]

把连接的代码贴出来。

[whslovexyp]

恐怕是你自己哪里写错了
string connectionString = "Data Source=Oracle8i;Integrated Security=yes";
using (OracleConnection connection = new OracleConnection(connectionString))
{
connection.Open();
Console.WriteLine("ServerVersion: " + connection.ServerVersion
+ "\nDataSource: " + connection.DataSource);
}

[vlysses]

Integrated Security=yes =》 Integrated Security=true
装8.1.7的客户端吧

[chuifengde]

我的不是webform程序，是winform程序

[chuifengde]

下面是我的代码：需要提示的是：我单独新建一个测试方案，里面就一个连接项目能连上，vb用oraoledb.oracle也能连上
private OracleConnection m_oracleConn = null;

string strConn="Password=xxbb;User ID=xxbb;Data Source=ora817";
try
{
if(m_oracleConn == null)
m_oracleConn = new OracleConnection();
else
m_oracleConn.Close();
m_oracleConn.ConnectionString = strConn;

//连接到数据库
m_oracleConn.Open();
base.m_bolIsConnected =m_oracleConn.State == ConnectionState.Open;
base.m_strConnectionString = strConn;

//如果连接成功则返回真
return(m_oracleConn.State == ConnectionState.Open);
}
catch(Exception exc)
{
base.m_bolIsConnected = false;
throw new DatabaseException(exc.Message);
}

[huxussong]

public System.Data.OracleClient.OracleConnection cnn;
public void Open()
{
cnn = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["Oracle"]);
cnn.Open();
}
public void Close()
{
cnn.Close();
}
然后在webconfig里面加上
<appSettings>
<add key="oracle" value="Data Source=HXS;Persist Security Info=True;User ID=hxs;Password=hxs;Unicode=True"/>
</appSettings>
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=NASA;Persist Security Info=True;User ID=hxs;Password=hxs;Unicode=True" providerName="System.Data.OracleClient"/>
</connectionStrings>


就可以直接用open方法打开了

[huxussong]

对了 还要加上命名空间：
using System.Data;
using System.Data.OracleClient;

[mywisest]

是目录权限问题，把Oracle的安装目录加上Authenticated Users即可。

[mywisest]

是目录权限问题，把Oracle的安装目录加上Authenticated Users读写权限即可。