VS2005C++连接数据库

#include <afxwin.h>
#include <stdio.h>
#import "c:/program files/common files/system/ado/msado15.dll" no_namespace rename("EOF","adoEOF")
void main()
{
CString sql;
::CoInitialize(NULL);
_RecordsetPtr PRs("ADODB.Recordset");
_ConnectionPtr PConn("ADODB.Connection");
_variant_t RecordsAffected;

try
{
PConn.CreateInstance("ADODB.Connection");
PRs.CreateInstance(__uuidof(Recordset));
sql.Format("provider=sqlOLEDB;server=(local);database=mydata;Uid=sa;pwd=password;");
PConn->Open((_bstr_t)sql,"",adModeUnknown);
if(PConn==NULL)
{
printf("Connect sqlserver error!/n");
}
else
{
printf("Connect sqlserver success!/n");
}
catch(_com_error e) //异常
{
printf("Connect Error: %s/n",(char *)e.ErrorMessage());
}
}

（编辑：北几岛）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

2008-06-15 06:40