ASP Common Errors and solution summary recommendation page 1/2

There are three main error types:
1. Compilation error:
This error is generally caused by the syntax of the Code. The ASP program stops running due to a compilation error.
2. Running error:
This error occurs when you are preparing to run ASP. For example, if you try to assign a value to a variable, but it is beyond the permitted range of the variable.
3. Logic error:
Logical errors are the most difficult to find. Such errors are often structured errors that cannot be found by computers. This requires us to thoroughly check our code.
Because compilation errors are generally displayed along with logical errors, we only worry about running errors. It terminates ASP operations and leaves a pile of unfriendly text to users. So how do we handle running errors?

Error Type:
ADODB. Field (0x800A0BCD)
Either BOF or EOF is "true", or the current record has been deleted. The operation required requires a current record.
Cause: When you use SQL to search for database records, the query result is blank, and you have not processed null records.
Solution: 1. if you do not believe that the search result is null, you should consider whether your SQL statement is correct. 2. if you are free, add "if rs. eof then "or" do while not rs. the eof statement.

Error Type:
(0 × 80020009)
An accident occurred.
Cause: When you use SQL to search for database records, the search result is blank and records such as rs ("aa") are called in the code below.
Solution: either the same as above, with rs. the eof judgment and processing either means that your SQL statement is incorrect, and the records cannot be found, so you cannot use rs ("aa") records later.

Error Type:
Active Server Pages, ASP 0126 (0 × 80004005)
The file 'xxx. asp 'cannot be found '.
Cause: As the error message says, this inclusion file does not exist.
Solution: If you are sure that this file exists, your path is wrong. For example, the path relative to the root directory of the website should be inc/xxx. asp, then include should write inc/xxx. asp, not just xxx. asp. Appendix: The include statement is as follows:

Error Type:
Microsoft ole db Provider for ODBC Drivers (0 × 80004005)
The [Microsoft] [ODBC Microsoft Access Driver] operation must use an updatable query.
Cause: This is very common on XP servers. It is a server configuration problem, or a user's permission problem.
Solution: If only debugging errors occur on the local machine, right-click the folder where the website is located and click "share and security ...", Add... in "security ..., Write to everyone, and then set the user's permissions to all, that is, check all except the first one, and then refresh it. (Note: If the "Security" option is not found, click "Tools" in any folder, and then "Folder Options" -- "View ", in the "use simple file sharing" column, remove the check box)

Error Type:
Microsoft VBScript compiler error (0x800A0401)
Statement not ended
Cause: syntax error.
Solution: check according to the row prompted by the system. If the prompt is exactly the last line on this page, it is likely that the if statement forgot to write "end if" and the select statement forgot to write "end select, in short, there is no end in the place where the end is required. As a result, the server cannot find the end of the statement, so it has to display an error in the last line.

Error Type:
Microsoft JET Database Engine (0x80040E10)
At least one parameter is not specified.
Cause: When writing SQL statements, we often call some parameters. It is very likely that one of these parameters is not assigned a value.
Solution: Check whether the values of each parameter are actually passed. Some parameters may actually be "". Of course, such parameters cannot be used to index the database.

Error Type:
Microsoft JET Database Engine (0x80040E37)
The Microsoft Jet Database Engine cannot find the input table or query 'A '. Check whether it exists and whether its name is correctly spelled.
Cause: The table does not exist.
Solution: Should you have written the wrong table name or connected to the wrong database? Check it carefully!

Error Type:
Microsoft VBScript runtime error (0x800A000D)
Type Mismatch: \ '[string: ""] \"
Cause: it is because your variable type is string type, but you use it as a number or another type.
Solution: for example, if you need numeric variables to calculate I = I + 1 and other mathematical operations, you should use the cint (variable name) on the variable to forcibly convert it to the numeric type, the comparison between two variables must be of the same type, so conversion is also required. The method is the same as above.

Error Type:
Microsoft JET Database Engine (0x80040E07)
The data type in the standard expression does not match.
Cause: Generally, an error occurs when writing an SQL statement, that is, obfuscation of numeric and string variables.
Solution: It's easy to do. Just try to remove the single quotation marks of the SQL variables, or add the ones that were originally regarded as numbers, and then check the effect.

Error Type:
Microsoft VBScript is running incorrectly (0x800A01A8)
Missing Object :"
Cause: it is very likely that you have not defined the rs object.
Solution: do not forget to write set rs1_server.createobject(“adodb.recordset ). this example can define the method of Directly Writing the object using conn.exe cute ("SQL"), which is much easier and does not need to consider object issues.

Error Type:
Microsoft VBScript runtime error (0x800A005E)
Invalid Null: 'replace'
Cause: Invalid function usage is also common, including Split. This is also simple because your Replace content is empty.
Solution: add an IF statement to check whether the content of your replace is empty.

Microsoft VBScript compiler error: '800a03f6 ′
ODBC drivers do not support the required attributes.
Cause: it may be because there is no field name in the SQL statement, which is generally a field name or an SQL keyword writing error. It is also possible that the table to be opened by SQL has been exclusively opened.
Solution: Check each field name and keyword in the SQL statement.
Microsoft ole db Provider for ODBC Drivers error '000000 ′
The user 'admin' on 'hdzc-3jqskbwo02' locks the data table 'order _ detail' exclusively '.
Reason: The tables required by SQL are accessed in the form of table design.
Solution: Disable table design.
Microsoft VBScript compiler error: '800a03f6 ′
The project cannot be found in the set of names or ordinal numbers.
Cause: the field name does not appear in the SQL statement. It is generally a field name or an SQL keyword writing error.
Solution: Check the names of each field in the SQL statement.
ADODB. Recordset error '800a0e78 ′
When the object is closed, the operation is not allowed.
Cause: rs. close is used to close the rs object before the rs. open SQL, conn, 3, and 3 statements.
Solution: remove the previous rs. close

Microsoft ole db Provider for ODBC Drivers error '80040e14 ′
[Microsoft] [ODBC Microsoft Access Driver] syntax error (operator loss) in the query expression 'oid form classtree where oid = 25.
Cause: An error occurred while writing an invalid keyword or sub-segment in an SQL statement.
Solution: extract the SQL statement and compare words one by one to find out the publishing errors.
Operation requires an updatable Query
A: Check whether the database file is read-only.
Answer 2: order by records (rs) do not allow update operations (rs. update)

3219 the operation is not allowed in this content
Answer 3: whether the database Field attribute is set to allow null insertion.
AdErrInvalidArgument 3001
0x800A0BB9
The type of the parameter used by the application is incorrect, exceeds the 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 cannot appear in this context

AdErrInTransaction 3246
0x800A0CAE
In a transaction, the application cannot explicitly close the Connection object.

AdErrFeatureNotAvailable 3251
0x800A0CB3
The provider does not support the operations requested by the application.

AdErrItemNotFound 3265
0x800a0cc0.
ADO cannot find the object in the collection corresponding to the name or sequential reference of the application request.

AdErrObjectInCollection 3367
0x800A0D27
Append is not allowed. The object is already in the collection.

The objects referenced by the adErrObjectNotSet 3420 0x800A0D5C application no longer point to valid objects.

AdErrDataConversion 3421
0x800A0D5D
The application uses a value type that does not match the current operation.

AdErrObjectClosed 3704
0x800A0E78
If the object is disabled, the operation requested by the application is not allowed.

AdErrObjectOpen 3705
0x800A0E79
If the object is opened, the operation requested by the application is not allowed.

AdErrProviderNotFound 3706
0x800A0E7A
ADO cannot find the specified provider.

AdErrBoundToCommand 3707
0x800A0E7B
The application cannot use the Command object to change the ActiveConnection attribute of the Recordset object to its source data.

Adderrinvalidparaminfo 3708
0x800A0E7C
The application incorrectly defines the Parameter object.

AdErrInvalidConnection 3709
0x800A0E7D
The application requests operations on the object by referencing the closed or invalid Connection object.
In the ADODB. Field error '000000' BOF or EOF, one of them is "true", or the current record has been deleted. The operation required requires one current record.
The solution is as follows: this error is caused by the absence of SELECT and DELETE records or the absence of records in the database. Therefore, check whether the SELECT and DELETE conditions of SQL statements are correct, we recommend that you SELECT a record before the DELETE operation or use On Error Resume Next ....... On Error Goto 0. If there is no record in the database, you only need to add a judgment If objRecordSet. eof And objRecordSet. bof Then is enough, because when the RecordSet is enabled, the pointer is at the top by default, so only If objRecordSet can be used. eof Then to judge

ActiveServerPages, ASP0126 (0 × 80004005)-> the inclusion file cannot be found.

MicrosoftOLEDBProviderforODBCDrivers (0x80040E21)-> SQL statement error (Data Type mismatch, table name (field name) error, table being edited, or table not in database opened by conn)
MicrosoftOLEDBProviderforODBCDrivers (0x80040E14)-> SQL statement error (incorrect field name or Data Type mismatch)
MicrosoftOLEDBProviderforODBCDrivers (0x80040E07)-> SQL statement error (the type of the field to be inserted or updated does not match the data type of the variable)
MicrosoftOLEDBProviderforODBCDrivers (0x80040E57)-> SQL statement error (Data overflow to be inserted or updated)
MicrosoftOLEDBProviderforODBCDrivers (0x80040E10)-> SQL statement error (incorrect update field name or data type to be updated)
MicrosoftOLEDBProviderforODBCDrivers (0 × 80004005)-> SQL statement error (the value of the field to be inserted or updated cannot be null)
MicrosoftOLEDBProviderforODBCDrivers (0 × 80004005)-> An error occurred while opening the database. The database was not found in the specified directory.
MicrosoftOLEDBProviderforODBCDrivers (0x80040E37)-> no table found

MicrosoftVBscript runtime error (0x800A000D)-> reference rs variable error (rs object is disabled or undefined)
MicrosoftVBscript runtime error (0x800A01C2)-> vbscript error (vbscript statement error)
MicrosoftVBscript runtime error (0x800A0006)-> vbscript error (overflow error)
MicrosoftVBscript compiler error (0x800A040E)-> loop missing
MicrosoftVBscript compiler error (0x800A03EA)-> if or endif missing
MicrosoftVBscript compiler error (0x800A03EE)-> the statement is not over (missing ")")
MicrosoftVBscript compiler error (0x800A03F6)-> if statement error (endif missing)
MicrosoftVBscript runtime error (0x800A005B)-> set missing
MicrosoftVBscript runtime 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 is undefined or an rs attribute is assigned a value)
ADODB. Recordset (0x800a0cc0)-> rs object error (rs object does not exist or a nonexistent field name is incorrectly referenced)
ADODB. Recordset (0x800A0BCD)-> rs image error (no record in the record set but operation on the record set)
ADODB. Recordset (0x800A0E78)-> rs object error (record set does not exist and the rs. open statement is missing)
ADODB. Recordset (0x800a0cc0)-> rs object error (a nonexistent field name is referenced)
ADODB. Recordset (0x800A0E7D)-> conn definition Error
ADODB. Recordset (0x800A0CB3)-> the database is opened in read-only mode and data cannot be updated.