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 ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎÎ ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......
ÎÒÓÃÁËÒ»°ãµÄ²éѯÓï¾ä³öÀ´,,,ÍÛºÃÂý°¡................
ʹÓÃ×é¼þ
DBgrid ADOQuery DATASOurce
¿ì²»ÁË£¬Ö»Äܾ¡¿ÉÄܵÄÓÅ»¯°É
ÓÅ»¯Êý¾Ý½á¹¹£¬½¨Ë÷Òý£¬²»¹ý½¨Òé²»ÒªÒ»´Î¶Á³öËùÓ ......