下面是asp.net连接远程Oracle数据库服务器步骤:
1.asp.net连接oracle服务器需要添加Sytem.Data.OracleClient命名空间,将System.Data.OracleClient.dll加入到项目中。
2.连接时需要ConnectionString字符串,出现在web.config文件中,如下所示:
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=你的数据库服务器ip)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=你的数据库实例名)));User ID=scott;Password=tiger;Unicode=True" providerName="System.Data.OracleClient"/>
</connectionStrings>
如下所示:
- connectionStrings>
- <add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=kingcat)));User ID=system;Password=sun;Unicode=True" providerName="System.Data.OracleClient"/>
- </connectionStrings>
connectionStrings> <add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=kingcat)));User ID=system;Password=sun;Unicode=True" providerName="System.Data.OracleClient"/> </connectionStrings>
上面的连接字符串添加了tns解析字符串,不需要再有OracleClient,否则需要安装,经过上面两步,在.Net Framework 2.0中远程连接Oracle 10g数据库服务器测试通过。
3.
- <SPAN style="FONT-SIZE: x-small"> OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
- try
- {
- conn.Open();
- OracleCommand cmd = conn.CreateCommand();
- cmd.CommandText = "select * from student";
- OracleDataReader odr = cmd.ExecuteReader();
- while (odr.Read())
- {
- Response.Write(odr[1].ToString());
- }
- odr.Close();
- }
- catch (Exception ee)
- {
- Response.Write(ee.Message);
- }
- finally
- {
- conn.Close();
- }</SPAN>
OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
try
{
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from student";
OracleDataReader odr = cmd.ExecuteReader();
while (odr.Read())
{
Response.Write(odr[1].ToString());
}
odr.Close();
}
catch (Exception ee)
{
Response.Write(ee.Message);
}
finally
{
conn.Close();
}