timeout expired

timeout expired

Post by Daniel Canha » Sun, 06 Jun 1999 04:00:00



Hello,
    I'm using VC++ 5.0 with CRecordSet and an ODBC
connection to SQL Server 6.5.  I was having problems with
temdbp overflowing the dataspace size when I was creating a
15M+ row Table. I started opening and closing the table
every so often to force a commit to keep the tempdb size
down.  Now I get an error box that says "timeout expired",
which I assume is the app losing it's ODBC connection
because the server is too busy dumping tempdb to respond.  I
tried several ways to increase the timeout duration.  First
I put

#undef DEFAULT_QUERY_TIMEOUT
#define DEFAULT_QUERY_TIMEOUT 480

The default was 15 seconds, but this seemed to have no
effect on the error messages.  Next attempt was:

int sTime = 600;
VOID SetODBCTimeout (SHORT sTime);

That is the syntax in the example, but that didn't seem to
help either.  Next I tried to issue the following command
before doing a ".Open()" on the table.:

pData->m_DataSet.SetQueryTimeout(0);

This is supposed make it so there is no timeout, but I was
still getting the error message.  Any suggestions??

            Daniel Canham

 
 
 

1. [OBDC SQL Server Driver][Timeout Expired] - How to reconfigure the timeout

When running a query on a very large database, I receive this error after
30-50 seconds:
[Microsoft][OBDC SQL Server Driver][Timeout Expired]

We are using NT and 98. I receive this error message running the queries on
the client and the server. We just switched over from Access 97, which was
unable to handle the amount of data. Using Access 97 ODBC pass-through
queries, we recevied a similar error message, but it was a simple fix -
select properties and change the timeout.

This doesn't happen with queries that return only a small number of rows.
The queries I am receiving the error message on are attempting to return 7-8
million rows.

The default timeout setting is 10 minutes, and so far that is the only
setting I can find.

I appreciate any help on this matter!

2. SQL

3. timeout expired and/or PCAnywhere hangs???

4. URL access

5. TIMEOUT EXPIRED

6. Interesting problem _ SQL Query

7. ODBC SQL Server Driver: Timeout Expired (80040e31)

8. Adding rowset with OLE DB in VC++

9. Timeout Expired

10. timeout expired!!!

11. Timeout Expired Error w/ SQL 7

12. ?Timeout expired

13. MS SQL 7.0 : Timeout expired!!!