xp环境,sql个人版, ID:sa password: sa
在一个基于对话框的工程中,可能存在很多个对话框,比如工程名为ado,则在工程的公共类ado.cpp里添加下面的变量,因为其他对话框也可能会用到与数据的链接
_ConnectionPtr m_pConnection;
_RecordsetPtr m_pRecordset;
链接方式:
1.m_pConnection->Open("driver={SQL Server};User ID=sa;Password=sa;Server=(local);DATABASE=data1","","",adModeUnknown);可行
2._bstr_t strConnect = "Provider=SQLOLEDB.1;Password=sa;Persist Security Info=False;User ID=sa;Initial Catalog=JXIMS;Data Source=(local)";
m_pConnection->Open(strConnect,"","",adModeUnknown);也可以
3._bstr_t strConnect ="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa ;Initial Catalog=JXIMS;Data Source=(local)";
m_pConnection->Open(strConnect,"","",adModeUnknown);也可以
但是2和3的Data Source=(local)改为Data Source=localhost;时就不行了,我电脑上的是local.