[AccessD] SQL Server "wakeup" mystery

 That would be my guess; the system is hibernating and/or powering down in
some way.

  Usually, "wake on LAN" is set, so any network activity is going to get it
going again.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Friday, May 07, 2010 11:18 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] SQL Server "wakeup" mystery

Are the drives going into power down mode or something that would then
cause the lookup to not complete in teh timeout period?  Check power
saving parameters maybe?  Does it happen if someone were to do a disk
access like a folder list or something before the query that fails?

GK

On Fri, May 7, 2010 at 10:01 AM, jwcolby <jwcolby at colbyconsulting.com>
wrote:
> 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.
>
>
> --
> John W. Colby
> www.ColbyConsulting.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com