Test ODBC connection before load start

[louwriet]

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

[MayilVahanan]

Hi

Please refer

ErrorHandling in Qlikview

[Anonymous · Accepted solution]

check this:

Error Handling in Qlikview

Error handling in script

ErrorHandling in Qlikview

Error Handling in Qlikview | Business Intelligence

[Kushal_Chawda]

connection1;

let vError = ScriptErrorCount;

if $(vError )>0 then

connection2;

Trace "Connection2 Successful";

else

Trace "Connection1 Successful";

End if

let vError =null();

[louwriet]

Thank you Mayil , Balraj  and  Kush. All these post helped me.

best regards

Louw