asp.net连接oracle说明

一、安装oracle客户端 二、win7 win2008系统将“Authenticated Users”这个用户组权限加载oracle客户端安装目录上。 三、重启电脑。 一个连接测试语句： System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(); string connString = "User ID=tik_ch;Password=12332;Data Source=(DESCRIPTION=(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(Host =192.168.0.1)(Port = 1521)))(CONNECT_DATA = (SID = ORCL)))"; conn.ConnectionString = connString; try { conn.Open(); } catch (Exception ex) { System.Data.DataSet dss = new DataSet(); DataTable dt = new DataTable(); dt.Columns.Add("Msg"); DataRow dr = dt.NewRow(); dr["Msg"] = ex.Message; dt.Rows.Add(dr); dss.Tables.Add(dt); return dss; } System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand(); cmd.Connection = conn; cmd.CommandText = "SELECT * FROM V_OPERATOR"; System.Data.OracleClient.OracleDataAdapter da = new System.Data.OracleClient.OracleDataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); return ds;