Global Temp Table Drop problem

Hi,

I am facing a strange problem with MS SQL server.
I have one Stored Proc named MyChildSP, which is being called from another stored procedure name MyParentSP. Now I have some data in the temp table ##CurVal, which is created in MyParentSP stored proc. The data in this table is being used the MyChildSP stored proc (Since this is a global temp table, we can use it among different stored proc.).

Now, when I execute the MyParentSP stored proc from SQL Server Qry analyser, it wroks fine.

But .. but ... but.......

I execute MyParentSP stored proc using the ADODB command object and fetch the result in the ADODB recordset object. Now, there is an error while playing with the recordset object. In this case the Drop table commands in the MyParentSP stored proc are not executed. Can anyone tell me why is this happening ? Since the SP is executed and the records are already fetched in the recordset object.

(I have tested by inserting the values in the user table as the control moves in the MyParentSP stored proc.)

Please let me know if anyone has an explanation to this ASAP.

Thanking you in advance.

Cheers
Yogesh