Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

web config for multiple connections

1062074Dec 26 2013

I have a web app that I need to set up multiple connections in the web config.

Currently my connection string looks like this:

!--DIWS ODBC Connection String -->

     add key="DIWSOdbcConnection" value="Driver={Oracle in racle9201};Server=1; dbq=STBY; UID=XX_XXX; PWD=1234567890;" />

     add key="DIWSServiceProvider" value="XXXXX.XXX.XXXXXX" />

     add key="DIWSServiceProvider" valu="XXXXX.data.subjects.diwsoracle" />

The real question is this, the connection above is pointed to server 1 and I want this but I also want the connection to server 2 and server 3.  That way if either 1 or two servers goes offline for any reason the web app would still be able to find one server up and running.  Since all data is replicated, integrity is still good.

So how do I set this up with the information above?  Do I simply copy that above info into the config file and where it states server= change the name?  Can I put a comma after the number 1 and add the other server names????

Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 23 2014
Added on Dec 26 2013
0 comments
778 views