【C++连接数据库】mysql

在“管理工具”----“数据源”设置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的问题。。。。求高手帮忙