📄 prop_err_number.asp
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-US" xml:lang="en-US" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>ADO Number Property</title>
<link rel="shortcut icon" href="../favicon.ico" type="image/x-icon" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="Keywords" content="xml,tutorial,html,dhtml,css,xsl,xhtml,javascript,asp,ado,vbscript,dom,sql,colors,soap,php,authoring,programming,training,learning,beginner's guide,primer,lessons,school,howto,reference,examples,samples,source code,tags,demos,tips,links,FAQ,tag list,forms,frames,color table,w3c,cascading style sheets,active server pages,dynamic html,internet,database,development,Web building,Webmaster,html guide" />
<meta name="Description" content="Free HTML XHTML CSS JavaScript DHTML XML DOM XSL XSLT RSS AJAX ASP ADO PHP SQL tutorials, references, examples for web building." />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />
<link rel="stylesheet" type="text/css" href="../stdtheme.css" />
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "../../https@ssl./default.htm" : "../../www./default.htm");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-3855518-1");
pageTracker._initData();
pageTracker._trackPageview();
</script>
</head>
<body>
<a name="top"></a>
<table cellpadding="0" cellspacing="0" width="100%" bgcolor="#808080">
<tr>
<td width="234" valign="top">
<a href="../default.htm"><img src="../images/w3default80.jpg" border="0" alt="W3Schools" /></a>
</td>
<th valign="middle" align="left" class="right">
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*txtimg*/
google_ad_slot = "5330033957";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript" src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<noscript>
<a href="../default.asp" target="_blank"><img src="../banners/w6.gif" border="0" alt="W3Schools" /></a>
</noscript>
<br /></th>
</tr>
</table>
<table style="margin-left:1px" width="800px" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="137" class="content" valign="top"><br />
<a class="left" href="../default.asp" target="_top">
<img src="../images/homeicon.gif" border="0" alt="home" /></a>
<a class="left" href="../default.asp" target="_top">
<b>HOME</b></a>
<br /><br />
<b>ADO Tutorial</b><br />
<a class="left" target="_top" href="default.asp" >ADO HOME</a><br />
<a class="left" target="_top" href="ado_intro.asp" >ADO Intro</a><br />
<a class="left" target="_top" href="ado_connect.asp" >ADO Connect</a><br />
<a class="left" target="_top" href="ado_recordset.asp" >ADO Recordset</a><br />
<a class="left" target="_top" href="ado_display.asp" >ADO Display</a><br />
<a class="left" target="_top" href="ado_query.asp" >ADO Query</a><br />
<a class="left" target="_top" href="ado_sort.asp" >ADO Sort</a><br />
<a class="left" target="_top" href="ado_add.asp" >ADO Add</a><br />
<a class="left" target="_top" href="ado_update.asp" >ADO Update</a><br />
<a class="left" target="_top" href="ado_delete.asp" >ADO Delete</a><br />
<a class="left" target="_top" href="ado_demo.asp" >ADO Demo</a><br />
<a class="left" target="_top" href="ado_getstring.asp" >ADO Speed Up</a><br />
<br />
<b>ADO Objects</b><br />
<a class="left" target="_top" href="ado_ref_command.asp" >ADO Command</a><br />
<a class="left" target="_top" href="ado_ref_connection.asp" >ADO Connection</a><br />
<a class="left" target="_top" href="ado_ref_error.asp" >ADO Error</a><br />
<a class="left" target="_top" href="ado_ref_field.asp" >ADO Field</a><br />
<a class="left" target="_top" href="ado_ref_parameter.asp" >ADO Parameter</a><br />
<a class="left" target="_top" href="ado_ref_property.asp" >ADO Property</a><br />
<a class="left" target="_top" href="ado_ref_record.asp" >ADO Record</a><br />
<a class="left" target="_top" href="ado_ref_recordset.asp" >ADO Recordset</a><br />
<a class="left" target="_top" href="ado_ref_stream.asp" >ADO Stream</a><br />
<a class="left" target="_top" href="ado_datatypes.asp" >ADO DataTypes</a><br />
<br />
<a class="left" target="_top" href="ado_summary.asp" >ADO Summary</a><br />
<br />
<b>Examples</b><br />
<a class="left" target="_top" href="ado_examples.asp" >ADO Examples</a><br />
<br />
<b>Exam</b><br />
<a class="left" target="_top" href="../cert/default.asp" >ADO Exam</a><br />
<br />
<b>Selected Reading</b><br />
<a class="left" target="_top" href="../browsers/browsers_stats.asp">Web Statistics</a><br />
<a class="left" target="_top" href="../site/site_glossary.asp">Web Glossary</a><br />
<a class="left" target="_top" href="../hosting/default.asp">Web Hosting</a><br />
<a class="left" target="_top" href="../quality/default.asp">Web Quality</a><br /><br />
<a class="left" target="_top" href="../forum/default.asp">W3Schools Forum</a><br /><br />
<a class="left" target="_top" href="../about/about_helping.asp">Helping W3Schools</a><br /><br />
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*LeftLinkUnit*/
google_ad_slot = "4854527104";
google_ad_width = 120;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td>
<td valign="top">
<table style="border: 1px solid gray" width="100%" bgcolor="#FFFFFF" border="0" cellpadding="5" cellspacing="0">
<tr>
<td>
<h1>ADO Number Property</h1>
<hr />
<a href="ado_ref_error.asp"><img class="navup" src="../images/up.gif" alt="Error Object Reference" border="0" /> Complete Error Object Reference</a>
<hr />
<p>The Number property returns a long value that is a unique number that can
take one of the <a href="#errorvalueenum"> ErrorValueEnum</a> values. The number describes the error generated
by ADO. If the error was generated by the provider, this property may be set to an unspecific error
value.
</p>
<p>The numbers are equivalent to the Windows API HRESULTS values.
</p>
<h3>Syntax</h3>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr>
<td valign="top">
<pre>lngErrorNumber=objErr.Number</pre>
</td>
</tr>
</table>
<h3>Example</h3>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr>
<td valign="top">
<pre><%
for each objErr in objConn.Errors
response.write("<p>")
response.write("Description: ")
response.write(objErr.Description & "<br />")
response.write("Help context: ")
response.write(objErr.HelpContext & "<br />")
response.write("Help file: ")
response.write(objErr.HelpFile & "<br />")
response.write("Native error: ")
response.write(objErr.NativeError & "<br />")
response.write("Error number: ")
response.write(objErr.Number & "<br />")
response.write("Error source: ")
response.write(objErr.Source & "<br />")
response.write("SQL state: ")
response.write(objErr.SQLState & "<br />")
response.write("</p>")
next
%></pre>
</td>
</tr>
</table>
<br />
<hr />
<a name="errorvalueenum"><h3>ErrorValueEnum Values</h3></a>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr>
<th valign="top" align="left">Constant</th>
<th valign="top" align="left">Value</th>
<th valign="top" align="left">Description</th>
</tr>
<tr>
<td valign="top">adErrBoundToCommand</td>
<td valign="top">3707<br />
-2146824581<br />
0x800A0E7B</td>
<td valign="top">Cannot change the ActiveConnection property of a Recordset
object which has a Command object as its source</td>
</tr>
<tr>
<td valign="top">adErrCannotComplete</td>
<td valign="top">3732<br />
-2146824556<br />
0x800A0E94</td>
<td valign="top">Server cannot complete the operation</td>
</tr>
<tr>
<td valign="top">adErrCantChangeConnection</td>
<td valign="top">3748<br />
-2146824540<br />
0x800A0EA4</td>
<td valign="top">Connection was denied</td>
</tr>
<tr>
<td valign="top">adErrCantChangeProvider</td>
<td valign="top">3220<br />
-2146825068<br />
0X800A0C94</td>
<td valign="top">Supplied provider is different from the one already in
use</td>
</tr>
<tr>
<td valign="top">adErrCantConvertvalue</td>
<td valign="top">3724<br />
-2146824564<br />
0x800A0E8C</td>
<td valign="top">Data value cannot be converted</td>
</tr>
<tr>
<td valign="top">adErrCantCreate</td>
<td valign="top">3725<br />
-2146824563<br />
0x800A0E8D</td>
<td valign="top">Data value cannot be set or retrieved</td>
</tr>
<tr>
<td valign="top">adErrCatalogNotSet</td>
<td valign="top">3747<br />
-2146824541<br />
0x800A0EA3</td>
<td valign="top">Operation requires a valid ParentCatalog</td>
</tr>
<tr>
<td valign="top">adErrColumnNotOnThisRow</td>
<td valign="top">3726<br />
-2146824562<br />
0x800A0E8E</td>
<td valign="top">Record does not contain this field</td>
</tr>
<tr>
<td valign="top">adErrDataConversion</td>
<td valign="top">3421<br />
-2146824867<br />
0x800A0D5D</td>
<td valign="top">Application uses a value of the wrong type</td>
</tr>
<tr>
<td valign="top">adErrDataOverflow</td>
<td valign="top">3721<br />
-2146824567<br />
0x800A0E89</td>
<td valign="top">Data value is too large</td>
</tr>
<tr>
<td valign="top">adErrDelResOutOfScope</td>
<td valign="top">3738<br />
-2146824550<br />
0x800A0E9A</td>
<td valign="top">URL of the object to be deleted is outside the scope of
the current record</td>
</tr>
<tr>
<td valign="top">adErrDenyNotSupported</td>
<td valign="top">3750<br />
-2146824538<br />
0x800A0EA6</td>
<td valign="top">Provider does not support sharing restrictions</td>
</tr>
<tr>
<td valign="top">adErrDenyTypeNotSupported</td>
<td valign="top">3751<br />
-2146824537<br />
0x800A0EA7</td>
<td valign="top">Provider does not support the kind of sharing
restriction</td>
</tr>
<tr>
<td valign="top">adErrFeatureNotAvailable</td>
<td valign="top">3251<br />
-2146825037<br />
0x800A0CB3</td>
<td valign="top">Object/Provider is not capable of performing
requested operation</td>
</tr>
<tr>
<td valign="top">adErrFieldsUpdateFailed</td>
<td valign="top">3749<br />
-2146824539<br />
0x800A0EA5</td>
<td valign="top">Fields update failed</td>
</tr>
<tr>
<td valign="top">adErrIllegalOperation</td>
<td valign="top">3219<br />
-2146825069<br />
0x800A0C93</td>
<td valign="top">Operation is not allowed in this context</td>
</tr>
<tr>
<td valign="top">adErrIntegrityViolation</td>
<td valign="top">3719<br />
-2146824569<br />
0x800A0E87</td>
<td valign="top">Data value conflicts with the integrity constraints of
the field</td>
</tr>
<tr>
<td valign="top">adErrInTransaction</td>
<td valign="top">3246<br />
-2146825042<br />
0x800A0CAE</td>
<td valign="top">Connection object cannot be closed
while in a transaction</td>
</tr>
<tr>
<td valign="top">adErrInvalidArgument</td>
<td valign="top">3001<br />
-2146825287<br />
0x800A0BB9</td>
<td valign="top">Arguments are of the wrong type, are out of acceptable
range, or are in conflict with one another</td>
</tr>
<tr>
<td valign="top">adErrInvalidConnection</td>
<td valign="top">3709<br />
-2146824579<br />
0x800A0E7D</td>
<td valign="top">The connection cannot be used to perform this operation.
It is either closed or invalid in this context</td>
</tr>
<tr>
<td valign="top">adErrInvalidParamInfo</td>
<td valign="top">3708<br />
-2146824580<br />
0x800A0E7C</td>
<td valign="top">Parameter object is improperly defined</td>
</tr>
<tr>
<td valign="top">adErrInvalidTransaction</td>
<td valign="top">3714<br />
-2146824574<br />
0x800A0E82</td>
<td valign="top">Coordinating transaction is invalid</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -