MFCÁ¬½ÓACCESS ³ö´í
Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\access\db1.mdb;Persist Security Info=False";
pConn->Open("","","",adConnectUnspecified);
pRst=pConn->Execute("select * from author",NULL,adCmdText);
while(!pRst->rsEOF)
{
((CListBox*)GetDlgItem(IDC_LIST1))->AddString(
(_bstr_t)pRst->GetCollect("jk"));
pRst->MoveNext();
}
pRst->Close();
pConn->Close();
pRst.Release();
pConn.Release();
CoUninitialize();
±àÒëͨ¹ý£¬µ«Ö´Ðгö´í
abnormal program termination
D:\access\db1.mdb;
¸Ä³É
D:\\access\\db1.mdb
ÊÔÊÔ
»¹ÊDz»ÐÐ
¶Ïµã£¬F10£¬¿´ÎÊÌâÔÚÄÄÀï
pRst.Release();
pConn.Release();
pRst->Close();
pConn->Close();
˳Ðò·´Á˰É.
²»Ðа¡
¸Ä³ÉÈçÏÂÐÎʽÊÔÊÔ(δÔÚ±¾ÈË»úÆ÷ÉϲâÊÔ¹ý)
ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\access\db1.mdb;Persist Security Info=False";
pConn->Open(ConnectionString,"","",adConnectUnspecified);
żÀ´Ä÷ÖÊýµÄÀ²
pConn->Open("&qu
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
ÎÒµÄÒ»¸öaccessÊý¾Ý¿âÖеÄphoto×Ö¶ÎÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
|/UpFiles/Picture/admin/200910162300187612.jpg|/UpFiles/Picture/admin/200910162300187612.jpg||||/UpFiles/Picture/admin/200910162300187612.jpg ......
ËüµÄ¶¨ÒåÊÇÕâÑùµÄ
_CRTIMP __checkReturn int __cdecl _access(__in_z const char * _Filename, __in int _AccessMode);
´ó¸ç£¬¿´¸öº¯ÊýÉùÃ÷¾ÍÄÜ¿´³öËû¸ÉɶµÄ£¿
´ÓÃüÃûÀ´¿´Ó¦¸ÃÊÇÅж ......
ÎÒ°ÑsqlµÄÊý¾Ý¿â»»ÎªaccessÊý¾Ý¿â£¬Ö»ÐÞ¸ÄÁËÁ¬½ÓÎļþ£¬ÆäËüµÄ¶¼Ã»Óиı䣬³öÏÖ´íÎó(0x80004005)
無·¨Ö¸³öµÄ錯誤¡£
function returnrsByParam(strsql,con,cursor_type,lock_type,options)
......