Posted on 2006-11-24
MSSQL 2000 s/p 4
vb 6 s/p 4
Application run on Win2000 Server
I have a application that goes through a database tables and defrags the indexes. These are quite large tables some having over 20 million records.
Set conn = New ADODB.Connection
conn.CommandTimeout = 1800 ' wait 30 min. before time out
conn.CommandTimeout = 1800
Set rs = New ADODB.Recordset
rs.Open SQL, conn, adOpenForwardOnly, adLockReadOnly
However I keep getting a
[Microsoft][ODCB SQL Server Driver] Timeout expired
After about 30 sec.