ODBC SQL Server Driver Timeout Expired 
Author Message
 ODBC SQL Server Driver Timeout Expired

I'm have trouble deleting all records from a table which
has over 1 Million records without getting a timeout
error. I have no trouble if there is less than 400,000
records. Does any one have a possible answer?


Fri, 08 Oct 2004 09:20:02 GMT  
 ODBC SQL Server Driver Timeout Expired
Try increasing the connection and command timeout properties, or set to 0
for infinite wait.

Experiment http://www.adoanywhere.com/download/aaBrowse2_7.zip

--
Michael Collier Bsc (Hons)
Interactive ADO Object Browser
www.adoanywhere.com

--


Quote:
> I'm have trouble deleting all records from a table which
> has over 1 Million records without getting a timeout
> error. I have no trouble if there is less than 400,000
> records. Does any one have a possible answer?



Fri, 08 Oct 2004 20:26:01 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. S1T00[Microsoft][ODBC SQL SERVER DRIVER] TIMEOUT EXPIRED ?????????

2. S1T00[Microsoft][ODBC SQL SERVER DRIVER] TIMEOUT EXPIRED ????

3. [ODBC SQL Server Driver]Timeout Expired

4. ODBC SQL Server Driver Timeout expired

5. [ODBC SQL Server Driver]Timeout expired

6. Timeout Expired Error With SQL server ODBC

7. Timeout Expired Error With SQL server ODBC

8. VB Sql Server Via ADO Problem: [Microsoft][ODBC Sql Server Driver]

9. Timeout expired, [Microsoft OLE DB Provider for SQL Server]

10. VB5, RDO & SQL Server Timeout Expired Error

11. VB 6 / SQL Server 7 App gets Timeout expired (-2147217871) about every 50 minutes

12. Insert date type varible through ODBC SQL server driver to SQL 7.0 database

 

 
Powered by phpBB® Forum Software