跪求VC ADO技术_ConnectionPtr Open函数的解释
请问大家，我想通过ADO技术去连接SQL SERVER 2005，我试了很多次都不行...
我的操作步骤是这样子的：
1.我往SQL Server Management Studio里导入ACCESS格式的数据库,数据库名字是student。
2.我的SQL Server Management Studio的账号密码是:sa lanyuhai
3.在程序中运用_ConnectionPtr _RecordsetPtr这两个指针;
我在OnInitDialog函数中添加如下函数:
m_pConnection.CreateInstance("ADODB.Connection");
_bstr_t strConnect="Provider=SQLOLEDB.1;Persist Security Info=TRUE;Initial Catalog=lanyuhai;Data Source=127.0.0.1";
m_pConnection->Open(strConnect,"sa","lanyuhai",adModeUnknown);
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pRecordset->Open("SELECT * FROM 学生",m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
程序运行的时候，程序运行错误...
我想应该是在设置 _ConnectionPtr里的Open函数的时候设置错了...
请问大家到底是什么原因？？？？

[解决办法]
"Provider=SQLOLEDB.1; Data Source=127.0.0.1; Initial Catalog=student; User ID=sa; PWD=lanyuhai"

[解决办法]
参考这里
http://wenku.baidu.com/view/52d9a434eefdc8d376ee32fb.html
[解决办法]

C/C++ code

_bstr_t strConnect="Provider=SQLOLEDB;Server=127.0.0.1;Database=lanyuhai;User ID=sa;pwd=lanyuhai;Persist Security Info=True";m_pConnection->Open(strConnect,"","",adModeUnknown);
[解决办法]
探讨


C/C++ code
_bstr_t strConnect="Provider=SQLOLEDB;Server=127.0.0.1;Database=lanyuhai;User ID=sa;pwd=lanyuhai;Persist Security Info=True";
m_pConnection->Open(strConnect,"","",adModeUnknown);

[解决办法]
两个问题：
1、把连接字符串改改：
 _bstr_t strConnect="Provider=SQLOLEDB;Server=(local);\
Database=数据库名; uid=sa;Password=lanyuhai;";

2、Open函数使用错误：改成：
  hr=m_pConnection->Open(strConnect,"","",adCmdUnspecified);

另外，有返回值的函数都加上hr，断点查看hr的值，确定是否为0：
C/C++ code
   HRESULT hr=m_pConnection.CreateInstance("ADODB.Connection");     _bstr_t strConnect="Provider=SQLOLEDB;Server=(local);\        Database=数据库名; uid=sa;Password=lanyuhai;";    hr=m_pConnection->Open(strConnect,"sa","lanyuhai",adModeUnknown);     hr=m_pRecordset.CreateInstance(__uuidof(Recordset));   hr=m_pRecordset->Open("SELECT * FROM 学生",m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);