ODBC Timeout from application

We use an application that, among otehr things, runs queries against
our SQL 2000 server.
It has always ran just fine.

However, today a user tried running one of the built in queries to
retrieve some records and it timed out with a SQL timeout error.
After a bit of investigation I found that it is trying to get more
records than they probably ever have before.

The app uses an existing System DSN to connect to the server. Is
there a way for me to increase the timeout period ?

Thanks,
Paul

Paul:

I see you have had no replies. I'm having the exact same issue,a nd was
hoping you found a solution to the problem. I've been pulling downloads from
our MS SQL 2005 server using MS Access for over a year. The other day it
just stopped returning data with the querry. Seem to be an ODBC timeout
issue.

We've made no changes to the SQL server this week, and no OS updates to the
server. The 90,000 reord DB has grown by ~6800 records this last week.
That's the only change to the systems that we can identify.


Thanks,

Stan


"paul" wrote:

> We use an application that, among otehr things, runs queries against
> our SQL 2000 server.
> It has always ran just fine.
>
> However, today a user tried running one of the built in queries to
> retrieve some records and it timed out with a SQL timeout error.
> After a bit of investigation I found that it is trying to get more
> records than they probably ever have before.
>
> The app uses an existing System DSN to connect to the server. Is
> there a way for me to increase the timeout period ?
>
> Thanks,
> Paul
>