[AccessD] SQL Server "wakeup" mystery

This sounds logical.  My only issue is "for the past few months or so".  Why does this suddenly appear?

Of course recollection is a strange thing.

John W. Colby
www.ColbyConsulting.com


Jim Lawrence wrote:
> Hi John:
> 
> It is a timing / time out issue. Either extend the connecting time-out or
> force a loop and retry if the appropriate connection is not established on
> first pass... have done that for years.... very typical. 
> 
> Jim
> 
>  
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Friday, May 07, 2010 8:01 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] SQL Server "wakeup" mystery
> 
> Guys,
> 
> I got the following in an email from a customer.  Does anyone have any
> ideas?
> 
>  >John - For the past 3 months (or so) there seems to be a problem regarding
> the access to the check 
> info that resides on the SQLSERVER on PSSERVER.
> 
>  >The pattern we seem to be seeing is that the first time someone tries to
> access the check info in 
> DISCO the check screen fields display "?????" . When They get out and go
> back into it again the 
> check info is present.  Then for the balance of the day all is fine.
> 
>  >John says he has a similar problem when running reports from PSSERVER.  He
> initiates the report, 
> it hangs, he kills it, then reruns and then it is OK.
> 
>  >It just appears like there is a "wakeup" issue going on when anyone
> initially access the SQLSRVR 
> on PSSERVER.
> 
>