AfxOleInit();//这就是初始化COM库
_ConnectionPtr pConn;
if (FAILED(pConn.CreateInstance("ADODB.Connection")))
{
AddResult("Create Instance failed!");
return -1;
}
CString strSRC;
strSRC="Driver=SQL Server;Server=";
strSRC+="192.168.0.1";
strSRC+=";Database=";
strSRC+="mydb";
strSRC+=";UID=sa;PWD="; CString strSQL = "Insert into AlbumLibs(AlbumLib_Id,AlbumLib_Albumserialno,AlbumLib_AlbumName,AlbumLib_AlbumDate,AlbumLib_AlbumDescr)values(3,'123456','male','2009-09-18','truurtyu')";
_variant_t varSRC(strSRC);
_variant_t varSQL(strSQL);
_bstr_t bstrSRC(strSRC);
if (FAILED(pConn->Open(bstrSRC,"","",-1)))
{
AddResult("Can not open Database!");
pConn.Release();
}
COleVariant vtOptional((long)DISP_E_PARAMNOTFOUND,VT_ERROR);
_variant_t RecordsAffected;
pConn->Execute(_bstr_t(strSQL),&RecordsAffected,adCmdText);
pConn.Release();
return 1;
pConn->Execute(_bstr_t(strSQL),&RecordsAffected,adCmdText);
出错!!!!!!!!!!!!!!!!!!
First-chance exception in AddSongInfo.exe (KERNEL32.DLL): 0xE06D7363: Microsoft C++ Exception.
_ConnectionPtr pConn;
if (FAILED(pConn.CreateInstance("ADODB.Connection")))
{
AddResult("Create Instance failed!");
return -1;
}
CString strSRC;
strSRC="Driver=SQL Server;Server=";
strSRC+="192.168.0.1";
strSRC+=";Database=";
strSRC+="mydb";
strSRC+=";UID=sa;PWD="; CString strSQL = "Insert into AlbumLibs(AlbumLib_Id,AlbumLib_Albumserialno,AlbumLib_AlbumName,AlbumLib_AlbumDate,AlbumLib_AlbumDescr)values(3,'123456','male','2009-09-18','truurtyu')";
_variant_t varSRC(strSRC);
_variant_t varSQL(strSQL);
_bstr_t bstrSRC(strSRC);
if (FAILED(pConn->Open(bstrSRC,"","",-1)))
{
AddResult("Can not open Database!");
pConn.Release();
}
COleVariant vtOptional((long)DISP_E_PARAMNOTFOUND,VT_ERROR);
_variant_t RecordsAffected;
pConn->Execute(_bstr_t(strSQL),&RecordsAffected,adCmdText);
pConn.Release();
return 1;
pConn->Execute(_bstr_t(strSQL),&RecordsAffected,adCmdText);
出错!!!!!!!!!!!!!!!!!!
First-chance exception in AddSongInfo.exe (KERNEL32.DLL): 0xE06D7363: Microsoft C++ Exception.
解决方案 »
- 通过完成端口,可以收到连接的建立和断开的消息么? 不通过各种Select。
- 双击工具栏使之浮动
- 弱智问题,在DLG类里有一个变量,是一个类,如何在这个类里得到DLG窗口,直接进行控制?
- 怎么能利用Combo box 输入两种不同类型的数据 ?????????(高手指点)
- 请教各位大侠,有没有什末方法,可以把一个exe文件嵌入IE?
- opcAsync 异步读写编译错误
- 由于我以别的打开方式打开过DLL,DLL文件的图标就改变了,现在我不知道怎么改回来???
- 关于RUNTIME_CLASS()的问题!!(请帮忙)
- ado访问数据库的问题(在线等)
- windows下字符的宽度
- vc调用WinExec为何无法结束程序啊
- 利用中间层驱动给封包加密解密
出错!!!!!!!!!!!!!!!!!!
try
{
....
}
catch( _com_error &e)
{
_bstr_t str = e.ErrorMessage();
_bstr_t str1 = e.Description();
}
{
BOOL bResult = FALSE;
try
{
_variant_t RecordsAffected; m_pConnection->Execute((LPCTSTR)strSql,&RecordsAffected,0); bResult = TRUE; }
catch(_com_error e)///捕捉异常
{
CString errormessage;
errormessage.Format("SQL执行失败!\r\n错误信息:%s SQL:%s",(char*)(e.Description()),(LPCTSTR)strSql);
CLog::Log(errormessage);
} return bResult;
}