Using MS-ADO in VC++

Posted on 2001-08-27
Last Modified: 2012-08-14
I have been trying to use ADO inside a C++ win32 static DLL but am having no luck.  Almost all the documentation says the same thing: type in this #import "..... msado15.dll" and then they just stop explaining, like something magical is supposed to happen after that.  I am putting this #import directive inside "stdafx.h".  I build the DLL successfully, but I was under the impression that some classes were supposed to be generated in my project file based on the ADO dll.  I am not sure when to use, for example, _Recordset or _RecordsetPtr.  I am looking at sample code from a MS KB article that does something like this:  (notice the dot on the first one and the pointer reference on the second one... and their sample code compiles and runs!)....

_RecordsetPtr rs;
rs.CreateInstance( __uuidof( Recordset ) );
rs->Open("select * from myTable", "myDSN", adOpenStatic,adLockBatchOptimistic,-1);

By the way, I am getting a linker error on the "open" call:
     rs->Open("select * from myTable", "myDSN", adOpenForwardOnly, adLockOptimistic, adCmdText);

I know I am just not doing something right.  Any help is greatly appreciated!!  Thank you.
Question by:piratepatrol

Expert Comment

ID: 6429000
where did u give the #import statement...

if ur using ATL then

Open stdafx.h

goto the end of the file

Add #import "*.dll" using <namespace>
#endif // !defined(AFX_STDAFX_H__0EB39A16_93E7_11D5_ABA7_00508BBD58BA__INCLUDED)

then give a rebuild all

hope this works for u...

Arvind T.N

Expert Comment

ID: 6430160
Have you tried the following

In Class Wizard

Select the ActiveX Events tab

Add new Class from type library

Look for the msado15.dll

It should be in c:\Program Files\Common Files\System\Ado

This should bring up as list of the interfaces etc. supported by the dll.

Pick the ones you require.

then just include msado.h in your code where you need to use ado.



Expert Comment

ID: 6430386
All of the imported classes will be in a file called msado15.tlh in your debug or release directory, and you can look there for an idea of what they're doing.  The classes will be in a namespace called ADODB unless you import with the no_namespace directive.  You typically can't use the classes directly.  You will have to use either a pointer to the class or a smart pointer (like _RecordsetPtr).  Then you need to call the CreateInstance member function of _RecordsetPtr to create the ActiveX control.  Using ActiveX controls is a whole subject unto itself, and you might want to look at a tutorial on that.  I hope this helps.
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

LVL 49

Accepted Solution

DanRollins earned 100 total points
ID: 6431443
ADO access is real easy in langiages such as VB and Javascript and real hard in C++.  One reaosn is all of the conversion to bstr and variants and so forth which is transparent in the other langiages.

Notice how I comment out the # import.  It is not needed after the first time (just the #include)

// #import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","EndOfFile")
#include "msado15.tlh"

_ConnectionPtr m_pDBConnection= NULL;
_RecordsetPtr  m_pRecSet= NULL;

BOOL OpenDatabase( LPCSTR szDatabase )
    HRESULT hr;
    ::CoInitialize(NULL); // really put this elsewhere...
    hr= m_pDBConnection.CreateInstance(__uuidof(Connection));

    CString sConnect;  sConnect.Format(
        "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;"
        "Mode=Read|Write|Share Deny None;Persist Security Info=False",
    hr= m_pDBConnection->Open(
       _bstr_t( sConnect ),  _bstr_t(""),  _bstr_t(""),
    return TRUE;

BOOL DoQuery()
   HRESULT       hr;
   _bstr_t       bstrQuery( "SELECT * FROM Customers" );
   _variant_t    vNull( DISP_E_PARAMNOTFOUND, VT_ERROR );        // Null variant

    hr= m_pRecSet.CreateInstance(__uuidof(Recordset));
    m_pRecSet->PutRefActiveConnection( m_pDBConnection );
    hr= m_pRecSet->Open(_variant_t(bstrQuery), vNull,
    int nNumberIssues= m_pRecSet->GetRecordCount(); // eyeball check
    return TRUE;

-- Dan

Expert Comment

ID: 6766959
There has been no activity in this question in quite some time, and it looks like it has been abandoned. As part of our ongoing mission to clean up the topic areas, a Moderator will finalize this question within the next seven (7) days. At that time, either I or one of the other Moderators will force/accept the comment of DanRollins.

DO NOT ACCEPT THIS COMMENT AS AN ANSWER. If you have further comments on this question or the recommendation, please leave them here.


Some of these questions have been open for some time, and records indicate you logged in as recently as a today. Please resolve them appropriately as soon as possible. Continued disregard of your open questions will result in the force/acceptance of a comment as an answer; other actions affecting your account may also be taken. I will revisit these questions in approximately seven (7) days. (new) (new)


Community Support Moderator
Experts Exchange
LVL 49

Expert Comment

ID: 6767116
hi piratepatrol,

Do you have any additional questions?  Do any comments need clarification?

-- Dan

Expert Comment

ID: 6793086
Force/accepted by

Community Support Moderator
Experts Exchange

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Often, when implementing a feature, you won't know how certain events should be handled at the point where they occur and you'd rather defer to the user of your function or class. For example, a XML parser will extract a tag from the source code, wh…
Templates For Beginners Or How To Encourage The Compiler To Work For You Introduction This tutorial is targeted at the reader who is, perhaps, familiar with the basics of C++ but would prefer a little slower introduction to the more ad…
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…
The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question