DotNet访问Oracle

方法一：通过System.Data.OracleClient(需要安装Oracle客户端并配置tnsnames.ora)

string strcnn = "User ID=lportal;Password=lportal;Data Source=zhbrserverORCL;";

System.Data.OracleClient.OracleConnection cnn = new System.Data.OracleClient.OracleConnection(strcnn);

cnn.Open();

MessageBox.Show(cnn.State.ToString());

cnn.Close();

 

方法二：通过System.Data.OracleClient(需要安装Oracle客户端不需配置tnsnames.ora)

string strcnn = "User ID=lportal;Password=lportal;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = zhbrserver)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))";

System.Data.OracleClient.OracleConnection cnn = new System.Data.OracleClient.OracleConnection(strcnn);

cnn.Open();

MessageBox.Show(cnn.State.ToString());

cnn.Close();

 

方法三：通过System.Data.OleDb和Oracle公司的驱动

string strcnn = "Provider=OraOLEDB.Oracle.1;User ID=lportal;Password=lportal;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = zhbrserver)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))";

System.Data.OleDb.OleDbConnection cnn = new System.Data.OleDb.OleDbConnection(strcnn);

cnn.Open();

MessageBox.Show(cnn.State.ToString());

cnn.Close();

 

方法四：通过System.Data.OleDb和微软公司的Oracle驱动

string strcnn = "Provider=MSDAORA.1;User ID=lportal;Password=lportal;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = zhbrserver)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))";

System.Data.OleDb.OleDbConnection cnn = new System.Data.OleDb.OleDbConnection(strcnn);

cnn.Open();

MessageBox.Show(cnn.State.ToString());

cnn.Close();

备注：

1、   XP操作系统已经安装了微软公司的Oracle驱动C:/Program Files/Common Files/System/Ole DB/msdaora.dll

2、   该驱动需要Oracle客户端的三个文件(oraocixe10.dll、oci.dll、ociw32.dll)方在System32下即可

====================================================

PS：使用Oracle公司提供的.net Provider也是不错的选择