数据库连接出错,高手求救!!

[yeyuanzhi2000]

我封装一个ADOConn类:
void ADOConn::OnInitADOConn()
{
try
{
::CoInitialize(NULL);
m_pConnection=NULL;
m_pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->ConnectionString="uid=;pwd=;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=WaterDB.mdb;";
m_pConnection->Open(L"",L"",L"",adCmdUnspecified);
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
}
}

_RecordsetPtr& ADOConn::GetRecordSet(_bstr_t bstrSQL)
{
try
{
if(m_pConnection==NULL)
OnInitADOConn();
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pRecordset->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
}
catch(_com_error e)
{
e.Description();
}
return m_pRecordset;
}

BOOL ADOConn::ExecuteSQL(_bstr_t bstrSQL)
{
try
{
if(m_pConnection==NULL)
OnInitADOConn();
m_pConnection->Execute(bstrSQL,NULL,adCmdText);
return true;
}
catch(_com_error e)
{
e.Description();
return false;
}
}

void ADOConn::ExitConnect()
{
m_pRecordset->Close();
m_pConnection->Close();
m_pRecordset=NULL;
m_pConnection=NULL;
::CoUninitialize();
}
用查询没问题,但当我用insert into语句时,
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
CString sql,code,name,type,price,num,date;
m_code.GetWindowText(code);
m_name.GetWindowText(name);
m_type.GetWindowText(type);
m_price.GetWindowText(price);
m_num.GetWindowText(num);
m_date.GetWindowText(date);
sql.Format("insert into product values('%s','%s','%s','%s','%s','%s')",code,name,type,price,num,date);
_RecordsetPtr m_pRecordset;
m_pRecordset=m_AdoConn.GetRecordSet((_bstr_t)sql);
m_AdoConn.ExitConnect();
添加成功了,但还有错误的提示:
This application has requested the Runtime to terminate it in an unusual way.Please contact the application's support team for more information.怎么会这样?如何修改?高手请赐教!谢谢!!!

[yeyuanzhi2008]

谁知道,很急啊!!要分我加

[hurryboylqs]

很明显,你的记录集是空的,关闭当然会runtime error ,这也许是ADO的一个bug吧,总之你close的记录集不能为空

[hurryboylqs]

void ADOConn::ExitConnect()
{
	//m_pRecordset->Close();你用insert into并不是执行查询,只是SQL插入数据,没有记录返回给你的,
        //所以执行类似的语句用Connection对象或者_CommandPtr	来执行即可
	m_pConnection->Close();	
    m_pRecordset.Release();
	m_pConnection.Release();
	::CoUninitialize();
}

[yeyuanzhi2008]

hurryboylqs,你真是高手.谢谢!!

[闪破风浪]

::CoInitialize(NULL);
::CoUninitialize();
在同一函数内使用，不要跨函数。。。。。
配对使用的。。。。。

[LWYY52243548]

m_pRecordset->Close();
m_pConnection->Close();
m_pRecordset=NULL;
m_pConnection=NULL;
::CoUninitialize();

改成:
m_pRecordset.Release();
m_pConnection.Release();
::CoUninitialize();

[yeyuanzhi2000]

谢谢!!不过还有问题啊,我有源码,哪位高手能不能帮我调试?谢谢!!
http://bbs.bccn.net/viewthread.php?tid=206021&extra=page%3D1&frombbs=1
用户yeyuanzhi密码8234663

[闪破风浪]

晚上回来再看看，
马上要出去了。。。