I added a one-record one-field table to my SQL-Server db and try to open it. You can check this before and after the long update. You can also check out the SQLSetProp() and SQLGetProp() functions.

HTH
Barbara

>Hi Guys,
>I update a SQL Server 7 database over an ISDN line.. I do an update for 150000 records and the line sometimes drops out. Is there any way to check for a valid connection in VFP.. I use SQL Pass Through. does aerroe return any particual number to id the Disconnection ???
>
>TIA