When you run Setup for Visual C++ .NET, the following database
components are installed automatically:
All the necessary ATL OLE DB components. For more
information, see
Installing ATL Database Support.
A set of ODBC drivers with the ODBC driver manager and the
ODBC administrator program. For more information, see "ODBC
Drivers Installed" and "ODBC SDK Components Installed" in
Installing MFC Database Support.
Necessary components from the DAO software development kit
(SDK). This includes Help files, which are not integrated with
this documentation. However, if you work with DAO, you need to
install a version of Jet compatible with your operating system.
For more information, see "DAO SDK Components Installed" in
Installing MFC Database Support.
As part of the baseline installation, Setup also installs
Microsoft Data Access Components (MDAC), which are necessary to
support data access programming in Visual C++ .NET.
If you are redistributing data access applications, you should
also have the MDAC 2.7 redistribution program. The MDAC 2.7 SDK is
designed for use with the MDAC 2.7 redistribution program (Mdac_typ.exe)
included in the MDAC directory on the Visual Studio .NET
Prerequisites CD-ROM. You can also download Mdac_typ.exe from the
MDAC 2.7 SDK download link previously listed. For more information
about redistributing components, see
Redistributing Controls.
Installing ATL Database Support
Setup installs all the necessary components to support OLE DB
programming as part of the baseline installation. The OLE DB
interfaces are installed as part of the MDAC SDK. The OLE DB
templates, which support OLE DB programming in Visual C++ .NET, are
installed as part of the ATL library. Visual C++ .NET Setup installs
both the MDAC SDK (version 2.7) and the ATL library.
For updates to and news about OLE DB, see the Universal Data Access
Web site at
http://microsoft.com/data/.
Installing MFC Database Support
ODBC
Drivers Installed
Setup installs the following ODBC drivers:
Microsoft Access driver
Microsoft dBASE driver
Microsoft Excel driver
Microsoft FoxPro VFP driver
Microsoft Visual FoxPro driver
Microsoft ODBC for Oracle driver
Microsoft Paradox driver
Microsoft Text driver
Microsoft SQL Server driver
For information about obtaining additional drivers and
for a list of ODBC drivers included in this version of
Visual C++, see
ODBC Driver List.
ODBC
SDK Components Installed
Visual C++ includes many key ODBC components, including
the required header files, libraries, DLLs, and tools. These
include the ODBC Administrator Control Panel application,
which you use to configure ODBC data sources, and the ODBC
driver manager. Also included are ODBC drivers for many
popular DBMSs, as listed in
ODBC Drivers Installed.
The ODBC SDK gives you additional information and tools
for writing and testing ODBC drivers. Note that as of Visual
C++ .NET, the ODBC SDK is no longer included on the Visual
C++ .NET installation media and is available as part of the
Windows SDK installed with the Visual Studio .NET
Prerequisites.
DAO
SDK Components Installed
Note:
Microsoft recommends using OLE DB or ODBC
for new projects. DAO should only be used in
maintaining existing applications.
The following components of the DAO SDK are installed by
default:
Microsoft Jet (4.0 SP3)
Microsoft Jet (3.x MDB)
Microsoft Jet (1.x, 2.x)
All the database formats listed under
What Databases Can I Access with DAO and ODBC?
In Visual C++ .NET, the DAO SDK is installed with the
Visual Studio .NET Prerequisites. Run \Jet\Jetsetup.exe.
Note:
Microsoft recommends that you use Jet 4.0
Service Pack 3 (version 2927.04) or later. Jet
4.0 Service Pack 3 shipped with Windows 2000 and
Windows ME. Using this version of Jet reduces
the number of Jet versions that must be tested
with your application. Windows XP might ship
with another version of Jet. See "Note on
Redistributing DAO Components" in
Redistributing Controls.
If you want to install other DAO SDK components, such as
the DAO SDK C++ classes, example files, or the Windows Help
version of the DAO Help file, install the DAO SDK from the
Visual C++ 6.0 CD-ROM.
ATL Database Classes (OLE DB Templates)
Microsoft provides several implementations of OLE DB, a set of COM
interfaces that provide uniform access to data in diverse
information sources and formats.
The OLE DB Templates are C++ templates in ATL that make the
high-performance OLE DB database technology easier to use by
providing classes that implement many of the commonly used OLE DB
interfaces.
This template library contains two parts:
OLE DB consumer templates Used to implement an OLE DB
client (consumer) application.
OLE DB provider templates Used to implement an OLE DB
server (provider) application.
In addition, the
OLE DB consumer attributes provide a convenient way to create
OLE DB consumers. The OLE DB attributes inject code based on the OLE
DB consumer templates to create working OLE DB consumers.
Note that the MFC library contains one class,
COleDBRecordView, that displays database records in controls.
The view is a form view directly connected to a CRowset
object, and displays the fields of the CRowset object in the
dialog template's controls. For more information, see
COleDBRecordView.
