Ok,

Once you create the connection you should use SQLSetProp() to make sure you dont have a timeout that will close the connection on you. You want the connection to stay open until you close it.

BOb


>Hi Bob,
>
>No views involved.
>Simply using:
>
>SQLStringconnect("Driver=SQLServer;Server=SYSDEV;Database=Carter;Trusted_Connection=YES")
>
>Not sure what is causing the problem. Probably just gonna have to trace thru all the new steps to see if there is a SQLDisconnect() or something that has slipped into the scene.
>
>Thanks...
>
>Keith