ado连接

1：ado driver={SQL Server};Server=(Local);Database=TACTICSKINGBON;UID=sa;PWD=123box

2： 通过JET数据库引擎对ACCESS2000数据库的连接：

 

m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\test.mdb","","",adModeUnknown);

 

 

 

不通过DSN对SQL SERVER数据库进行连接：

m_pConnection->Open("driver={SQL Server};Server=127.0.0.1;DATABASE=vckbase;

UID=sa;PWD=139","","",adModeUnknown); a  dModeUnknown:缺省。

或者

m_pConnection.CreateInstance("ADODB.Connection");

_bstr_t strConnect = "Provider=SQLOLEDB.1;PersistSecurityinfo=True;Server=127.0.0.1;Database=mydata;uid=sa; pwd=sa";

m_pConnection->Open(strConnect,"","",adModeUnknown);