Can't use sproc in disconnected recordsets?

[mkuan]

A disconnected recordset needs recordset's "UpdateBatch" method to update the database.

I read somewhere that if the recordset was not created from a SQL statment, one cannot use "UpdateBatch" method. So, what if I create my recordset from a sproc? Does that mean that I can't set the recordset cursor location in my MTS component to "adUseClient" to create a disconnected recordset that is updateable, if I want to use sprocs in my queries?

TIA.


Min.

 

[vishnuprasad]

If u use aduseclient which is disconnected , it is not possible to use updatebatch.