请问DSN和非DSN连接SQL数据源有什么不一样啊,谢谢
我用
ADOConn->Open("DSN=DSNsalary;Provider=MSDASQL","sa","", adConnectUnspecified);
可以执行正常的查询
但是用
ADOConn->Open("Provider=SQLOLEDB.1; Server=UDBUI1; DATABASE=salary;UID=sa;PWD=",L"",L"",adOpenUnspecified);
怎么好象能连接到数据源,却什么也查不到啊,谢谢
BOOL CMultiViewApp::ADOExecute(_RecordsetPtr &ADOSet, _variant_t &strSQL)
{
if ( ADOSet->State == adStateOpen) ADOSet->Close();
try
{
ADOSet->Open(strSQL, ADOConn.GetInterfacePtr(), adOpenStatic, adLockOptimistic, adCmdUnknown);
return true;
}
catch(_com_error &e)
{
CString err;
err.Format("ADO Error: %s",(char*)e.Description());
AfxMessageBox(err);
return false;
}
}
strQuery="select * from salary1 where name='"+m_name+"' and date='"+date+"'";
theApp.ADOExecute(theApp.m_pADOSet, strQuery);