VS2005C++连接数据库

2008-06-15 06:40

#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()); } }