martin at sterling2000.co.uk martin at sterling2000.co.uk
Tue Nov 25 06:27:52 EST 2003

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 quite 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: http://mail.python.org/pipermail/db-sig/attachments/20031125/70451ad2/attachment.html

More information about the DB-SIG mailing list