Use ODBC for multi-platform database operations

ODBC is the abbreviation of open database connect, which is a unified interface standard for accessing databases proposed by Microsoft in 1991. It is an applicationProgramAnd the middleware between the database system. It performs database operations by interacting with the driver and application of the required database on the corresponding application platform, avoiding the direct call of database-related operations in the application, this provides database independence.

Among them, Microsoft developed a complete set of obdc API, see: http://msdn.microsoft.com/en-us/library/ms131675.aspx

Odbc api: function call library, errorCodeSet and the (SQL) syntax of the standard structured query language used to access data on the DBMS.

 

There are also many ODBC implementations in Linux, among which unixodbc and iodbc are outstanding. The multi-ODBC encapsulation class cppodbc provided in this article is tested under unixodbc. Because the unixodbc interface is consistent with the odbc api developed by Microsoft (it is estimated that the same is true for iodbc), data operation consistency between different operating systems and databases is possible.

After several days, the author completed a simple encapsulation of odbcapi