我的连接代码如下:但报错 tempSqlConnection1 = new OleDbConnection("Provider=MSDAORA;DSN=test;User ID=test;Password=test;");
tempSqlConnection1.Open();test为配好的服务名,用Net config assiant 测试通过{"ORA-12560: TNS: 协议适配器错误"}
tempSqlConnection1.Open();test为配好的服务名,用Net config assiant 测试通过{"ORA-12560: TNS: 协议适配器错误"}
user id=用户;password=密码;data source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=地址)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=服务名)))
using System.Data.OracleClient;
public readonly OracleConnection conn = new OracleConnection(ConnectionString);
conn.Open();//也可以用Oracle提供的Client
<add key="OracleConnString"
value="user id=lab;data source=oracledb;password=123"/>
</appSettings>测试没问题