Microsoft KB Archive/220152

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 13:41, 21 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base

Article ID: 220152

Article Last Modified on 8/10/2004


  • Microsoft Visual C++ 6.0 Enterprise Edition
  • Microsoft Visual C++ 6.0 Professional Edition
  • Microsoft Visual C++ 6.0 Standard Edition
  • Microsoft ActiveX Data Objects 2.1
  • Microsoft ActiveX Data Objects 2.5
  • Microsoft ActiveX Data Objects 2.6

This article was previously published under Q220152


The ADOVC1.exe sample is an ADO/Visual C++ console application that demonstrates #import of ADO.


The following file is available for download from the Microsoft Download Center:

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

rickAdo.cpp 1949
rickAdo.dsp 3422
rickAdo.dsw 539
rickAdo.ncb 123904
rickAdo.opt 53760
rickAdo.plg 1214

After extracting the project (by running ADOVC1.exe), open the project with Visual C++. Change "DefaultDir=C:\\test;" in the connection string to the directory where the files are, or move the Authors.mdb file to the "C:\test" directory. There is also a connection string to the Pubs database if you have SQL Server 6.5 or 7.0.

The CREATEiNSTANCE macro is used to create the ADO Connection and Recordset objects. If the creation fails, the macro throws a _com_error exception, which is caught in the catch statement that wraps the code body.

If ADO is not installed in the default directory, you must change the #import statement to reflect its actual location.

It is not necessary to use the absolute path for the ADO .dll file. You can add the path to Visual Studio IDE from the Tools menu under Options. Click the Directory tab and add the path to the Library files list, which allows you to use the statement:

   #import "Msado15.dll" 

You can read about the #import directive in the Visual C++ programmer's guide.

Although the sample program is only one page long, it covers all the basics of ADO from C++, without negelecting error handling.


For additional information, please see the following articles in the Microsoft Knowledge Base:

182389 FILE: Adovcbm.exe ADO 1.5 with #import and Getrows/Bookmarks

184968 FILE: Adovcsp.exe Demonstrates Using Stored Procedures with ADO

186387 SAMPLE: Ado2atl.exe Returns ADO Interfaces from COM

181733 FILE: Adovcbtd.exe #import Using UpdateBatch and CancelBatch

200122 SAMPLE: ATL2ADO Returns Disconnected ADO Recordset

Additional query words: Adovc1

Keywords: kbhowto kbdownload kbdatabase kbfile kbsample KB220152