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