RE: Timeout Expired for no apparent reason

From: Sami Samir (SamiSamir_at_discussions.microsoft.com)
Date: 08/06/04

  • Next message: monstar: "What is MS Project OLE DB provider, how do I access tables in it ?" 
    Date: Fri, 6 Aug 2004 01:07:05 -0700

    How do I set the timeout for transactions? Is it the CommandTimeout property
    of ADO or are you talking about something else? How do I know if it's an
    implicit transation?

    I don't think it will be feasible to break it down into smaller batches.
    This might be my last resort.

    Thanks,
    Sami Samir

    "Steve S" wrote:

    > Sounds like you're doing this all in a single transaction (implicit, rather
    > than explicit), and the whole operation is exceeding the default timeout.
    > According to the documentation, the default is allegedly zero, but it's
    > possible that something is resetting in. In ODBC, this is done by setting a
    > connection attribute, or a statement option, depending on which version
    > you're using.
    >
    > Is it possible to break the recordset down into smaller processing batches ?
    >
    > Steve S
    >
    > "Sami Samir" wrote:
    >
    > > I have a VB 6 Active X DLL that contains a method that opens a recordset and
    > > for each row updates a row in another table and then updates the original
    > > table. The database is a SQL Server 2000 cluster (SP3). My problem is that
    > > when I run this method from an ActiveX script from within a DTS package, I
    > > notice that everything is fine and hundreds of rows are updated per minute
    > > and then after a certain random ammount of time and rows it gives me this
    > > error:
    > >
    > > [Microsoft][ODBC SQL Server Driver]Timeout expired
    > >
    > > Each update takes less than a second and should not be the reason for this
    > > error. Also, I checked if there were any locks on the table, but there
    > > weren't. I use an ODBC connection to connect to the database using MDAC 2.6.
    > > Has anybody experienced a similar case who can help me?
    > >
    > > Thanks and best regards,
    > > Sami Samir

  • Next message: monstar: "What is MS Project OLE DB provider, how do I access tables in it ?"

    Relevant Pages

    • Re: AW5 vs WP 1.1 for 2e
      ... AppleWorks 4 and 5 users did not need to mail in original disks. ... There's a TimeOut updater right on the /Extras disk which updates the ... TimeOut directory, letting the new program replace the old. ...
      (comp.sys.apple2)
    • Re: ieee1394 feature needed: overwrite SPLIT_TIMEOUT from userspace
      ... Unfortunately sending an early response and using a secondary register ... as indication for completed flash writes doesnt work. ... Also I dont like the idea of having such a big timeout for every bus ... If you use unified transactions (i.e. your devices sends ACK_COMPLETE ...
      (Linux-Kernel)
    • RE: VBScript: Remote Desktop Disconnected
      ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... any updates in your thread. ... >> Remote Web Workplace timeout ...
      (microsoft.public.windows.server.sbs)
    • Re: the transaction timeout feature in the 3a driver
      ... The Microsoft SQL Server 2000 ... driver for JDBC doesn't have the transaction timeout feature, however, ... Data Direct ships a 3.x driver that has this feature -- if that's the case ... > transactions that are older than the timeout period. ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Re: transactions per seconds - how many?
      ... For a sproc that does updates, 220 transactions per second is about the best ... > on your sql servers? ... > The sql server runs double xeon machine and 2 scsi drives. ...
      (microsoft.public.dotnet.framework.adonet)