·¢ÏÖACCESSµÄBUG
ÏÈ´´½¨Ò»¸ö±í,
È»ºóÆôÓÃÊÂÎñ,
½Ó×Åɾ³ýÒ»¸ö²»´æÔڵļǼ,
ÔÙɾ³ý±í,
×îºó½áÊøÊÂÎñ,
ÔËÐÐʱÔÚɾ³ý±íʱ³ö´í£¬
ADOµÄ±¨´íÐÅÏ¢ÊÇ£º
ÓÉÓÚ±í 'ssss' Õý±»±ðµÄÓû§»ò½ø³ÌʹÓã¬Êý¾Ý¿âÒýÇæÎÞ·¨Ëø¶¨Ëü¡£
ÒÔÉÏ´úÂëÔÚʹÓÃOracleʱ˳ÀûÔËÐÐͨ¹ý£¬
Ψ¶ÀACCESS²»ÐУ¬
Èç¹ûÈ¥µôÊÂÎñµÄ´úÂë¾ÍûÎÊÌ⣬
Èç¹ûֻȥµôɾ³ý¼Ç¼µÄ´úÂëҲûÎÊÌ⣬
Èç¹û°Ñɾ³ý¼Ç¼µÄ´úÂë¸ü»»³É¼ìË÷¼Ç¼ҲûÎÊÌ⣬
µ«ÊÂÎñºÍɾ³ý¼Ç¼µÄ´úÂëͬʱ´æÔÚ¾ÍÓÐÎÊÌ⣬
ÎÒÊÇÔÚVS2008ÉÏʹÓÃADO£¬
Microsoft.Jet.OLEDB.4.0ºÍMicrosoft.ACE.OLEDB.12.0¶¼ÊÔ¹ý£¬
¶¼ÓÐÕâ¸öÎÊÌ⣬
Ôõô¿´¶¼ÏñÊÇACCESSµÄBUG¡£
´úÂëÈçÏ£º
#include <locale.h>
#include <atlstr.h>
#include <atlcom.h>
#import "c:\Program Files\Common Files\System\ado\msado15.dll" rename_namespace("ADO_ns") rename("EOF","ADO_EOF")
#import "c:\Program Files\Common Files\system\ado\msadox.dll" rename_namespace("ADO_EX_ns")
void Init(ADO_ns::_ConnectionPtr& clConnection)
{
if (FAILED(clConnection.CreateInstance(__uuidof(ADO_ns::Connection))))
{
throw 0;
}
try
{
ADO_EX_ns::_CatalogPtr clLocal = NULL;
if (FAILED(clLocal.CreateInstance((
Ïà¹ØÎÊ´ð£º
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡¡
xx.aspΪ£º
<html>
<hea ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......
ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:
public static Product[] SearchProducts(string keyword, int categoryID, int pa ......