Error collection reference documentation in ASP development applications

Error collection Reference document in ASP Tutorial development application
Error type:
Adodb.field (0X800A0BCD)
One of the BOF or EOF is "true", or the current record has been deleted, and the required operation requires a current record.
Reason: When you use SQL to find a database tutorial record, the lookup result is empty, and you do not have an empty record of the situation to deal with.
Resolution: 1 If you don't believe that the search result is empty, then you should consider whether your SQL statement is correct, 2 if it is, then you should add a statement such as "if Rs.eof then" or "do as not rs.eof" to handle the EOF situation.

Error type:
(0x80020009)
An accident occurred.
Cause: It's also when you use SQL to look up database records, the lookup results are empty, and you call the RS ("AA") records in the following code
Solution: either ibid, plus rs.eof judgment and processing, or your SQL statement is incorrect, resulting in records can not be found out, you will not be able to use RS ("AA") in the later records.

Error type:
Active Server Pages, ASP 0126 (0x80004005)
The Include file ' xxx.asp ' could not be found.
Cause: As the error hint says, there is no such inclusion.
Solution: If you are sure that you have this file, then your path is wrong, for example, in fact, his path relative to the site root directory should be inc/xxx.asp, then include inside should write inc/xxx.asp, not just xxx.asp. Attached: include:

Error type:
Microsoft OLE DB Provider for ODBC drivers (0x80004005)
[Microsoft] The [ODBC Microsoft Access Driver] operation must use an updatable query.
Cause: This is very common on XP servers, it is a server configuration issue, or a user's permissions issue.
WORKAROUND: If the error occurs only on this computer, right-click the folder where the site is located, click on "Sharing and security ..." to add ... in the "safe" midpoint ..., write everyone, and then make the user's permissions for all, that is, except the first all tick, OK and then refresh can be used. (Note: If the "security" option is not found, click "Tools" under Any folder, then "Folder Options"--"view", and remove the tick in the "Use Simple File sharing" column)

Error type:
Microsoft VBScript compiler error (0x800a0401)
Statement not ended
Reason: syntax error.
Resolve: Check by the line prompted by the system. If the prompt is exactly the last line on this page, it is most likely that the IF statement forgets to write "End If", and the SELECT statement forgets to write the "ending select", which, in short, ends where it is needed, causing the server to fail to find a statement and to display the error on the last line

Error type:
Microsoft Jet database engine (0X80040E10)
At least one parameter is not assigned a value.
Reason: When writing SQL statements, we often invoke some arguments, and it is possible that one of these parameters is not assigned a value.
Resolution: Check the value of each parameter is really passed over, it is likely that some parameters are actually "", such parameters to index the database is certainly not.

Error type:
Microsoft Jet database engine (0X80040E37)
The Microsoft Jet database engine could not find the input table or query ' AA '. Determine if it exists and the spelling of its name is correct.
Reason: This table is not present.
Solve: Should you write the wrong table name, or even the wrong database? Check it out again!

Error type:
Microsoft VBScript run-time error (0x800a000d)
Type mismatch: ' [string: '] '
Reason: Because your variable is of a string type and you use it as a number or other type.
To solve: For example, you need a number of variables to calculate i=i+1 and other mathematical operations, then you should use CInt (variable name) on the variable, cast to the digital type, two variables must be compared between the same type, so also need to convert, the method ditto.

Error type:
Microsoft Jet database engine (0X80040E07)
The data type does not match in the standard expression.
Reason: It is also common to write SQL statements when the error occurred, that is, the number and string variables confused.
Solve: It is good to do, try to put the SQL variable added "to remove the single quotation mark, or the original thought is a number plus", and then see the effect.

Error type:
Microsoft VBScript Run is an error (0X800A01A8)
Missing object: "
Reason: It is possible that you did not define the RS object.
FIX: Don't forget to write set Rs=server.createobject ("Adodb.recordset") so that you can define objects, or use Conn.execute ("SQL") directly without this notation, You don't have to worry about object issues.

Error type:
Microsoft VBScript run-time error (0X800A005E)
Invalid use null: ' Replace '
Reason: Invalid use of the function of the situation is also more see, including split and so on, the truth is relatively simple, because you replace the content is empty.
Solution: It is best to add an if check if you want to replace the content is empty.

Microsoft VBScript compiler error error ' 800a03f6′
The required properties are not supported by the ODBC driver.
Reason: Probably because there is no field name appearing in the SQL statement, typically a field name or SQL keyword writing error. It is also possible that the table being opened by SQL has been opened exclusively.
Workaround: Check each field name that appears in the SQL statement, and each keyword
Microsoft OLE DB Provider for ODBC Drivers error ' 80004005′
The user ' admin ' on the machine ' hdzc-3jqskbwo02′ the exclusive way to lock the datasheet ' Order_Detail '.
Reason: SQL required tables are open in table design form by Access
Workaround: Turn off table design
Microsoft VBScript compiler error error ' 800a03f6′
The item is not found in the collection that corresponds to the desired name or ordinal.
Reason: No field name appears in SQL statement, typically a field name or SQL keyword writing error
Workaround: Check for each field name that appears in the SQL statement
Adodb.recordset error ' 800a0e78′
Operation is not allowed when the object is closed.
Reason: The RS object was closed with Rs.close before rs.open the sql,conn,3,3 statement
Solution: Remove the previous rs.close

Microsoft OLE DB Provider for ODBC Drivers error ' 80040e14′
[Microsoft] [ODBC Microsoft Access Driver] Syntax error (missing operator) is in query expression ' OID form classtree where oid = 25′.
Reason: There is an English keyword or paragraph error in the SQL statement that is being written illegally
WORKAROUND: Type the SQL statement, and then check the words to find out the wrong writing.
Operation requires an updatable query
A: Look at the library file is not read-only.
Answer 2: The recordset (RS) ordered by is not allowed to have an update operation (rs.update)

3219 operation is not allowed in this content
Answer 3: Database field properties are set to allow null values to be inserted.
Aderrinvalidargument 3001
0x800A0BB9
The parameter used by the application is of a wrong type, is out of an acceptable range, or conflicts with other parameters.

Aderrnocurrentrecord 3021
0x800a0bcd
BOF or EOF is true, or the current record has been deleted. The operation requested by the application requires the current record.

Aderrillegaloperation 3219
0x800a0c93
The operation requested by the application is not allowed to appear in this context

Aderrintransaction 3246
0x800a0cae
An application cannot explicitly close the connection object in a transaction.

Aderrfeaturenotavailable 3251
0x800a0cb3
The operation requested by the application is not supported by the provider.

adErrItemNotFound 3265
0x800a0cc1
ADO cannot find an object in the collection that corresponds to the name or order reference of the application request.

Aderrobjectincollection 3367
0x800a0d27
Cannot append, the object is already in the collection.

Aderrobjectnotset 3420 0x800a0d5c An object referenced by an application no longer points to a valid object.

Aderrdataconversion 3421
0x800a0d5d
The application used a value type that does not conform to the current operation.

Aderrobjectclosed 3704
0x800a0e78
If the object is closed, the operation requested by the application is not allowed.

Aderrobjectopen 3705
0x800a0e79
If the object is open, the operation requested by the application is not allowed.

Aderrprovidernotfound 3706
0x800a0e7a
ADO could not find the specified provider.

Aderrboundtocommand 3707
0x800a0e7b
The application cannot use the command object to change the Recordset object's ActiveConnection property to its source data.

Aderrinvalidparaminfo 3708
0x800a0e7c
The application incorrectly defines the parameter object.

Aderrinvalidconnection 3709
0x800a0e7d
An application requests an action on an object by referencing a closed or invalid connection object.
One of the Adodb.field errors ' 80020009′bof or EOF is true, or the current record has been deleted, and the required operation requires a current record.
Resolved as follows: This error is caused by the absence of a select, delete record, or the absence of a record in the library, so check the SQL statement, select, delete condition is correct, and before delete the best select a record or with On error Resume Next.......on Error Goto 0来 processing. If it is because there is no record in the library, just add a judge if objrecordset.eof and Objrecordset.bof then is OK, because the pointer defaults to the top of the recordset when it is opened, so you can use only if Objrecordset.eof then to judge

activeserverpages,asp0126 (0x80004005) –> cannot find the included file

Microsoftoledbproviderforodbcdrivers (0X80040E21) –>sql statement error (data type mismatch or table name (field name) error or table is in edit state, or table does not exist in Conn Open database)
Microsoftoledbproviderforodbcdrivers (0X80040E14) –>sql statement error (field name error, or data type mismatch)
Microsoftoledbproviderforodbcdrivers (0X80040E07) –>sql statement error (The type of field to insert or update does not match the variable data type)
Microsoftoledbproviderforodbcdrivers (0X80040E57) –>sql statement error (data overflow to insert or update)
Microsoftoledbproviderforodbcdrivers (0X80040E10) –>sql statement error (update field name or data type error to update)
Microsoftoledbproviderforodbcdrivers (0x80004005) –>sql statement error (the value of the field to be inserted or updated cannot be null)
Microsoftoledbproviderforodbcdrivers (0x80004005) –> Open Database error, no database found in specified directory
Microsoftoledbproviderforodbcdrivers (0x80040e37) –> no table found

Microsoftvbscript run-time Error (0x800a000d) –> Error Reference RS variable (rs to image closed or undefined)
Microsoftvbscript run-time Error (0X800A01C2) –>vbscript script error (VBScript statement error)
Microsoftvbscript run-time Error (0x800a0006) –>vbscript script error (overflow error)
Microsoftvbscript Compiler Error (0x800a040e) –> missing loop
Microsoftvbscript Compiler Error (0X800A03EA) –> missing if or endif
Microsoftvbscript Compiler Error (0X800A03EE) –> statement not ended (missing ")")
Microsoftvbscript Compiler Error (0X800A03F6) –>if statement error (missing endif)
Microsoftvbscript run-time Error (0x800a005b) –> missing set
Microsoftvbscript run-time Error (0x800a0005) –> variable undefined
Microsoftvbscript Compiler Error (0X800A03F9) –>if statement missing Then
Microsoftvbscript Compiler Error (0x800a0411) –>dim statement definition Error
Adodb.recordset (0X800A0BB9) –>sql statement error (An error occurred when an SQL statement or Conn statement was undefined or assigned to an RS property)
Adodb.recordset (0X800A0CC1) –>rs error (Rs to image does not exist or incorrectly references a nonexistent field name)
Adodb.recordset (0X800A0BCD) –>rs errors (No records in the recordset operate on the Recordset)
Adodb.recordset (0x800a0e78) –>rs to image error (Recordset does not exist, Rs.Open statement is missing)
Adodb.recordset (0X800A0CC1) –>rs error (reference to a nonexistent field name)
Adodb.recordset (0x800a0e7d) –>conn definition Error
Adodb.recordset (0X800A0CB3) –> database opened read-only, unable to update data

1. Compilation Error:
This error is generally a grammatical problem of the code. The resignation ASP is stopped because of a compile error.
2. Run Error:
This error occurs when you are ready to run the ASP. For example, if you try to assign a value to a variable, it exceeds the allowable range for that variable.
3. Logical error:
Logic errors are the hardest to find, and they are often a structural error that computers cannot find. This requires us to thoroughly examine our code.