高手们啊，help!!

[Only_01]

void CtempDlg::OnBnClickedButton1()
{
// TODO: 在此添加控件通知处理程序代码
::CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Hotel.mdb","","",adModeUnknown);
pRst=pConn->Execute("select * from hotel",NULL,adCmdText);
if(!pRst->adoEOF)
{
pRst->Update();//如果有这句话，就会出现 Runtime library错误。如果没事，就可以运行
}
::CoUninitialize();
}
高手帮一下，好几天了也没解决啊，愁啊

[sincor]

学习 帮你顶 让高手 看到 这里面有高手 肯定能解决你的问题

[Only_01]

呵呵。谢谢啊

[wiowei]

_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
为何都没有创建对象：

// 创建Connection对象
pConn.CreateInstance("ADODB.Connection");
// 创建记录集对象
pRst.CreateInstance(__uuidof(Recordset));

另外open之后加个语句看有没有成功：

if(pConn==NULL)
　　　cerr<<"Lind data ERROR!n";

[wiowei]

给你个蛮好ADO例子参考吧：http://www.yesky.com/277/1893277.shtml

[星羽]

Open 和 Execute 判断一下成功了没

[lsd1025]

ADO连接数据库吧，
连接数据库，创建记录集打开表等最好分开封装成函数吧！
感觉你全部放在这里这样用感觉不太好的，找个正规的数据库的程序了解一下处理放置布局吧，
你这样感觉不是很好的。

[oyljerry]

Update前总要修改一下数据什么的...

1. VC把一个文件存入数据库

  CFile imagefile;
  if(0 == imagefile.Open("d:\user\bmp.bmp",CFile::modeRead))
     return;
  _RecordsetPtr pRs = NULL;             
  _ConnectionPtr pConnection = NULL;
  _variant_t varChunk;
  HRESULT hr;
  BYTE* pbuf;
  long nLength = imagefile.GetLength();
  pbuf = new BYTE[nLength+2];
  if(pbuf == NULL)
     return;                             //allocate memory error;
  imagefile.Read(pbuf,nLength);          //read the file into memory

  BYTE *pBufEx;
  pBufEx = pbuf;
  //build a SAFFERRAY
  SAFEARRAY* psa;
  SAFEARRAYBOUND rgsabound[1];
  rgsabound[0].lLbound = 0;
  rgsabound[0].cElements = nLength;
  psa = SafeArrayCreate(VT_UI1, 1, rgsabound);

  for (long i = 0; i < nLength; i++)
       SafeArrayPutElement (psa, &i, pBufEx++);
  VARIANT varBLOB;
  varBLOB.vt = VT_ARRAY | VT_UI1;
  varBLOB.parray = psa;

  _bstr_t strCnn("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CUSTOM;Data Source=SERVER");    
    try
    {
        //Open a connection
        pConnection.CreateInstance(__uuidof(Connection));
        hr = pConnection->Open(strCnn,"","",NULL);   //Connect a DataBase
        pRs.CreateInstance(__uuidof(Recordset));
        pRs->Open("CustomInfo",_variant_t((IDispatch *) pConnection,true),adOpenKeyset,adLockOptimistic,adCmdTable);  //Open a Table
 
       
        pRs->Fields->GetItem("Image")->AppendChunk(varBLOB);        
        pRs->Update();
        pRs->Close();
        pConnection->Close();
 }
    catch(_com_error &e)
    {
        // Notify the user of errors if any.
        _bstr_t bstrSource(e.Source());
        _bstr_t bstrDescription(e.Description());
        CString sError;
        sError.Format("Source : %s Description : %s",(LPCSTR)bstrSource,(LPCSTR)bstrDescription);
        AfxMessageBox(sError);     
 }

[bfhtian]

up