Re: Questions about ADO

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hash_at_example.org
Date: 01/19/05 

Date: Tue, 18 Jan 2005 21:01:17 -0500

Harold, Rob, et al -

Thanks for the pointers and the website. rs.recordcount returned -1,
which the website says is a cursor problem. But with other methods
discussed there such as movenext to EOF and absolute size>0 I got the
insight I needed.

Thanks again.
...best, Hash
 
In article <e8vg1vT$EHA.1604@TK2MSFTNGP12.phx.gbl>,
 "Rob van Gelder" <newsgroups@nojunkmail-vangelder.co.nz> wrote:
> Very true - thanks Harald.
>
> I also believe Server / Client side cursors will affect RecordCount.
> Better to refer to the programmers reference and Provider documentation.
> There is also a newsgroup devoted to ADO: microsoft.public.data.ado
>
> To be honest, it's difficult remembering this stuff - I hardly ever deal
> with ADO programming.
> When I first started using ADO, I figured out what worked, wrote a wrapper
> library and haven't touched it in years.
>
> --
> Rob van Gelder - http://www.vangelder.co.nz/excel
>
>
> "Harald Staff" <stf@enron.invalid> wrote in message
> news:OhJpFhT$EHA.3236@TK2MSFTNGP15.phx.gbl...
> > Hi Hash
> >
> > Adding toRob: Note that recordcound won't work with cursor "ForwardOnly",
> > and that ForwardOnly is a lot faster than other cursors on certain
> > systems.
> >
> > HTH. Best wishes Harald
> >
> > <Hash@example.org> skrev i melding news:asYGd.18123$B95.5622@lakeread02...
> >> All -
> >>
> >> Working the issue of a large data import, Google led me to ADO. I have
> >> the basic routine working, copyied from a European website.
> >>
> >> Right now I determine the size of the import afterwards via xlend etc.
> >> Is there a property I can access before the import (rs.recordcount or
> >> somesuch) that will tell me what the number of records is beforehand so
> >> I can size the copied data? Easy enough for me to do except when I want
> >> all of them. Second question--same for number of fields.
> >>
> >> Right now, I count field.names while field(i).name <> vbnullstring.
> >> That gives an error, for which I continue on, and capture my counter. A
> >> method that grates. What are the values of "empty" field.names? NULL
> >> doesn't work either.
> >>
> >>
> >> Thanks in advance.
> >>
> >> ...best, Hash
> >
> >
>
>

Relevant Pages

  • cursor
    ... how do you change the cursors look on a website using frontpage? ... is there a help section or faq that ...
    (microsoft.public.frontpage.programming)
  • Re: DAO to ADO Recordset Options
    ... DAO was really fast when dealing with Access data (faster than ADO) but was ... Recordset. ... For client-sided cursors, there is only Static cursor type regardless as ... determines how often data is fetched from the server. ...
    (microsoft.public.data.ado)
  • Re: Speed of ADO
    ... I believe you need to use client side cursors. ... Look for the ado Cursor location property. ...
    (microsoft.public.data.ado)
  • Re: oracle function returning sys_refcursor
    ... ADOdb is written to be as similar ... to ADO as possible. ... It supports cursors and it has a nice little tutorial ... Prev by Date: ...
    (comp.lang.php)
  • Re: Profiler shows sproc executing twice
    ... I have seen some strange behavior like that when using ADO ... > cursors. ... Yes, as a matter of fact, it is coming from an ADO server-side call. ...
    (microsoft.public.sqlserver.tools)