方法来自: http://blog.csdn.net/dlutxie/article/details/6849385
#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 雇员 values('C++',2012); ";
_bstr_t strConnect = "DSN=sql2008;Database=test;uid=sa;pwd=csc;";
//初始化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();
}