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后,应该怎么写