Printable View
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
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