I have a vb application making use of a com dll to make connections to the database and executing stored procedures. one of the classes that i am using has a method which uses disconnected ado recordsets to return back the results after executing the stored procedure. i am getting an error timeout expired when executing a particular stored procedure. The Stored procedure is very complicated and data returned is also huge so it gives me an error only when the data returned back is huge say for 34000 records. i have also tried to increase the connection timeout to 360 but does not help. What could be the problem? here is my code...
Set cnnSupplierItems = CreateObject("ADODB.Connection")
Set rsSuppItems = CreateObject("ADODB.Recordset")
cnnSupplierItems.ConnectionTimeout = 360
cnnSupplierItems.Open "File Name=" & App.Path "\ESCatalog_datasource.udl"

strSQL = "{call sp_findsupplieritem("
strSQL = strSQL & "'" & Utility.RemoveSingleQuote(Trim(strSupplierItemNumber)) & "', "
..... builds the whole strsql string

rsSuppItems.CursorLocation = adUseClient
rsSuppItems.Open strSQL, cnnSupplierItems, adOpenDynamic, , adAsyncExecute

Do While (rsSuppItems.State = adStateExecuting) ...> 'goes to timeout error after a minute or so
Loop
any help would be appreciated
Thanks

Arati