C#连接Oracle的方法

时间:2021-01-11 06:24:19
C#连接Oracle的方法
方法1:
System.Data.OracleClient
oracleConnectionString : data source = orcl;user id= scott; password=tiger;persist security info=false; 端口不是默认的1225的时候,这个就不适用
方法2:
oracleConnectionString :
Provider=OraOLEDB.Oracle.1;User ID=scott;Password=tiger;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.125.250)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
方法3:
oracleConnectionString:
User ID=scott;Password=tiger;Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST=10.10.125.250)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))