>I have one form open 24/7 and a global connection hanlder open from the main program (lnConn)from time to time the SQL Service become unavailable (please do not focus on this problem cause i am not trying to solve this) due to this, the lnConn becomes useless the form tries to read and write data to back end from time to time using SQL Passthrough like lnSQLResult = SQLEXEC(lnConn,"select * from table")
>i know if lnSQLResult is -1, this means something went wrongI know aerror retrieves the error from the SQLEXEC
>I Know element 1,1 is a Error Code
>I know element 5 is a error code too
>
>my question to you guys is the foloowing: what are the codes i have to test in order to know that there is a broken link between the computer and the SQL Server??best regards

I believe we do have some code, but I could not find it at the moment. So, I think the simplest way to test if the connection is still working is to do
send SELECT @@VERSION using SQLExec and the handle and trap the error.