Question

ASP.NET怎样连接oracle数据库?

Answer 1

1.打开 安装目录D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN文件夹下的tnsnames.ora文件,进行如下配置：

TOPTEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.10.9)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = toptest) ) )

在web.config文件中添加连接字符串,如：
<add name="OracleConn" connectionString="Data Source=TOPTEST;User ID=ds1;Password=ds1;Unicode=True" providerName="System.Data.OracleClient"/>
2.如果程序与数据库在同一台计算机上,则可以用这一连接。
<add name="OracleConn" connectionString="Data Source=10.100.1.9;User ID=ds1;Password=ds1;Unicode=True" providerName="System.Data.OracleClient"/>
3.使用连接字符串访问数据库
public static readonly string connectionString = ConfigurationManager.ConnectionStrings["OracleConn"].ConnectionString;
4.按照以上的步骤进行操作，ASP.NET就能够成功地访问Oracle数据库

Answer 2

public int OracleExecuteNonQuery(string SQL,string ConnectionString)
{

//Oracle ConnectionString="Data Source=dx;user=system;password=manager;"

int rs=-1;
System.Data.OracleClient.OracleConnection conn = new OracleConnection(ConnectionString);
System.Data.OracleClient.OracleCommand cd = new OracleCommand(SQL, conn);

try
{
conn.Open();
rs=cd.ExecuteNonQuery();
}
catch(Exception ex)
{
//fn.WriteLog("Oracle 执行查询失败。错误原因："+ex.Message);
}
finally
{
cd.Dispose();
conn.Close();
}
return rs;
}
给你个例子。需要增加个 System.Data.OracleClient 引用。

Answer 3

用oracleconnection类,和sqlconnection一样的.
oracleconnection conn= new oracleconnection(string connstr);
conn.open();