数据库在本地,安全模式为windows身份验证:
_bstr_t strConnect="Provider=SQLOLEDB.1;Server=95-PC;Database=school;Integrated Security=SSPI";
hr = m_pConnection->Open(strConnect,"","",adModeUnknown);
注意一定要有Integrated Security=SSPI,不然连接数据库会报错。
数据库在远程,安全模式为SQL server身份验证:
_bstr_t strConnect="Provider=SQLOLEDB.1;Server=192.168.4.67;Database=RiskControl;";
hr = m_pConnection->Open(strConnect,"sa","123456xyz",adModeUnknown);