¼òµ¥½éÉÜ
aspÊǺܼòµ¥µÄ£¬ÒÔÖÁÓÚÐí¶àµÄÑз¢Õß²»»áȥ˼¿¼´íÎó´¦Àí¡£´íÎó´¦ÀíÄܹ»ÈÃÄúµÄÓ¦ÓóÌʽ¸ü¼ÓºÏÀí¡£ÎÒ¿´µ½¹ýºÜ¶à¸öÓÃasp±àдµÄÉÌÒµÍøÕ¾£¬´ó¶àÊý¶¼ºöÂÔÁË´íÎó´¦Àí¡£
´íÎóµÄÀàÐÍ
ÓÐÈýÖÖÖ÷ÒªµÄ´íÎóÀàÐÍ£º
±àÒë´íÎó£º
ÕâÖÖ´íÎó³öÏÖÒ»°ã¶¼ÊÇ´úÂëµÄÓï·¨ÎÊÌâ¡£ÒòΪ±àÒë´íÎó¶øµ¼Ö´ÇaspÍ£Ö¹ÔËÐС£
ÔËÐдíÎó
Õâ¸ö´íÎóÊÇ·¢ÉúÔÚÄú×¼±¸ÔËÐÐaspʱµÄ¡£ÀýÈ磺¼ÙÈçÄúÊÔͼ¸øÒ»¸ö±äÁ¿¸³Öµ£¬µ«ÊÇÈ´³¬³öÁ˸ñäÁ¿ÔÊÐíµÄ·¶Î§¡£
Âß¼´íÎó
Âß¼´íÎóÊÇ×îÄѱ»·¢Ïֵģ¬ÕâÖÖ´íÎó¾³£ÊÇÒ»Öֽṹ´íÎ󣬵çÄÔÊÇ·¢ÏÖ²»Á˵ġ£Õâ¾ÍÐèÒªÎÒÃdz¹Í·³¹Î²µØ¼ì²éÎÒÃǵĴúÂë¡£
ÒòΪ±àÒë´íÎóÒ»°ãÊǺÍÂß¼´íÎóÒ»Æð·¢ÉúµÄ£¬Ò»°ã¶¼ÄÜÏÔʾ³öÀ´£¬ËùÒÔÎÒÃǵ£ÐĵľÍÖ»ÊÇÔËÐдíÎó¡£Ëû¶¼ÖÕÖ¹aspµÄÔËÐУ¬¶øÇÒ¸øÓû§¶ªÏÂÒ»¶ÑºÜ²»ÓѺõÄÎÄ×Ö¡£
ÄÇôÎÒÃÇÒªÔõÑù´¦ÀíÔËÐдíÎóÄØ£¡£¿ÎÒÃÇÏÈÀ´¿´¿´£¬aspΨһÌṩ¸øÎÒÃǵĴíÎóÃüÁî---on error resume next(ÕâÀïÌáÐÑһϳõѧÕߣ¬ÔÚaspÖÐÖ»ÓÐon error resume nextÓï¾ä£¬Ã»ÓÐon error resume gotoÓï¾ä£©
¼ÙÈçÄú²»Ê¹ÓÃon error resume nextÓï¾äµÄ»°,Ò»ÇÐÔËÐдíÎ󶼻ᷢÉú£¬Õâ¸öÊÇÖÂÃüµÄ£¬ÄÇô¾Í»áÓÐÒ»¶Î´íÎó´úÂë“Õ¹ÏÖ”¸øÓû§£¬¶øÇÒasp³ÌʽҲ»áÍ£Ö¹¡£
ÏÂÃæ¾ÍÊǸö´íÎó´úÂ룺
microsoft ole db provider for odbc drivers error 80004005
[microsoft][odbc driver manager] data source name not found and no default driver specified
/test.asp, line 60
µ±ÎÒÃÇÔÚ³Ìʽ×îÉÏÃæÊ¹ÓÃon error resume nextÓï¾äʱ£¬ÈκεĴíÎ󶼻ᱻºöÂÔ£¬³Ìʽ»á×Ô¶¯Ö´ÐÐÏÂÒ»ÌõÓï¾ä¡£ÕâÑù³Ìʽ¾Í»áÍêȫִÐУ¬³ö´íºóÓû§Ò²²»»á¿´µ½³ö´íÐÅÏ¢¡£µ«ÊÇÕâÑùÒ²Óв»ºÃµÄµØ·½£¬ÄǾÍÊǼÙÈç³ÌʽûÓа´ÕÕÄúÏëÏñµÄÖ´Ðеϰ£¬Äú¾ÍºÜÄÑÕÒµ½µ½µ×ÊÇÄÄÀï³öÁËÎÊÌ⣬ËùÒÔÄú¾ÍµÃÔÚ±ØÒªµÄµØ·½¶Ô´íÎó½øÐд¦Àí¡£
´¦Àí´íÎó
ÔÚaspÖУ¬´¦Àí´íÎóµÄ×îºÃµÄ°ì·¨¾ÍÊÇÔÚ³Ìʽ×îµ×¶Ë·ÅÉÏ´úÂëÀ´´¦Àí´íÎó¡£ÎÒÒ²ÍÆ¼öÔÚÿ¸öasp³Ìʽ¶¼Ê¹Óûº³åÇø¡£ÕâÑùµÄ»°£¬¼ÙÈç´íÎó·¢Éú£¬Ò³Ãæ¾Í»áÍ£Ö¹£¬Ò³ÃæÄÚÈÝÒ²»á±»Çå³ý£¬ÕâÑùÓû§¾Í²»»á¿´µ½´íÎóÐÅÏ¢£¬¶ÔÄúÃǵı§Ô¹Ò²¾ÍÉÙÁË£¡ÏÂÃæÊǸöÀý×Ó£º
<%@ language="vbscript" %>
<% ÅäÖÃbufferΪtrue
response.buffer = true
¿ªÊ¼´íÎó´¦Àí
on error resume next
%>
<% ´íÎó´¦Àí
if err.number <> 0 then
Çå³ýÒ³Ãæ
response.clear
ÏÔʾ´íÎóÐÅÏ¢¸øÓû§
%>
<html>
<head>
<title></title>
</head>
<body bgcolor="#c0c0c0">
<font face="arial">an error occurred in the execution of this asp page<br>
please report the following information to the support desk<p>
<b>page error object</b><br>
´íÎó number£º <%= err.number %><br>
´íÎóÐÅÏ¢£º <%= err.description %><br>
³ö´íÎĵµ£º <%= err.source %><br>
³ö´íÐУº <%= err.line %><br>
</font>
</body>
</html>
<%end if%>
ÄúÃÇÉÏÃæ¿´µ½ÁË£¬ÎÒÊ×ÏÈÅäÖÃon error resume next £¬ÕâÑù³öÏÖ´íÎó¾Í²»»áÓ°Ïì³ÌʽµÄÖ´ÐС£
´íÎó´¦ÀíºÍÊý¾Ý¿â
ÔÚ´íÎó´¦ÀíÖмÓÈëÊý¾Ý¿âµÄÖ´ÐÐÊǺܸ´Ôӵġ£¼ÙÈôÎÒÃÇÓÐÒ»¸ö³Ìʽ£¬ÓкܶàµÄÃüÁîÈ¥ÏòÊý¾Ý¿âÖÐÌí¼Ó¼Ç¼£¬¼ÙÈçinsert/updateÔÚ³ÌʽµÄ×îµ×²¿Ö´ÐУ¬¼ÙÈçÎÒÃÇÇ°ÃæÓÖ´íÎó·¢Éú£¬ÄǾÍÍêÁË£¡ÎÒÃǾͻáÏòÊý¾Ý¿âÖÐÌí¼ÓÁËÒ»¸ö´íÎóµÄÐÅÏ¢¡£ÒòΪÎÒÃÇÓÃÁËon error resume next Ò»ÇеĴíÎó¶¼±»ºöÂÔÁË£¡¼´Ê¹Ç°Ãæ³ö´í£¬³ÌʽÒÀ¾É»áÏòÊý¾Ý¿âÖÐÌí¼ÓÊý¾ÝµÄ¡£
Ϊ±ÜÃâÕâÖÖÇé¿ö£¬ÎÒÃǾÍÏȵÃ×öЩÊֽţ¬ÕýÈ·´¦ÀíµÄ·½·¨ÈçÏ£º
if err.number = 0 and objconnection.errors.count = 0 then
ÕâÀï²ÅÄÜÖ´ÐÐÓï¾ä£¬ÒòΪûÓдíÎó
set rstresults = dbdata.execute(txtsql)
end if
¸ü¶à¸ß¼¶µÄ´¦Àí°ì·¨
µ±Ò»¸ö´íÎó·¢Éúʱ£¬ÄúÃÇÒ²Äܹ»ÏÔʾ¸ü¶àµÄ´íÎóÐÅÏ¢¡£ÏÂÃæÊÇͬʱ´¦ÀíÊý¾Ý¿âºÍÒ³Ãæ´íÎóµÄÀý×Ó£¬ÓÐÁËËûÎÒÃÇһϾÍÄÜ·¢ÏÖÎÒÃdzÌʽÖеÄÈκδíÎó¡££¨ÓÉÓÚÓÐЩµØ·½ÎÒ¾õµÃÓ¢ÎĸüÄÜ˵ʱÎÊÌ⣬ËùÒÔûÓзÒ룩¡£
<%
if err.number <> 0 then
response.clear
select case err.number
case 8 Ö¸¶¨´íÎóµÄnumber
ÔÚÕâÀï´¦Àí×Ô¶¨Òå´íÎó
case else Ò»°ã´íÎó
if isobject(objconnection) then
if objconnection.errors.count > 0 then
%>
<b>database connection object</b>
<% for intloop = 0 to objconnection.errors.count - 1 %>
error no: <%= objconnection.errors(intloop).number %><br>
description: <%= objconnection.errors(intloop).description %><br>
source: <%= objconnection.errors(intloop).source %><br>
sqlstate: <%= objconnection.errors(intloop).sqlstate %><br>
nativeerror: <%= objconnection.errors(intloop).nativeerror %><p>
<% next
end if
end if
if err.number <> 0 then
%>
<b>page error object</b><br>
error number <%= err.number %><br>
error description <%= err.description %><br>
source <%= err.source %><br>
linenumber <%= err.line %><p>
<% end if
end select
end if
%>
ÉÏÃæµÄÀý×ÓÈÃÎÒÃÇÒ»ÏÂÁË´¦ÀíÁ˺ܶàÔÚÊý¾Ý¿âÖгöÏÖµÄÎÊÌ⣬Õâ¸öÔÚÎÒÃÇÈÕ³£±à³ÌÒ²Êdz£Óõģ¡ÎÒÃÇÒ²Ó¦¸Ã¿´µ½ÄǸöselect case Óï¾ä£¬ËûÄÜÈÃÎÒÃÇÀ´´¦ÀíÌØ¶¨µÄ´íÎó¡£
redirect ºÍ´íÎó´¦Àí
ÓÐÒ»µãÎÒÃǾ͵±×¢Òâһϣ¬¾ÍÊÇÎÒÃdz£Óõ½µÄredirect¶ÔÏ󣬼ÙÈçÒ»¸öÒ³ÃæÖгöÏÖÁËredirect¶ÔÏó£¬ÄÇô´íÎó´¦Àí¾ÍʧȥÁËÒâÒå¡£ËùÒÔÔÚתÏò֮ǰÎÒÃÇ»¹µÃ´¦Àíһϣ¬ÈçÏ£º
if err.number = 0 and objconnection.errors.count = 0 then
response.clear
response.redirect ?lt;url here>?
end if
°Ñ´úÂë±äµÃ¸üÕûÆë
ΪÁËÈôúÂë±äµÃ¸üÕûÆë£¬Ê×ÏȰѴíÎó´¦ÀíµÄÎĵµ·ÅÔÚÒ»¸ö°üº¬ÎĵµÖС£ÕâÑùÄú¾ÍÄܹ»ÔÚÈκÎÎĵµÖÐʹÓÃËû¡£ÕâÑùÐÞ¸ÄÒ²·½±ã¡£
ÔÚÄú³ÌʽµÄ×îÉÏ·½¼ÓÈë(µ±È»ÔÚÓïÑÔÉùÃ÷Ö®ºó£©on error resume nextÓï¾ä¡£
ÔÚÄúÖ´ÐÐsqlÒÔǰ½øÐдíÎó¼ì²é¡£
ʹÓÃredirectÒÔǰҲҪ½øÐдíÎó´¦Àí¡£
ÈÃÄú´¦Àí´íÎóµÄ°üº¬ÎĵµÔÚ´úÂëµÄ×îÉÏÃæ
°²»ÕлªµçÄÔѧУרҵְҵ¹æ»®Ê¦ÎªÄãÌṩ¸ü¶à°ïÖú¡¾ÔÚÏß×Éѯ¡¿
ASP´íÎó´¦Àí
2010-01-17 10:40:09 ×÷Õß: À´Ô´:
ÉÏһƪ£ºdl,dt,dd,ul,li,olÇø±ð¼°Ó¦ÓÃ
ÏÂһƪ£ºASPÍøÕ¾·À·¶ºÚ¿Í¼¼ÇÉ