mysql与vc的连接数据库

#include <iostream>
#include <windows.h>
#include <atlbase.h> // 包含CComPtr等智能指针
#include <adoint.h> // 包含ADO库

void ConnectToMySQL() {
    CoInitialize(NULL); // 初始化COM库

    try {
        CComPtr<_Connection> pConn;
        HRESULT hr = pConn.CoCreateInstance(__uuidof(Connection));
        if (FAILED(hr)) {
            throw std::runtime_error("Failed to create ADO connection instance.");
        }

        // 设置连接字符串
        CComBSTR connStr = "Provider=MSDASQL;Driver={MySQL ODBC 8.0 Driver};Server=localhost;Database=mydatabase;Uid=myuser;Pwd=mypassword;";
        hr = pConn->Open(connStr, "", "", adConnectUnspecified);
        if (FAILED(hr)) {
            throw std::runtime_error("Failed to open database connection.");
        }

        std::cout << "Connected to MySQL database successfully!" << std::endl;

        // 关闭连接
        pConn->Close();
    } catch (_com_error &e) {
        std::cerr << "Error: " << e.ErrorMessage() << std::endl;
    }

    CoUninitialize(); // 清理COM库
}

int main() {
    ConnectToMySQL();
    return 0;
}