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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement