ADO

[Guest]

Does anybody know anything about ADO disconnected recordsets.

I have been searching the net for two weeks now but can find nothing on disconnected recordsets.

I have been programming in VB6 for two years and have had quit a success with disconnected resordsets with the following code:-

Dim acUpdateable As Connection

Set acUpdateable = New Connection
acUpdateable.Open gBRDataBase

Set rsUpdateable = New ADODB.Recordset

rsUpdateable.CursorLocation = adUseClient
rsUpdateable.LockType = adLockBatchOptimistic
rsUpdateable.CursorType = adOpenForwardOnly

rsUpdateable.Open sSQL, acUpdateable

rsUpdateable.MarshalOptions = adMarshalModifiedOnly
Set rsUpdateable.ActiveConnection = Nothing
acUpdateable.Close
Set acUpdateable = Nothing

I can implement most of this within Python but not the bit after Marshalling.

I can read and write to the database but as soon as I try to disconnect the recordset Python cannot see the cursor.

Is it possible to use disconnected recordsets with Python and if so where can I find information on the subject.

Any help you can offer would be gratefully received.

Martin