C#连接oracle
我想C#连接oracle数据库，在web.config中connectionStrings该怎么配？就类似于SQL的connectionString="Data Source=192.168.1.111;Initial Catalog=xxx9;User ID=sa;Password=123"这种！
第1个回答 推荐于2016-02-24
方法1：
System.Data.OracleClient
oracleConnectionString : data source = orcl;user id= scott; password=tiger;persist security info=false;
方法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)))本回答被提问者采纳
System.Data.OracleClient
oracleConnectionString : data source = orcl;user id= scott; password=tiger;persist security info=false;
方法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)))本回答被提问者采纳
相似回答
