connectionString="Password=czh;User ID=czh;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.168.211)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=skydream)));"
參數說明:
connectionString="Password=czh;User ID=czh;Data Source=skydream;"
System.Data.OracleClient。string strConn = "Data Source=IP;User ID=帳號;Password=密碼";
using (OracleConnection conn = new OracleConnection(strConn))
{
conn.Open();
string strSql = "SELECT * FROM TableName";
using (OracleDataAdapter da = new OracleDataAdapter(strSql, conn))
{
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
string StrConn = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=*.*.*.*)(PORT=**)))(CONNECT_DATA=(SERVICE_NAME=服務名)));User ID=帳號;Password=密碼;";
using (OracleConnection conn = new OracleConnection(strConn))
{
conn.Open();
string strSql = "UPDATE table1 SET col1='val' WHERE ...";
using (OracleCommand cmd = new OracleCommand(strSql, conn))
{
int result = cmd.ExecuteNonQuery();
}
}
string strSql = "SELECT * FROM tblproject";
using (OracleCommand cmd = new OracleCommand(strSql, conn))
using (OracleDataReader dr = cmd.ExecuteReader())
{
if (dr.Read()) { /* 處理資料 */ }
}
System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
原因:Oracle Home 目錄權限不足,導致 ASP.NET 執行身分(Network Service / ASPNET)無法讀取。
解決:以管理員登入,對 ORACLE_HOME\ora92 資料夾授予 Authenticated Users 讀取/執行權限。