各位兄弟帮帮忙,以下语句执行竟然不成功了!!!!!
如下一段OLE DB的语句原来在另一个程序中可用,现在单独测试竟然不能打开数据库!
code://////////////////////////////
CComBSTR bstrServer("localsever");
CComBSTR bstrUser("sa");
CComBSTR bstrPassword("****");
CComBSTR bstrDatabase("Northwind");
if (pSession && pSession->m_spOpenRowset != NULL)
pSession->m_spOpenRowset.Release();
CDBPropSet dbinit(DBPROPSET_DBINIT);
dbinit.AddProperty(DBPROP_AUTH_PASSWORD, bstrPassword);
dbinit.AddProperty(DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO, false);
dbinit.AddProperty(DBPROP_AUTH_USERID, bstrUser);
dbinit.AddProperty(DBPROP_INIT_CATALOG, bstrDatabase);
dbinit.AddProperty(DBPROP_INIT_DATASOURCE, bstrServer);
dbinit.AddProperty(DBPROP_INIT_LCID, (long)1049);
dbinit.AddProperty(DBPROP_INIT_PROMPT, (short)4);
if(FAILED(pDataSource->Open(_T("SQLOLEDB.1"), &dbinit)))
{
CString strMsg = "Cannot connect to data source";
AfxMessageBox(strMsg);
if(pDataSource)
{
pDataSource->Close();
}
goto ErrorExit;
}
else
{
if (pSession && pSession->Open(*pDataSource) != S_OK)
{
AfxMessageBox(_T("Couldn't create session on data source"));
goto ErrorExit;
}
}
/////////////////////////////////
请指教!