Steve,

Here is one of the solutions:

gnConnHandle = SQLCONNECT(.....)

IF gnConnHandle <= 0
   = MESSAGEBOX('Cannot make connection')
    return
Endif
if type([SQLGETPROP(gnConnHandle,"ConnectBusy")])="L"
*     your code goes here
else
* need to reestablish connection
endif

>I am pretty sure I have asked about this before but I am still don't have a solution and really having trouble with this issue.
>
>When my app starts one of the first things it does is create a connection to an AS400 libarary. Different functions of the app use this connection handle. For some reason the connection will get dropped. I don't know how to trap for the dropped connection. And this dropped connection causes all kinds of problems in the app which depends on it.
>
>I need to trap for drop and re-establish the connection if possible.