4 Replies Latest reply: Dec 29, 2015 7:03 AM by Louwrie Terblanche RSS

    Test ODBC connection before load start

    Louwrie Terblanche

      Hi,

       

      I have a senario where i load data once a day from several databases via ODBC connections.(connectionstrings).

       

      My problem is that this is a automated load process and sometimes when i have a problem with one connection the load stop to display connection error. What i would like is that if a ODBC connection is not successfull the load must carry on with the next connection of the following databases and skip the database that has a connection problem.

       

      I was thinking in the line of : 

                                                  IF connection1 success    // HOW CAN I TEST CONNECTION WITHOUT HALTING  ALL THE LOADS.

                                                       THEN

                                                            LOAD database1

                                                       END

       

                                                     IF connection2 success  

                                                    THEN

                                                            LOAD database2

                                                       END

       

      Help would be appreciated.

       

      Regards

      Louw