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.Op en gBRDataBase

Set rsUpdateable = New ADODB.Recordset

rsUpdateable.Cu rsorLocation = adUseClient
rsUpdateable.Lo ckType = adLockBatchOpti mistic
rsUpdateable.Cu rsorType = adOpenForwardOn ly

rsUpdateable.Op en sSQL, acUpdateable

rsUpdateable.Ma rshalOptions = adMarshalModifi edOnly
Set rsUpdateable.Ac tiveConnection = Nothing
acUpdateable.Cl ose
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