Fred,

On how suppress ODBC dialogs, see Re: SqlStringConnection Message #884312.

>Hi Guys,
>I run a batch update that updates SQL Server from VFP 7 using ODBC( SQL Pass-through). I open the connection before every update and close. every half hour or so I keep getting a connection timeout error. It brings up the connection box. click on OK and it continues. When this happens in the middle of the night it stall the whole processing. Is there any fix for this.
>
>TIA