ADODB 2.8 behaves strange while stored procedure call(URGENT)

[spaliwal]

Hi Gurus,

ADODB 2.8
SQL server 2000

We are calling sql server 2000 stored procedure from ADODB 2.8 command object, while using print command in sp its setting the command object's state as completed but stored procedure is still executing, we are using "AdStateExecuting" constant for checking command state , as in given below command segment -

while objCommand.State = adStateExecuting
DoEvents
wend

Our observation is while using cursors in sp body and print statement is fired in cursor body it gives above problem.
It will be great if anybody can suggest a solution for this problem , any alternet way or workaroud.

Thanks,

Sheilesh