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