odac连接oracle延迟
使用下面连接提供方式连接oracle,出现timeout,没出异常
http://www.flatws.cn/article/program/db/2010-08-23/9146.html
测试代码:
string connStr = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=替换)(PORT=替换))(CONNECT_DATA=(SID=替换)));User Id=替换;Password=替换;"
;
string sql = "select * from tempusers";
OracleConnection conn = new OracleConnection(connStr);
DataTable dt = new DataTable();
try
{
OracleDataAdapter adapter = new OracleDataAdapter(sql, conn);
conn.Open();
adapter.Fill(dt);
}
catch (Exception ex)
{
ClientScript.RegisterClientScriptBlock(GetType(), "", "<script>alert('"+ex.Message+"');</script>");
conn.Close();
}
finally
{
conn.Close();
}
ClientScript.RegisterClientScriptBlock(GetType(), "", "<script>alert('" + dt.Rows.Count + "');</script>");
请教曾经使用过,看懂代码的朋友(dll已引用,已认真检查)