Here's another book I own:
[Beginning ATL COM]
Have a look at the reviews there at Amazon. It's from the old Wrox
repetoire, and the result of a number of coauthors
ATL stands for Active Template Library, and it refers to a fairly
ambitious approach to accelerating COM programming productivity by
using C++ templates and macros. The ATL Internals book by Rector and
Sells would be useful in getting an orientation as to how it all works
"behind the scenes", but I'd put it off until you've spent 3 to 6
weeks in hands-on stuff.
I suspect Beginning ATL COM will be a good fit for your needs. It's
comprehensize enough to be useful as a reference later, and
introductory enough to allow many C++ proficient programmers to tackle
ATL COM projects after a thorough read.
It's the "thorough reading" part that some find daunting. Because of
the collaborative nature of the book, I suspect that you will need to
reread some chapters several times to feel properly enlightened about
the subject matter.
Anyway, it's been around awhile and there are very inexpensive used
copies available, so it really is a question of the time investment,
not money. Plus, I have a copy and would be happy to help with
bridging any deeply confusing parts.
There's another book by the same authors, more or less, from about a
year and a half later (May 1999 vs. Sept. 1997):
[Beginning ATL 3 COM Programming]
and I'd recommend it except I don't happen to own a copy. Even one of
the authors seems to confuse the two books:
[Beginning ATL (3?) COM Programming]
Wrox has unfortunately sold many of their older titles (including this
one) to another publisher, so many of the links on that last page have
perished in the transition.
Amazon sells it in a bundle with Box's Essential COM, but bear in mind
that the Box viewpoint is really kind of "academic-y". Not every
one's cup of tea, though many consider him an indispensible guide to
the philosophy of COM.
Now let's consider the ADO programming side of things. I'd say the
best introductory ADO programming books tended to be VB oriented. If
you're not a Visual C++ purist, you might take a look at this one by
[SQL Server and ADO Programming Complete]
On the C++ side you'd mostly have to make do with the stray chapter
devoted to ADO objects in a more comprehensize book on application
development. What I did was get the ADO 2.X reference books, which
(because Microsoft churned through the version updates pretty
frequently) wound up being a little expensive. I think I have three
of these, for different values of X!
But Microsoft has been pushing everyone into ADO.Net, so ADO itself
has stabilized at version 2.8. Some of the features of ADO 2.7 got
broken in 2.8, so your "legacy" project may be keyed to that (MDAC
2.7). Ask questions of the folks handing it off to you!
Once you get the ADO object model under your belt, I think you'll be
fine with the online documentation from Microsoft. Not to give Google
a gratuitous plug, but the Microsoft search engine on the MSDN site
can't hold a candle to Googling for appropriate syntax and sample code
If you are trying to get started on your own machine to do some
exercises, you might install MSDE (Microsoft SQL Server 2000 Desktop
[Microsoft SQL Server: MSDE 2000 Home]
Although it lacks some administration tools and limits connections,
it's free (and freely redistributable!) and very good for learning
about SQL Server.
I could go on, but I feel this is already a lot to bite off for a 3 to
6 month crash course. Please feel free to use me as a "mentoring"
resource as you get into compiling sample projects, and I'll be happy
to point out additional resources as you progress.
The CodeProject and CodeGuru sites recommended by aryabhatt-ga have
been around for awhile, and will have substantial "legacy" content.
Again Google may be the best way to find stuff there; you can limit a
Google Web search to a particular site by adding the qualifier:
or whatever the case may be.