[DB-SIG] ADO

[martin at sterling2000.co.uk]

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

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/db-sig/attachments/20031125/70451ad2/attachment.html