Hi!!

Can anybody out there help me out!!. I am using ADO 2.7 with SQL 2000.

Provider=SQLOLEDB

I had a recordset with following properties.

Cursor Location= adUseServer
Cursor Type= adOpenDynamic
Lock Type=adLockPessimistic

This properties are set to a recordset object.

But for some unknown reason the moment Recordset.Open is called the properties get changed to

Cursor Location= adUseServer
Cursor Type= adOpenForwardOnly
Lock Type=adLockReadOnly

where as in the MSDN online it had mentioned that

Cursor Location= adUseServer
Cursor Type= adOpenDynamic
Lock Type=adLockPessimistic

will work.

I have gone through the microsoft site and other references but none have mentioned any comments regarding this change in behaviour of properties.

Thanks in Adv.

Arnab