About ADO ???????????

Question

我有代码如下：_ConnectionPtr p_conn = NULL
p_conn.CreateInstance( "ADODB.Connection" );
p_conn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\temp\sjxtsjk.mdb;UID=admin;PWD=admin","","",-1);编译器提示出现异常，请问怎么该一下，感激不尽！！！！！！！

Answer 1

AfxOleInit();
m_pConnection.CreateInstance("ADODB.Connection");
/******************连接数据库********************/
try
{
m_pConnection->ConnectionTimeout = 8;
//连接SQL SERVER
//m_pConnection->Open("Driver=SQL Server;Database=test;Server=127.0.0.1;UID=sa;PWD=;","","",adModeUnknown);
//连接ACCESS2000
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=userinfo.mdb","","",adModeUnknown);
}
catch(_com_error e)///捕捉异常
{
AfxMessageBox("数据库连接失败!");
return FALSE;
}

Answer 2

::CoInitialize(NULL);
_ConnectionPtr pConn;
pConn.CreateInstance(__uuidof(Connection));
try
{
pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:\\database.mdb;","","",-1);
}catch(_com_error e)
{
    AfxMessageBox("fail to connect the database!");
}