Using MS-ADO in VC++

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.
Who is Participating?
DanRollinsConnect With a Mentor Commented:
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
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
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.


7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

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.
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
hi piratepatrol,

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

-- Dan
Force/accepted by

Community Support Moderator
Experts Exchange
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.