Sample: ADOVC1 Simple ADO/VC++ Application (220152)
The information in this article applies to:
- Microsoft Visual C++, 32-bit Enterprise Edition 6.0
- Microsoft Visual C++, 32-bit Professional Edition 6.0
- Microsoft Visual C++, 32-bit Learning Edition 6.0
- ActiveX Data Objects (ADO) 2.1
- ActiveX Data Objects (ADO) 2.5
- ActiveX Data Objects (ADO) 2.6
This article was previously published under Q220152 SUMMARY The ADOVC1.exe sample is an ADO/Visual C++ console
application that demonstrates #import of ADO. MORE INFORMATIONThe
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.
REFERENCES 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
| Modification Type: | Minor | Last Reviewed: | 8/10/2004 |
|---|
| Keywords: | kbdownload kbDatabase kbfile kbhowto kbSample KB220152 kbAudDeveloper |
|---|
|