RE: Timeout Expired on Successful database insert

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 02:00:46 GMT

Hi Randy,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you receive a "Timeout Expired" error
when doing an insert operation to SQL Server 2000 with ADO. If there is any
misunderstanding, please feel free to let me know.

Since "Timeout Expired" is a very general error message, it's quite hard to
tell what is really happening. We have to do more steps for trouble
shooting.

1. Try to install the latest version of service pack and MDAC. VB6 SP6 and
MDAC 2.8 can be downloaded from the following links:

http://msdn.microsoft.com/vstudio/downloads/updates/sp/vs6/sp6/download/defa
ult.aspx
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-
b037-185d0506396c&DisplayLang=en

2. If the problem can be reproduced, please step through the code to see on
which line does the exception thrown. Please also check the code and try to
increase the Command.CommandTimeout property.

3. If the problem still occurs, please try to use SQL Profiler to get the
trace log to see what is happening on the server when error occurs.

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • RE: ODBC & SQLExecDirect
    ... There is a KB article that says that there is a bug in MDAC 2.6 and you ... The Service Pack for MDAC 2.6 can be obtained from ... Please apply latest service pack for SQL Server 2000, SP3, if you have not ...
    (microsoft.public.sqlserver.programming)
  • RE: ODBC & SQLExecDirect
    ... We have MDAC 2.8 installed with service pack 3a. ... >Please apply latest service pack for SQL Server 2000, ... SP3, if you have not ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL - Fast LOCALHOST , Slow IP
    ... What MDAC version? ... older service pack and an older MDAC - 2.6 I think is the ... Try upgrading your MDAC ... version and make sure you are current on your SQL Server ...
    (microsoft.public.sqlserver.tools)
  • Freetexttable Not Finding Inflectional Forms
    ... We're using SQL Server 2005 service pack 1. ... It was my understanding that FreeTextTable automatically includes inflectional forms. ... Or is there a bug somewhere? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Sql Server Agent (2000) erroring out on DTS Packages
    ... DTSRun: Package execution complete. ... and a problem with a missing MDAC dll. ... On Sql Server 7, this was SQLAgentCmdExec. ... Specified driver could not be loaded due to system error 126 (MERANT MSSS ...
    (microsoft.public.sqlserver.dts)