FAQ: 2.13 How do I work with database in Visual C++?

Question

2.13 How do I work with database in Visual C++?

 

Back to FAQ Home

Answer 1

Visual C++ provides several ways to work with databases.

·         ODBC

The Microsoft Foundation Classes (MFC) library supplies classes for programming with Open Database Connectivity (ODBC). For more information about using the ODBC API without MFC, see the Open Database Connectivity (ODBC) SDK in MSDN.

 

·         OLE DB

OLE DB is a set of COM interfaces that provide uniform access to data in diverse information sources and formats. The OLE DB templates are C++ templates that make the high-performance OLE DB database technology easier to use by providing classes that implement many commonly used OLE DB interfaces. This template library is divided into consumer templates and provider templates. For more information about OLE programming, see OLE DB Programming in MSDN.

 

·         ADO

ADO is implemented with COM (Component Object Model) interfaces. However, it is easier for programmers to work with COM in certain programming languages than others. For example, nearly all the details of using COM are handled implicitly for Visual Basic programmers, whereas Visual C++ programmers must attend to those details themselves. For more information see Visual C++ ADO programming in MSDN.

 

·         ADO.NET

ADO.NET is the .NET Framework API for data access and provides power and ease of use unmatched by previous data access solutions. It runs under the Common Language Runtime (CLR). Therefore, any application that interacts with ADO.NET must also target the CLR. However, that does not mean that native applications cannot use ADO.NET. For more information, see Data Access Using ADO.NET in C++ in MSDN.

 

Reference Materials:

Data Access (How Do I in Visual C++) 

 

Related Threads:

http://social.msdn.microsoft.com/Forums/en-US/vcgeneral/thread/3c32314e-5cd2-4c67-a619-3dbbfc3243f8

http://social.msdn.microsoft.com/forums/en/vcgeneral/thread/df8081ba-5824-4ad3-b183-6be5920d7612

http://social.msdn.microsoft.com/Forums/en-US/vcgeneral/thread/1785938e-e774-463a-a988-58db29d8dbf2

http://social.msdn.microsoft.com/forums/en/vcgeneral/thread/1f2eac89-fe8a-4d84-bd76-63467e8e91ec