Results 1 to 2 of 2

Thread: TimeOut Expired message

Hybrid View

  1. #1
    Tracy Guest

    TimeOut Expired message


    We have a stored procedure that is creating information in tempdb table and using cursors. It is suppose to produce a report of about 1000 records. If we run the stored procedure as a sql query then it works fine. If we run it using the VB app. it times out with the following message:
    [Microsoft][ODBC Sql Server Drive]Timeout expired(#0)

    Is there anything I can do to correct this problem?

    Thank you,

    Tracy


  2. #2
    jeriah Guest

    TimeOut Expired message (reply)

    Yes, your vb developer needs to update the frontend code to allow for a longer time out or no timeout at all...

    see msdn code snipit:

    ' Define a command object for a stored procedure.
    Set cnn1 = New ADODB.Connection strCnn = "Provider=sqloledb;" & _
    "Data Source=srv;Initial Catalog=pubs;User Id=sa;Password=; "
    cnn1.Open strCnn Set cmdByRoyalty = New ADODB.Command
    Set cmdByRoyalty.ActiveConnection = cnn1
    cmdByRoyalty.CommandText = "byroyalty"
    cmdByRoyalty.CommandType = adCmdStoredProc cmdByRoyalty.CommandTimeout = 15


    ------------
    Tracy at 6/19/00 4:41:57 PM


    We have a stored procedure that is creating information in tempdb table and using cursors. It is suppose to produce a report of about 1000 records. If we run the stored procedure as a sql query then it works fine. If we run it using the VB app. it times out with the following message:
    [Microsoft][ODBC Sql Server Drive]Timeout expired(#0)

    Is there anything I can do to correct this problem?

    Thank you,

    Tracy


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •