VC与数据库的建立链接.docVIP

VC连接SQL SERVER数据库void smsLogon::InitSQLServer(CString server, CString db, CString UserName, CString Pwd){m_pConnection.CreateInstance(ADODB.Connection);CString strCn; strCn.Empty();strCn=provider=SQLOLEDB; data source=+server+; initial catalog=+db+; userID=+UserName+; Password=+Pwd;_variant_t bcnstr=_variant_t(strCn);_variant_t bunstr=_variant_t(UserName);_variant_t bpwdstr=_variant_t(Pwd);//打开一个连接try{m_pConnection-Open(_bstr_t(bcnstr),_bstr_t(bunstr),_bstr_t(bpwdstr),-1);//adOpenUnspecified}catch(_com_error e){CString errormessage;errormessage.Format(Warning: