Oracle连接字符串错误? 返回

SqlSugar 老数据
4 1712

本机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

  • image.png

    本机都登录的好好的……  咋

    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 回复
  • User 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 回复
  • @失灵状态: 可以了 谢谢~!  原来是sql语句写错了……

    0 回复
  • Oracle

    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 回复