Learn to use ODBCAPI

Although I learned how to use ODBCAPI, although I have been familiar with some database applications before, I did some SQL statement operations because I only had a very simple database knowledge, the installation-configuration-connection process is implemented by following the example. I remember ODBC, ADO, and so on. I also understood it briefly. When using a database for sharing

Although I have been familiar with some database applications before using ODBC APIs, I did some SQL statement operations because I only had a very simple database knowledge, the installation-configuration-connection process is implemented by following the example. I remember ODBC, ADO, and so on. I also understood it briefly. When using a database for sharing

Learn to use ODBC APIs

Although I have been familiar with some database applications before, I did some SQL statement operations because I only had a very simple database knowledge, the installation-configuration-connection process is implemented by following the example. The Hong Kong server, such as ODBC and ADO, can be simply understood, it is best to Use ODBC when sharing databases, while local databases can use ADO.

The specific differences between these connection methods can be learned:

Simply put, ODBC and ADO are both database access methods provided by Microsoft. ADO is a COM component, while ODBC is a standard access method, the database access and database-related situations are ended, but the implementation of the two is different. The virtual host is different in terms of the appearance of different applications. (if not, please note that, I only read a little introduction on the Wiki and didn't have system learning ).

Use

Through analysis, considering that the database sharing method may be used in the future, and COM itself is not very familiar with it, it is better to use ODBC, server space, there are many ways to use ODBC, but since I am not a program developer, I am responsible for maintenance and do not dare to perform major operations, so I chose ODBC API, this is equivalent to the use of ipvs API and MFC, although the API is complex, but relatively free.

First, add several dependencies to the program.

# Include # Include # Include # Pragma comment (lib, "odbc32.lib") # pragma comment (lib, "odbccp32.lib ")