administrators at administrators at
Thu Nov 20 09:26:24 CET 2003

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
    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.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the Python-list mailing list