Fred,

Just a WAG. Views will create their own connection if the share connection is not checked. Even a sqlconnect() and a view will have two connections.

>Hi Guys,
>I run a batch update that updates SQL Server. 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