求 C++和SQL Sever2005 数据库连接的具体步骤

Question

包括获得连接字符串的过程  求能人指点 或者推荐个学习资料

Answer 1

网上一堆：
http://hi.baidu.com/nkym0626/blog/item/c25c6b1e1f769af31ad57677.html
http://topic.csdn.net/u/20100907/23/ecf4483a-9809-4499-85e4-b360b088f4a1.html

Answer 2

http://topic.csdn.net/u/20111028/14/186567e7-e9a2-4ee8-8eb6-5604d4ebd9db.html?89982http://topic.csdn.net/u/20111029/17/61b07f86-5f05-4f70-aa6f-7e022f8a0d5b.html?38604你看我这两个帖子！

Answer 3

给你例子： HRESULT hr;
_ConnectionPtr adoConn;
_RecordsetPtr adoRs;
        CString sql;        _bstr_t m_ConnectionString=_T("Provider=SQLOLEDB;Server=(local);Database=数据库名; uid=sa;Password=;");
        sql.Format(_T("select * from VIEW_Compensate where ID=%d "),id);
try
{
hr = adoConn.CreateInstance(__uuidof(Connection));
hr = adoRs.CreateInstance(__uuidof(Recordset));                hr = adoConn->Open((BSTR)m_ConnectionString, L"", L"", adCmdUnspecified);
hr=m_rec->Open((LPCTSTR)sql, (IDispatch*)adoConn, adOpenUnspecified,
adLockUnspecified, adCmdUnspecified);
                
catch(_com_error& e)
{
        }