<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY style="FONT: 10pt Courier New" leftMargin=5 topMargin=5>
<DIV>
<DIV>I have been searching the net for two weeks now but can find nothing on
disconnected recordsets.</DIV>
<DIV> </DIV>
<DIV>I have been programming in VB6 for two years and have had quite a success
with disconnected resordsets with the following code:-</DIV>
<DIV> </DIV>
<DIV> Dim acUpdateable As Connection<BR>
<BR> Set acUpdateable = New Connection<BR>
acUpdateable.Open gBRDataBase<BR></DIV>
<DIV> Set rsUpdateable = New
ADODB.Recordset<BR> <BR>
rsUpdateable.CursorLocation = adUseClient<BR>
rsUpdateable.LockType = adLockBatchOptimistic<BR>
rsUpdateable.CursorType = adOpenForwardOnly</DIV>
<DIV> </DIV>
<DIV> rsUpdateable.Open sSQL,
acUpdateable<BR> <BR>
rsUpdateable.MarshalOptions = adMarshalModifiedOnly<BR> Set
rsUpdateable.ActiveConnection = Nothing<BR>
acUpdateable.Close<BR> Set acUpdateable = Nothing</DIV>
<DIV> </DIV>
<DIV>I can implement most of this within Python but not the bit after
Marshalling.</DIV>
<DIV> </DIV>
<DIV>I can read and write to the database but as soon as I try to disconnect the
recordset Python cannot see the cursor.</DIV>
<DIV> </DIV>
<DIV>Is it possible to use disconnected recordsets with Python and if so where
can I find information on the subject.</DIV>
<DIV> </DIV>
<DIV>Any help you can offer would be gratefully received.</DIV>
<DIV> </DIV>
<DIV>Martin</DIV>
<DIV><BR> </DIV></DIV></BODY></HTML>