vc通过odbc连接mysql

#include <windows.h>
#include <sql.h>
#include <sqlext.h>
#include <iostream>

void CheckSqlError(SQLRETURN ret, SQLSMALLINT handleType, SQLHANDLE handle) {
    if (ret != SQL_SUCCESS && ret != SQL_SUCCESS_WITH_INFO) {
        SQLCHAR sqlState[6], messageText[SQL_MAX_MESSAGE_LENGTH];
        SQLSMALLINT messageLength;
        SQLINTEGER nativeError;
        SQLGetDiagRec(handleType, handle, 1, sqlState, &nativeError, messageText, sizeof(messageText), &messageLength);
        std::cerr << "SQL Error: " << sqlState << " - " << messageText << std::endl;
    }
}

int main() {
    SQLHENV env;
    SQLHDBC dbc;
    SQLRETURN ret;

    // Allocate environment handle
    ret = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);
    CheckSqlError(ret, SQL_HANDLE_ENV, env);

    // Set the ODBC version environment attribute
    ret = SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);
    CheckSqlError(ret, SQL_HANDLE_ENV, env);

    // Allocate connection handle
    ret = SQLAllocHandle(SQL_HANDLE_DBC, env, &dbc);
    CheckSqlError(ret, SQL_HANDLE_DBC, dbc);

    // Connect to the database
    ret = SQLConnect(dbc, (SQLCHAR*)"your_dsn_name", SQL_NTS, (SQLCHAR*)"your_username", SQL_NTS, (SQLCHAR*)"your_password", SQL_NTS);
    CheckSqlError(ret, SQL_HANDLE_DBC, dbc);

    if (ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO) {
        std::cout << "Connected to MySQL database successfully!" << std::endl;

        // Perform your database operations here

        // Disconnect from the database
        SQLDisconnect(dbc);
    }

    // Free handles
    SQLFreeHandle(SQL_HANDLE_DBC, dbc);
    SQLFreeHandle(SQL_HANDLE_ENV, env);

    return 0;
}