【C++连接数据库】mysql

来源：互联网发布：怎么联系淘宝云客服编辑：程序博客网时间：2024/05/01 23:44

在“管理工具”----“数据源”设置DSN

#pragma once#define WIN32_LEAN_AND_MEAN  // Exclude rarely-used stuff from Windows headers#include <stdio.h>#include <tchar.h>//使用#import把动态连接库msado15.dll导入，生成定义ADO库的两个C++头文件：msado15.tlh和ado15.tli#import "c:\Program Files\Common Files\System\ADO\msado15.dll"  no_namespace rename("EOF", "EndOfFile")void main(){char *sqlCommand = "insert into student values (20120822,'C++conect'); ";_bstr_t strConnect = "DSN=mysql5;Database=test;uid=root;pwd=890531;";//初始化COM库::CoInitialize(NULL);//添加一个指向Connection对象的指针m_pConnection_ConnectionPtr m_pConnection(__uuidof(Connection));//创键Connection对象if(FAILED(m_pConnection.CreateInstance(__uuidof(Connection)))) {printf("创键Connection对象时出错\n");}try{//连接数据库m_pConnection->Open(strConnect,"","",adModeUnknown); }catch(_com_error e) {printf("连接数据库时出错\n");}m_pConnection->Execute(sqlCommand, NULL, 1);//执行SQL语句m_pConnection->Close(); //释放程序占用的COM 资源::CoUninitialize();  }

数据是插进去了，但是有错误

Error in my_thread_global_end(): 1 threads didn't exit

不知道咋回事，在网上搜了一下，说是mysql的问题。。。。求高手帮忙