如何使用FailOver为ODP.NET连接字符串配置连接字符串? [英] How do you Configure the Connection String for ODP.NET Connection String with FailOver?

问题描述

从System.Data.OracleClient转换为ODB.NET，需要帮助来转换我的连接字符串.这是我与System.Data.OracleClient一起使用的.

Converting to ODB.NET from System.Data.OracleClient and need help converting my connection string. Here is what I use with System.Data.OracleClient.

SERVER =(DESCRIPTION_LIST =(LOAD_BALANCE =是)(FAILOVER = ON)(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 172.26.140.80)(PORT = 9960))(ADDRESS =(PROTOCOL) = TCP)(HOST = 172.26.140.81)(PORT = 9960)))(CONNECT_DATA =(SERVICE_NAME = tactota)))); uid = XXXXXXX; pwd = XXXXXXXX"

SERVER=(DESCRIPTION_LIST=(LOAD_BALANCE=yes)(FAILOVER=ON)(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.26.140.80)(PORT=9960))(ADDRESS=(PROTOCOL=TCP)(HOST=172.26.140.81)(PORT=9960)))(CONNECT_DATA=(SERVICE_NAME=tactota))));uid=XXXXXXX;pwd=XXXXXXXX"

这是我与ODB.NET一起使用的内容，但未实现上述连接字符串的其他功能.

Here is what I have gotten to work with ODB.NET, but does not implement the other features of the above connection string.

数据源=(DESCRIPTION =(地址列表=(地址=(协议= TCP))(主机= 172.26.140.80)(端口= 9960)))(连接数据=(服务器=专用)(服务名称= tactota)));用户ID = XXXXXXXX;密码= XXXXXXXX;

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.26.140.80)(PORT=9960)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=tactota)));User Id=XXXXXXXX;Password=XXXXXXXX;

这是我尝试将它们组合在一起时得到的，但是不用说它不起作用.

Here is what I got when I tried to roll them together, but needless to say it did not work.

数据源=(LOAD_BALANCE =是)(FAILOVER = ON)(描述=(地址列表=(地址=(协议= TCP))(主机= 172.26.140.80)(端口= 9960))(地址=(协议= TCP) )(主机= 172.26.140.81)(端口= 9960)))(连接数据=(服务名称= tactota))));用户ID = XXXXXX；密码= XXXXX；

Data Source=(LOAD_BALANCE=yes)(FAILOVER=ON)(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.26.140.80)(PORT=9960))(ADDRESS=(PROTOCOL=TCP)(HOST=172.26.140.81)(PORT=9960)))(CONNECT_DATA=(SERVICE_NAME=tactota))); User Id=XXXXXX;Password=XXXXX;

谢谢！

戴夫

推荐答案

终于使它起作用了！这是我想出的

Finally got it to work! Here is what I came up with

数据源=(DESCRIPTION =(LOAD_BALANCE =是)(FAILOVER = ON)(地址_列表=(地址=(协议= TCP)(主机= 172.26.140.80)(端口= 9960))(地址=(协议= TCP) )(主机= 172.26.140.81)(端口= 9960)))(连接数据=(服务名称= tactota))));用户ID = XXXXXXX;密码= XXXXXXXX;

Data Source=(DESCRIPTION=(LOAD_BALANCE=yes)(FAILOVER=ON)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.26.140.80)(PORT=9960))(ADDRESS=(PROTOCOL=TCP)(HOST=172.26.140.81)(PORT=9960)))(CONNECT_DATA=(SERVICE_NAME=tactota))); User Id=XXXXXXX;Password=XXXXXXXX;

这篇关于如何使用FailOver为ODP.NET连接字符串配置连接字符串?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！