vc连接access数据库的代码

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

void CheckSqlError(SQLRETURN ret, SQLSMALLINT handleType, SQLHANDLE handle) {
    SQLCHAR sqlState[6], messageText[SQL_MAX_MESSAGE_LENGTH];
    SQLSMALLINT textLength;
    SQLINTEGER nativeError;
    SQLSMALLINT i = 1;

    while (SQLGetDiagRec(handleType, handle, i, sqlState, &nativeError, messageText, sizeof(message), &textLength) == SQL_SUCCESS) {
        std::cerr << "SQL Error: " << sqlState << " - " << messageText << std::endl;
        i++;
    }
}

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

    // Allocate environment handle
    ret = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);
    if (!SQL_SUCCEEDED(ret)) {
        CheckSqlError(ret, SQL_HANDLE_ENV, env);
        return 1;
    }

    // Set the ODBC version environment attribute
    ret = SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);
    if (!SQL_SUCCEEDED(ret)) {
        CheckSqlError(ret, SQL_HANDLE_ENV, env);
        SQLFreeHandle(SQL_HANDLE_ENV, env);
        return 1;
    }

    // Allocate connection handle
    ret = SQLAllocHandle(SQL_HANDLE_DBC, env, &dbc);
    if (!SQL_SUCCEEDED(ret)) {
        CheckSqlError(ret, SQL_HANDLE_DBC, dbc);
        SQLFreeHandle(SQL_HANDLE_ENV, env);
        return 1;
    }

    // Connect to the database
    ret = SQLConnect(dbc, (SQLCHAR*)"YourDSNName", SQL_NTS, (SQLCHAR*)"YourUsername", SQL_NTS, (SQLCHAR*)"YourPassword", SQL_NTS);
    if (!SQL_SUCCEEDED(ret)) {
        CheckSqlError(ret, SQL_HANDLE_DBC, dbc);
        SQLFreeHandle(SQL_HANDLE_DBC, dbc);
        SQLFreeHandle(SQL_HANDLE_ENV, env);
        return 1;
    }

    // Allocate statement handle
    ret = SQLAllocHandle(SQL_HANDLE_STMT, dbc, &stmt);
    if (!SQL_SUCCEEDED(ret)) {
        CheckSqlError(ret, SQL_HANDLE_STMT, stmt);
        SQLDisconnect(dbc);
        SQLFreeHandle(SQL_HANDLE_DBC, dbc);
        SQLFreeHandle(SQL_HANDLE_ENV, env);
        return 1;
    }

    // Execute a query
    ret = SQLExecDirect(stmt, (SQLCHAR*)"SELECT * FROM YourTableName", SQL_NTS);
    if (!SQL_SUCCEEDED(ret)) {
        CheckSqlError(ret, SQL_HANDLE_STMT, stmt);
        SQLFreeHandle(SQL_HANDLE_STMT, stmt);
        SQLDisconnect(dbc);
        SQLFreeHandle(SQL_HANDLE_DBC, dbc);
        SQLFreeHandle(SQL_HANDLE_ENV, env);
        return 1;
    }

    // Fetch and print the results
    SQLCHAR columnValue[256];
    while (SQLFetch(stmt) == SQL_SUCCESS) {
        SQLGetData(stmt, 1, SQL_C_CHAR, columnValue, sizeof(columnValue), NULL);
        std::cout << "Column Value: " << columnValue << std::endl;
    }

    // Clean up
    SQLFreeHandle(SQL_HANDLE_STMT, stmt);
    SQLDisconnect(dbc);
    SQLFreeHandle(SQL_HANDLE_DBC, dbc);
    SQLFreeHandle(SQL_HANDLE_ENV, env);

    return 0;
}