Tuesday, February 26, 2013

Database Management with Microsoft ODBC


Database Connectivity with Microsoft ODBC:
The open Database connectivity (ODBC) is an API that is widely used for database connectivity. It provides the standard interface to different sort of data source. These data source can be simple text or it may be full-fledged database server. It is also possible for defining interface for the compiled C program to any SQL database using ODBC.

ODBC Architecture:



ODBC architecture is useful in establishing the connection between the MFC program and various types of databases.
There is an ODBC32.DLL file, it act as driver manager. Its task is to load the required driver during program execution. ODBC32.DLL keeps track of various database specific DLL and allow the MFC program to access the data in various database. But the standard format can be accessed using Microsoft access Jet database engine or SQL server ODBC Driver.

0 comments:

Post a Comment

Powered by Blogger.