Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ACCESS 2007 ADO Á¬½ÓÎÊÌ⣬лл°ïæÁË£¨ÐÂÈËûÓз֣©

StdAfx.hÖУº

#import "C:\program files\common files\System\ado\msado15.dll" no_namespace rename("EOF","adoEOF")

³õʼ»¯ÈçÏÂAPP£º

        if(!AfxOleInit())//Õâ¾ÍÊdzõʼ»¯COM¿â
{
AfxMessageBox("OLE³õʼ»¯³ö´í!");
return FALSE;
}


COMMAND£ºDLGÖÐ

m_pConnection.CreateInstance(_uuidof(_Connection));
try               
{
// ´ò¿ª±¾µØAccess¿âTESS.accdb
m_pConnection->Open("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=TESS.accdb;Persist Security Info=False",
"","",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü£¬È·ÈÏÊý¾Ý¿âTESS.accdbÊÇ·ñÔÚµ±Ç°Â·¾¶ÏÂ!");
AfxMessageBox(e.ErrorMessage());
}


´íÎó£º Invalid pointer


m_pConnection Öµ {0x00000000}
ÄÄÀﱨ´íµÄ£¿

Ã÷Ã÷ÓÐ200¶à¿ÉÓ÷֣¬È´ËµÐÂÈËûÓз֡£×¼±¸ÄÿÉÓ÷ֻØÈ¥Âò·¹³ÔÂ𣬻¹ÊÇÂò·¿×Ó¡£

ÒýÓÃ
ÄÄÀﱨ´íµÄ£¿


±àÒëͨ¹ý£¬ÔËÐÐʱµã»÷ÃüÁî°´Å¥
Ö´ÐÐÕâÁ½¾ä£º
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü£¬È·ÈÏÊý¾Ý¿âTESS.accdbÊÇ·ñÔÚµ±Ç°Â·¾¶ÏÂ!");
AfxMessageBox(e.ErrorMessage());

´íÎó£º Invalid pointer



Ïà¹ØÎÊ´ð£º

access ²éѯ¼Ç¼µÄÎÊÌâ?

ÎÊÌâÈçÏ£º

ÓòéѯÓï¾ä
select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´
¸ÄΪ
select * from tab where fil = 'CK090902'
¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......

ÈçºÎͨ¹ýADOʹÓþۺϺ¯ÊýÀ´²éѯ(Êý¾Ý¿âΪACCESS)

_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
    int ret = 0;
  _RecordsetPtr pset;
CString  sql;
& ......

ÎÒÕâACCESS±íµÄÏÔʾÈçºÎÇл»³ÉÏÂÃæÕâÕÅͼÀ´

ÎÒĿǰ±íµÄÅÅÁÐÊÇÉÏÃæÕâÕÅͼÕâÇé¿ö£º

ÎÒÏ£Íûµ÷Õû³É£º

ÈçºÎ×öÄØ£¿
¸Õ²ÅÊÔÁËÏ£¬µã¡°¿ªÊ¼¡±--¡°ÊÓͼ¡±--¡°Éè¼ÆÊÓͼ¡±²»ÐÐ

PS£ºÎÒÓõÄÊÇaccess 2007£¬ÉÏÃæÕâ¸ö±íÊÇmdb¸ñʽµÄ

Ö÷²Ëµ¥£¬ ÊÓͼ ......

´íÎóÐÅÏ¢Access violation....

ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......

50ÍòÌõÊý¾ÝACCESSÊý¾Ý¿â,Ä£²éѯÓÐʲô·½·¨ÄÜ¿ìЩ...

ÎÒÓÃÁËÒ»°ãµÄ²éѯÓï¾ä³öÀ´,,,ÍÛºÃÂý°¡................



ʹÓÃ×é¼þ

DBgrid  ADOQuery  DATASOurce

¿ì²»ÁË£¬Ö»Äܾ¡¿ÉÄܵÄÓÅ»¯°É
ÓÅ»¯Êý¾Ý½á¹¹£¬½¨Ë÷Òý£¬²»¹ý½¨Òé²»ÒªÒ»´Î¶Á³öËùÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ