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








      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.