VS2008连接Sqlserver2008 - ADO方式

来源：互联网发布：电商部美工岗位说明书编辑：程序博客网时间：2024/05/16 11:14

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;}