Re: I need a good book or two on ADO

From: Arnie Mauer (xxx_at_nowhere.net)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 14:45:40 -0400

"beginthreadex" <thomas_remkus@westwoodone.com> wrote in message
news:%23AmX2hYoEHA.1460@TK2MSFTNGP12.phx.gbl...
> There isn't one. ADO in straight C++ is fairly easy once you get it
> to work
> once. But that's always the case. I suggest that you look for a
> download
> package from Microsoft of samples in C++. Every method, every
> property are
> all outlined in there. Bill's book isn't going to help much except
> for some
> rules and basics.
>
> Once you get ADO to work, you'll want to look up ADO Record Binding.
> The
> only language you can pull this off in is C++ and it's faster than
> ADO.NET
> by multiple times over. Microsoft engineers don't even challenge
> this, but
> they sure don't make ads about it either. ADO.NET is supposed to do
> some
> sort of binding but it's not like C++ can do. It's pure bliss! But
> it's not
> something that you can do in a wink.
>
I have MSDN and so have the ADO reference and some C++ samples.
However, there seems to be a gap between the two. For example, the
samples use _ConnectionPtr but it's no where in the help. So I
guessed at _FieldPtr, but nooooooooooooo, it's FieldPtr :-(

Performance. I created a test program that reads two numeric and one
varchar columns out of a table. No WHERE clause or anything. Just
reads about 1.25 million records.

Using unmanaged C++, ADO and Oracle's OLEDB, it ran in 72 seconds. I
'ported' it to C# and ADO.NET using the Oracle* managed DB classes and
it ran in 8.25 seconds. Go figure.

- Arnie

Relevant Pages

  • Re: I need a good book or two on ADO
    ... ADO in straight C++ is fairly easy once you get it to work ... Once you get ADO to work, you'll want to look up ADO Record Binding. ... Microsoft engineers don't even challenge this, ...
    (microsoft.public.data.ado)
  • Re: Access 2007 and VB
    ... and link to the download as a non expert some ... A Data Access Library (ADO, DAO, ACEDAO, ... ... The Database Engine ... store is not shared (single user), multiple users on the same box, or across ...
    (microsoft.public.vb.general.discussion)
  • Re: [dialog] getting features I would like to have
    ... download the thread *after* I've downloaded the first article. ... Create a custom script ... ADo; ...
    (news.software.readers)
  • Re: New record in table in Access from VBA in Excel
    ... > older version of ADO to ensure backwards compatibility. ... if you set a reference to Excel9 and open ... for download) is much more stable than the more recent MDAC 2.7. ...
    (microsoft.public.excel.programming)
  • Re: ADO 2.8 help files
    ... > to download it. ... I found some SDK download page, ... The ADO help files I ... I checked Platform SDK Feb 2003, and there is MDAC 2.7 SDK which is actualy ...
    (microsoft.public.sqlserver.programming)