Asp.net的Oracle链接字符串怎么写
F11TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.1.111)(PORT = 1511))
)
(CONNECT_DATA =
(SERVICE_NAME = F11TST)
)
)
<add name="OracleConnectionString" connectionString="Data Source=172.25.1.111:1511/F11TST;Persist Security Info=True;User ID=tttt;Password=tttt" providerName="Oracle.ManagedDataAccess.Client" />
上面这个是可以写法是可以的
但是换了下面这个就不行了
F11TEST =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)(HOST = 172.25.1.111)(PORT = 1511)
)
(CONNECT_DATA =(SID = BBORB)
)
)
<add name="OracleConnectionString"
connectionString="Data Source=172.25.1.111:1511/F11TST;Persist Security Info=True;User ID=tttt;Password=tttt" providerName="Oracle.ManagedDataAccess.Client" />
<add name="OracleConnectionString"
connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.25.1.111)(PORT=1511))(CONNECT_DATA=(SID=BBORB)(SERVICE_NAME=F11TEST)));User ID=tttt;Password=tttt" providerName="Oracle.ManagedDataAccess.Client" />
这两种都不行,换成SID后,应该怎么写
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.1.111)(PORT = 1511))
)
(CONNECT_DATA =
(SERVICE_NAME = F11TST)
)
)
<add name="OracleConnectionString" connectionString="Data Source=172.25.1.111:1511/F11TST;Persist Security Info=True;User ID=tttt;Password=tttt" providerName="Oracle.ManagedDataAccess.Client" />
上面这个是可以写法是可以的
但是换了下面这个就不行了
F11TEST =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)(HOST = 172.25.1.111)(PORT = 1511)
)
(CONNECT_DATA =(SID = BBORB)
)
)
<add name="OracleConnectionString"
connectionString="Data Source=172.25.1.111:1511/F11TST;Persist Security Info=True;User ID=tttt;Password=tttt" providerName="Oracle.ManagedDataAccess.Client" />
<add name="OracleConnectionString"
connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.25.1.111)(PORT=1511))(CONNECT_DATA=(SID=BBORB)(SERVICE_NAME=F11TEST)));User ID=tttt;Password=tttt" providerName="Oracle.ManagedDataAccess.Client" />
这两种都不行,换成SID后,应该怎么写
...全文
相关推荐
ASP.NET Oracle连接字符串
ASP.NET Oracle字符串连接符
c# asp.net 读取 连接oracle数据库源码(不用安装oracle客户端)
本人亲自实现的demo 。实现不安装oracle客户端开发数据库,没有 oracle环境也可以远程访问oracle数据库的源码。
asp.net与Oracle数据库进行增删改查
进行简单登陆/注册/用表格得形式显示数据,对表格内数据进行修改与删除操作。
Oracle asp.net 简单实例
自己写的Oracle asp.net 简单实例 ,找出了无效连接无法连接的错误原因。
asp.net操作oracle clob字段demo
asp.net操作oracle clob字段demo


Web Services
