Can someone explain to me why this might be happening? I am stumped.
Thank you.
The type of Recordset is probably different for both that is the
CursorLocation, CursorType, LockType properties are different.
The Server-sided, adForwardOnly, ReadOnly is fastest - but also the most
limited in terms of what it can do.
Before doing your
do while not rs.eof
you should print out these properties and see what type of RecordSet you
have got in both cases.
For Server-sided, changing the CacheSize from 1 to something else may help.
Re: ADO Recordset vs Command and AD ... The CursorLocation can be set on the connection prior to opening the ... This CursorLocation is applied to the recordset opened on this ... Open method of a Recordset object, so you can assign the cursorType ... CommandText property of a Command object so you can turn on paging and use ... (microsoft.public.scripting.vbscript)
Re: Current Recordset does not support updating. ... it may be a limitation of your ... > that the recordset is editable. ... > above CursorLocation to see if problem went away, ... I changed the CursorType to adOpenKeyset.... (microsoft.public.vb.database.ado)
Re: Return a recordset from an MDB ... Is it necessary to specify a CursorLocation?... Execute method of the Command object to return a Recordset,... If you use a Connection object,... (microsoft.public.scripting.vbscript)
Re: VB 6.0 Crystal 8.5 ADO - Passing recordset to report problem ....CursorLocation = adUseClient ... > recordset and then try and pass this recordset to a crystal report ... > source in my report using the 'Set Location' menu option. ... > Dim Report As New CRAXDRT.Report ... (microsoft.public.vb.crystal)
Re: Download Speed ... out, under SQL Server, is server-sided,readonly,forwardonly. ... then you have no control on the RecordSet, you should get the ... get back Forward only, Readonly, Server Sided RecordSet, CacheSize = 1. ...Connection CursorLocation is Client-sided, you should get back Static, ... (microsoft.public.data.ado)
