Error "Execute failed: Connection failure" after idling for a couple of hours

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Ray Merant" <xrm98@xxxxxxxxx>
Date: Wed, 5 Mar 2008 13:57:31 -0500

Hi, we are completely stumped on this one. We recently launched an
application with SQL 2005 and Windows 2003 R2 64-bit. We are using the
SNAC. The application is a C++ application and uses the OLEDB API. Some
workstations give the above error after sitting idle for 2-3 hours. It
appears that for whatever reason, the client connection to the server is
terminated when no data is being sent back and forth for a period of time.
Now we have the same app running at other sites without problems. So what
could be causing this? Anything in the server set up? Any tip/suggestions
will be much appreciated

Thanks in advance.

R. Merchant
MDS Inc

.

Prev by Date: Re: Pocket PC w/ SQL Server 2000 and 2005
Next by Date: Re: SQL 2005 Remote Connection Error
Previous by thread: RE: Connection Prodlem-with instance node
Next by thread: Re: Unable to connect if member of many groups
Index(es):
- Date
- Thread

Relevant Pages

Re: client computers not same time as server
... Be sure that in fact Windows Time service has NOT been disabled in services ... This is an indication that you may ... the server and the Workstations for W32time and userenv errors. ... >I have my server set up to get time from the interenet but the workstations ...
(microsoft.public.windows.server.sbs)
client computers not same time as server
... I have my server set up to get time from the interenet but the workstations ... Prev by Date: ...
(microsoft.public.windows.server.sbs)