2 Replies Latest reply: Jul 16, 2012 6:52 AM by amay_patil RSS

    Two different connection strings

      Hi all,

       

      I have to two database connection strings which are from two different oracle database servers but contains same tables and views.

      I need to connect to main database server, if connection is successful then i will use this connection string else, I will connect to secondary database server and use secondary connection string to pull the data.

       

      I think script would be like this,

       

      if ConnectionString1='Success' then

       

      ConnectionString1

       

      Else

       

      ConnectionString2

       

      End if

       

      Now how do I check if first/second connection is successful or not in script?

       

      Any help would be great.

       

      Thanks in advance.

       

      Cheers,

      Amay.