[dba-SQLServer] ODBC Timeouts from SQLServer?

John Skolits askolits at ot.com
Wed Oct 4 12:01:58 CDT 2006


Thanks guys.
I'll try some of your suggestions and see what happens.


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
artful at rogers.com
Sent: Wednesday, October 04, 2006 12:40 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] ODBC Timeouts from SQLServer?

You're right, Francisco, Access will time-out before SQL does. The immediate
solution is to set the timeout to zero seconds (which equals forever).

This is qualified by asserting that any given query should be exeucuted in
QA first, so you can see what the time is in pure SQL. If the time is
acceptable in QA, then either investigate using the Profiler or else the
problem lies in the front end. 

----- Original Message ----
From: Francisco Tapia <fhtapia at gmail.com>
To: dba-sqlserver at databaseadvisors.com
Sent: Tuesday, October 3, 2006 7:28:07 PM
Subject: Re: [dba-SQLServer] ODBC Timeouts from SQLServer?

One method is to run your queries in the Query Analyzer to see just
how long they take, another method is to turn on the Sql Profiler to
find out exactly how long they are taking, you'll need to be available
for both.  Many times IME it's been access that times out before sql
server tho...

--
Francisco

On 10/3/06, John Skolits <askolits at ot.com> wrote:
> I have a bunch of reports that run at night (within Access MDB).
> The database is triggered by using command line arguments.
> Sometimes, I get an ODBC timeout error, but it's very inconsistent.
> I set all the query ODBC timeouts to 300 seconds.
> These routines run at about 2:30 AM to avoid heavy server loads. But, I do
> know, there are other backups and such running that take processor time,
but
> my MDB queries typically run very fast.
>
> Is it possible SQLServer is timing out instead of Access and that's why
the
> messages are happening.
>
> There are many more ways I can optimize the queries, which is the next
step,
> but how to I find out what the SqlServer ODBC timeout value is and how do
I
> change it?
>
> John
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
-Francisco
http://sqlthis.blogspot.com | Tsql and More...
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com






More information about the dba-SQLServer mailing list