Hi all,

I am working on a problem that involves the asynchronous functionality 
implemented by ADO 2.6. The app is in VB6, the database is SQL Server 2000

The application that I am working on implements billing functionality for a
client. For each billing cycle the app needs to invoke a gathering and 
consolidation of outstanding billing. This happens when a stored procedure
(EFTBatch_create) is called. This sp is very intensive, so I am making the 
call asynchronously. Also, this sp returns only 1 record, which is a sanity
check, once all the computations have happened.

Now, the problem is that I am getting a 'Timeout expired' error when I 
execute this stored procedure, even though I am invoking the process 
asynchronously. I have tried to use both an asynchronous recordset as well
as an asynchronous connection in conjunction with a command object, with 
both methods producing the same error.

I have tested the same code on a resultset of ~9000 records and this 
happens 
without a glitch, BUT I am getting a response & the first of the records 
almost immediately, unlike the consolodation process that returns only 
after 
a great many seconds have elapsed. Am I missing something fundamental 
about 
asynchronous ADO behaviour?

Any light on the matter would be greatly appreciated.

Thanks,
Brett