VS2008连接Sqlserver2008 - ADO方式

stadfx.h中添加：

#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","adoEOF")

示例代码：

// sqlTest.cpp : 定义控制台应用程序的入口点。
//

#include "stdafx.h"
#include <iostream>
using namespace std;

#pragma comment (lib, "comsuppw.lib")

int _tmain(int argc, _TCHAR* argv[])
{		
	CoInitialize(NULL);				//初始化COM库
	_ConnectionPtr m_pConnection;	//声明数据库连接变量
	_RecordsetPtr m_pRecordset;		//声明数据库集合变量

	HRESULT hr;
	try
	{
		char *strConn = "Driver={sql server};server=localhost;uid=;pwd=;database=master";
		hr = m_pConnection.CreateInstance("ADODB.Connection");				//创建Connection对象
		if(SUCCEEDED(hr))
		{
			hr = m_pConnection->Open(strConn, "", "", adModeUnknown);		//连接数据库
		}
	}
	catch( _com_error e)	//捕捉异常
	{
		cout<<"连接操作错误信息:"<<e.ErrorMessage()<<endl;
	}

	char *querySql = "select * from tb_users";
	try
	{
		m_pRecordset.CreateInstance("ADODB.Recordset");
		m_pRecordset->Open(querySql, m_pConnection.GetInterfacePtr(), adOpenStatic, adLockOptimistic, adCmdText);
	}
	catch(_com_error e)		//捕捉异常
	{
		cout<<"读取操作错误信息:"<<e.ErrorMessage()<<endl;		//显示错误信息
	}

	_variant_t RecordsAffected;
	try
	{
//		char *insertSql = "insert into tb_users values('xuwei', 'xuwei1990')";
		char *insertSql = "execute insertUser 'hello', 'test'";
		m_pConnection->Execute((_bstr_t)insertSql, &RecordsAffected, adCmdText);
	}
	catch(_com_error e)
	{
		cout<<"插入操作错误信息:"<<e.ErrorMessage()<<endl;
	} 
	CoUninitialize();
	return 0;
}