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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

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.
Industry Leaders: 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Errors will happen. It is a fact of life for the programmer. How and when errors are detected have a great impact on quality and cost of a product. It is better to detect errors at compile time, when possible and practical. Errors that make their wa…
  Included as part of the C++ Standard Template Library (STL) is a collection of generic containers. Each of these containers serves a different purpose and has different pros and cons. It is often difficult to decide which container to use and …
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.
The viewer will learn additional member functions of the vector class. Specifically, the capacity and swap member functions will be introduced.

690 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