·¢ÏÖ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((
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......
¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 -
------------------------------------------------------------------------------- ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......