how to detect fatal error with SQL TOOLKIT functions

[lio33]

I use the SQL Toolkit 2.0 with labwindows CVI. 7.1.1

My problem is how to detect cable disconnection (or database loss of connection ) when using SQL Toolkit functions.

DBConnect returns error code and its possible to dectect this problem.

But when a connexion is established, the DBRefreshParams() or DBExecutePreparedSql() functions for example return a FATAL RUN-TIME ERROR.

There is a solution to intercept the error code returned by this functions ?

( Or to avoid application interrupt ).

thanks.

[RobertoBozzolo]

You could try pinging the server before executing critical functions: InetPing () function is available in cvi 7 in the Internet library.

[lio33]

I always use this function at regular interval to detect a disconnection.

But the problem will be the same even if I call the inetPing() function before a call to the SQL Toolkit function.

A disconnection can occur just before the call an stop my software.

I call the NI Support to know if its a SQL library bug ...