Can anyone help me sloving the ODBC & SQL problem? I use ASP to add records<BR>in SQL table using ADDNEW or UPDATE method but my browser return the<BR>following message:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e31&#039<BR>[Microsoft][ODBC SQL Server Driver]Timeout expired<BR><BR>I got these problem in some tables. Sometimes it happens when the record<BR>number reaches to certain limit, but sometimes that limit various and I<BR>don&#039t know why. I have to delete some records in order to execute the ASP<BR>containing ADDNEW or UPDATE method. This problem has frustrated me for long<BR>time and I totally have no idea about what &#039s the problem.<BR><BR>I have tried the following method to solve the problem but failed:<BR>-expand the size of database<BR>-increase the CONNECTION.TIMEOUT and COMMAND.TIMEOUT to 60<BR>-add close the recordset and connection<BR>-set the recordset and connection to NOTHING<BR><BR>Can anyone give me some ideas?<BR>