Article ID: 152534 - View products that this article applies to.
This article was previously published under Q152534
DBCTL demonstrates a way to use ODBC in an ActiveX Control (OLE Control). A Visual C++ and a Visual Basic client application are included as part of this sample. The Visual C++ client is called DBUSR, the Visual Basic client is called DBVBUSR.
The following file is available for download from the Microsoft Download Center:
Dbctl.exeFor more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591Microsoft 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 prevent any unauthorized changes to the file.
(http://support.microsoft.com/kb/119591/ )How to obtain Microsoft support files from online services
DBCTL creates and opens a Class Wizard-configured CRecordset object from within the virtual override of COleControl::OnSetClientSite. The CRecordset- derived object is configured to the COURSE table of the STDREG32.MDB that comes with the sample. Please note that you have to create a user or a system DSN called "student registration" in your ODBC control panel with Access ODBC Driver and have to point this DSN to the STDREG32.MDB file.
The CRecordset-derived object is closed from within its own destructor. The CRecordset object is destructed with a call to the delete operator from within the COleControl derived class destructor.
The control exposes one method, a DisplayRecords method, that simply lists the contents of the recordset in the control.
The OLE Control subclasses a listbox. The string items are added to the listbox by using SendMessage.
The DBUSR.EXE and DBVBUSR.EXE demonstrate using the custom control.
Article ID: 152534 - Last Review: September 30, 2005 - Revision: 5.0