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.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PDF library for Delphi 2 135
Template syntax for variable length arrays 9 77
C++ Code Issue 4 38
Bitwise and to sum elements 2 17
When writing generic code, using template meta-programming techniques, it is sometimes useful to know if a type is convertible to another type. A good example of when this might be is if you are writing diagnostic instrumentation for code to generat…
Introduction This article is the first in a series of articles about the C/C++ Visual Studio Express debugger.  It provides a quick start guide in using the debugger. Part 2 focuses on additional topics in breakpoints.  Lastly, Part 3 focuses on th…
The goal of the video will be to teach the user the concept of local variables and scope. An example of a locally defined variable will be given as well as an explanation of what scope is in C++. The local variable and concept of scope will be relat…
The viewer will be introduced to the technique of using vectors in C++. The video will cover how to define a vector, store values in the vector and retrieve data from the values stored in the vector.

730 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