就急,ADO和Access2000，在线等待

Question

如果有密码，使用_ConnectionPtr应该怎样写？
_ConnectionPtr m_pConnection;
m_pConnection.CreateInstance("ADODB.Connection");
m_pConnection->ConnectionTimeout = 8;
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data ource=userinfo.mdb","怎样写","怎样写",adModeUnknown);就急阿！

Answer 1

HRESULT hr;     
hr = m_pConnection.CreateInstance("ADODB.Connection");
    
if(SUCCEEDED(hr))
{
m_pConnection->ConnectionTimeout =2;
hr = m_pConnection->Open("driver={SQL Server};Server=127.0.0.1,1433;Provider=sqloledb;Network Library=DBMSSOCN;DATABASE=baDFe;UID=sa;PWD=1234","","",adModeUnknown);
}
    else
{
MessageBox( NULL, TEXT("Database Connect Error,Plsease check the data server. ")
TEXT("The server will now quit."),
g_strAppName, MB_OK | MB_ICONERROR );
return 0;
    }

Answer 2

拜托，老兄，我是用的Access2000，不是Sql Server

Answer 3

DataConn.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.mdb;Persist Security Info=False;Jet OLEDB:Database Password=***;