摘要:ASP.NET (c#) Oracle資料庫連線設定
//System.Data.OracleClient.dll是放在WINDOWS\Microsoft.NET\Framework\v2.0.50727
Import Namespace ="System.Data.OracleClient"
01 
var cn = new OracleConnection();
02 cn.ConnectionString = "Data Source=xxxx;Persist Security Info=True;User ID=xxxxx;Password=xxxx;Unicode=True";
03 cn.Open();
04 if(cn.State == System.Data.ConnectionState.Open)
05
{
06
Response.Write("開啟.</p>");
07 //cn.Close();
08
}
09 if(cn.State == System.Data.ConnectionState.Closed)
10
{
11 Response.Write("關閉.</p>");
12
}
var cn = new OracleConnection(); 02
cn.ConnectionString = "Data Source=xxxx;Persist Security Info=True;User ID=xxxxx;Password=xxxx;Unicode=True"; 03
cn.Open(); 04
if(cn.State == System.Data.ConnectionState.Open) 05
{ 
06
Response.Write("開啟.</p>"); 07
//cn.Close(); 08
} 09
if(cn.State == System.Data.ConnectionState.Closed) 10
{ 
11
Response.Write("關閉.</p>"); 12
}參考資料：http://msdn.microsoft.com/en-us/library/system.data.oracleclient.aspx