Oracle连接字符串错误? 返回
本机PL/SQL 的.ora文件:
COMBRAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.67)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = combrain)
)
)
C# 字符串代码:
public static string OracleConnection = @"Data Source=192.168.0.67/combrain;User ID=***;Password=***;";
哪里错了吗? 高手求指教。
热忱回答(4)
-
透心而过 VIP0
2020/9/9
本机都登录的好好的…… 咋
public static string OracleConnection = @"Data Source=192.168.0.67:1521/combrain;User ID=comjk;Password=comjk;";
SqlSugarClient OracleDb = new SqlSugarClient(new ConnectionConfig()
{
DbType = SqlSugar.DbType.Oracle,
ConnectionString = OracleConnection,
InitKeyType = InitKeyType.Attribute,
IsAutoCloseConnection = true,
});
这个死活连不上……
0 回复 -
失灵状态 VIP0
2020/9/11User Id=XX;Password=XX;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=1.2.3.4)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=XX)))
0 回复 -
透心而过 VIP0
2020/9/14@失灵状态: 可以了 谢谢~!
原来是sql语句写错了……0 回复 -
张忠平? ?? VIP0
2020/10/13Oracle
User Id=ISV;Password=ISV;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))备份下
0 回复