access Êý¾Ý¿â±ØÐëÌî¾ø¶Ô·¾¶Âð
Óà ADOConnection Á¬½ÓÒ»¸ö Access .mdb Êý¾Ý¿âʱ
ÔÚÊäÈëÊý¾Ý¿âÃû³ÆÊ±±ØÐëÊǾø¶Ô·¾¶Âð£¿
ÔÚBCB 6 ʱ£¬ ÎÒÖ»ÊäÈëÎļþÃû¾Í¿ÉÒÔÁË¡£ ÒòΪÎÒµÄ Êý¾Ý¿âÓëÓ¦ÓÃÔÚͬһ¸öĿ¼¡£
ÔÚ 2010 Èç¹ûÖ»ÌîÎļþÃû³Æ£¬ ÔÚÏ´ÎÖØÆôRS2010´ò¿ªÏîĿʱ£¬ÌáʾÕÒ²»µ½Îļþ ÈçÏÂ
ÕÒ²»µ½Îļþ ¡®C:\Documents and Settings\neeme\×ÀÃæ\clearsky.mdb.
ÎÒµÄÎļþ²»ÔÚÕâ¸öĿ¼£¬µ«ÎªÊ²Ã´»á¼ÓÉÏÕâ¸öÄ¿Â¼ÄØ£¿
µ÷ÊÔʱÄ㽫Êý¾Ý¿â·ÅÔÚDebug»òReleaseÎļþ¼ÐÀï
ÓëÄãÉú³ÉµÄexeÎļþÔÚÒ»¸öĿ¼.´Ó2006¿ªÊ±,Éú³ÉµÄÎļþ»á·ÅÔÚµ¥¶ÀµÄÒ»¸öÎļþ¼ÐÀï
ÔËÐÐʱûÓÐÎÊÌâµÄ¡£ ÎÒÒ²°ÑÊý¾Ý¿âÎļþÔÚµ½¶ÔӦĿ¼Àï
Ö»ÊÇÔÚÐÞ¸ÄÏîĿʱ£¬ RS2010 ³öÏÖÕâ¸öÌáʾ£¡
ÎÒ·¢¾õ ÔÚ welcom page ´ò¿ªÏîĿ¼ »áÓÐÕâ¸öÎÊÌâ
ÔÚ File -> open project ´ò¿ªÏîĿ¼£¬ ûÓÐÕâ¸öÎÊÌâ
Èç¹û²»ÐÐÄã¿ÉÒÔÔÚÉè¼ÆÊ±Ê¹ÓÃÕâЩ
String DBFile = ExtractFilePath(Application->ExeName)+"\\clearsky.mdb";
String Provider1="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+DBFile+";Jet OLEDB";
ADOConnection->ConnectionString = Provider1;
ADOConnection->Open() ;
String Provider1="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+DBFile;
×î½üÀÏÊdzö´í
ÎÒ²ÂÊÇ£¬Óà welcome page ÕÒ¿ªÏîÄ¿£¬ ¹¤³ÌµÄĬÈÏĿ¼Ϊ
C:\Documents and Settings\neeme\×ÀÃæ\
Óà File->Open Project ÕÒ¿ªÏîÄ¿£¬ ¹¤³ÌµÄĬÈÏĿ¼Ϊ
¹¤³ÌµÄµ±Ç°Ä¿Â¼£
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
ÈçºÎÐÞ¸Ämsysobjects±íÖеÄÊý¾ÝÄØ£¿Ð»Ð»
ɶ¶¼Ã»ÓÐ,Òâ˼²»Ã÷È·,ÔÙÏêϸµã°É
²»Òª¸ÄsysobjectsÀïµÄ¶«Î÷¡£
ÓÃÆäËü·½·¨¸Ä£¬±íÃû»òÆäËû¡£
ÒªÔÚACCESS»·¾³ÏÂÅäÖÃȨÏÞ£¬²ÅÄÜ·ÃÎÊϵͳ±í...
лл´ó¼Ò¡£
ÊÇÕâÑù£¬¿´ ......
¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 -
------------------------------------------------------------------------------- ......
ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´ ......