ASP (required) [FAQ set]

When you are working on asp programs, you will often encounter some error prompts and often struggle to find the cause. Therefore, I suggest you collect common error prompts and solutions, let yourself and new users make reference.
I hope that you can paste your solution and error prompt to the Forum to benefit the masses and save the fire.

Let me go first. If there is an error, please correct it.
========================================================== ==============
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 '20140901'
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.
--------------------------------
ADODB. Field error '000000' Either BOF or EOF is "true", or the current record has been deleted. The operation required requires a 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 the 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

IIS5 HTTP500 internal error Solution
I. error message
IIS5's HTTP 500 internal server error is one of the common errors we encounter, and its main error performance
That is, the ASP program cannot be browsed, but the HTM static webpage is not affected. In addition, when an error occurs, the system event day
Logs and Security Event Logs are recorded accordingly.

The details are as follows:
(1) Performance in IE
The following error occurs when you browse asp pages that previously run normally:

Webpage cannot be displayed
The webpage you want to access has problems, so it cannot be displayed.
Please try the following operations:
Open the 127.0.0.1 homepage to find a link to the desired information.
Click Refresh or try again later.
HTTP 500-Internal Server Error
Internet Information Service
Technical Information (Personal Support)
Details:
Microsoft support

Or:
Server Application Error
The server has encountered an error while loading an application durin
G the processing of your request. Please refer to the event log for mo
Re detail information. Please contact the server administrator for ass
Istance.

(2) security log records (2)
Event Type: Failed Review
Event Source: Security
Event Type: logon/logout
Event ID: 529
Date: 2001-9-9
Event: 11:17:07
User: nt authority \ SYSTEM
COMPUTER: MYSERVER
Description:
Logon Failed:
Cause: Unknown user name or incorrect password
Username: IWAM_MYSERVER
Domain: MYDOM
Logon type: 4
Logon Process: Advapi
Authentication package: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0
Work Station Name: MYSERVER

Event Type: Failed Review
Event Source: Security
Event Type: Account Logon
Event ID: 681
Date: 2001-9-9
Event: 11:17:07
User: nt authority \ SYSTEM
COMPUTER: MYSERVER
Description:
Log on to the account: IWAM_MYSERVER
Login User: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0
Slave Workstation: MYSERVER
Failed. Error code: 3221225578

(3) records in system logs (2)
Event Type: Error
Event Source: DCOM
Event Type: None
Event ID: 10004
Date: 2001-9-9
Event: 11:20:26
User: N/
COMPUTER: MYSERVER
Description:
"The password cannot be updated. The value provided to the new password contains the value that is not allowed in the password. "
And cannot log on to. \ IWAM_MYSERVER to run the server:
{3D14228D-FBE1-11D0-995D-00C04FD919C1}

Event Type: Warning
Event Source: W3SVC
Event Type: None
Event ID: 36
Date: 2001-9-9
Event: 11:20:26
User: N/
COMPUTER: MYSERVER
Description:
The server failed to transfer to the application '/LM/W3SVC/4/root '. The error is that the 'runas' format must be <
Domain Name> \ <User Name> or only <User Name> '.
For more information about this message, visit the Microsoft online support site:
Www.microsoft.com/contentredirect.asp.

Ii. Cause Analysis
According to the above error analysis, we can see that the main reason is that the IWAM account
Is IWAM_MYSERVER account) Password error caused by HTTP 500 internal error.
Before analyzing the cause of an internal error in HTTP500, perform a brief analysis on the IWAM account.
Introduction:

The IWAM account is a built-in account automatically created by the system when IIS5 is installed. It is mainly used outside the process startup.
The Internet information service of the application. The IWAM account name is based on the NETBIOS name of each computer.
The generic format is IWAM_MACHINE, that is, the prefix of "IWAM" and the connection line
"_" And the NETBIOS Name of the computer. My computer's NETBIOS name is MYSERVER,
Therefore, the IWAM account name on my computer is IWAM_MYSERVER.
The ISUR_MACHINE naming method is very similar.

After the IWAM account is created, it is used by three Parties: Active Directory, IIS metabase database, and COM + application.
For mutual use, the account and password are respectively saved by the three parties, and the operating system is responsible for the IWAM passwords stored by the three parties.
. Generally speaking, we can rest assured that we do not have to worry about mistakes,
However, I do not know whether it is a BUG or why. Sometimes, the system fails to synchronize the password of the IWAM account,
The password used by the third-party IWAM account is inconsistent. When IIS or COM + applications use the wrong IWAM password to log on
System, when starting IIS Out-Of-Process Pooled Applications, the system will be caused by a Password error
This request is rejected, causing startup failure Of IIS Out-Of-Process Pooled Applications.
The error message "cannot run server {3D14228D-FBE1-11D0-995" is displayed in the ID10004 error event.
D-00C04FD919C1} "(here {3D14228D-FBE1-11D0-995D-00C04FD919C1} is IIS O
Ut-Of-Process Pooled application KEY), cannot be transferred to IIS5 application, HTTP 5
00 internal error occurs.

Iii. Solution
Knowing the cause of an internal error in HTTP 500 is easy to solve, that is, manual synchronization.
The password of the IWAM account in the Active Directory, IIS metabase database, and COM + applications.

You must log on to the computer as an administrator to provide sufficient operation permissions (IWAM account ).
Take IWAM_MYSERVER as an example ).

(1) change the password of the IWAM_MYSERVER account in Active Directory
Because the password of the IWAM account is controlled by the system and generated randomly, we don't know what it is. To complete the following two steps
For Password synchronization, we must set the password of the IWAM account to a value we know.

1. Choose Start> program> Administrative Tools> Active Directory users and computers ",
Start the "Active Directory users and computers" Management Unit.

2. Click "user", select "IWAM_MYSERVER" on the right, right-click and select "Reset Password (T )...",
In the Reset Password dialog box that appears, set a new password for IWAM_MYSERVER.
"Aboutnt2001" (without quotation marks). OK. Wait until the password is modified successfully.

(2) synchronize the password of IWAM_MYSERVER account in IIS metabase
This change may be too sensitive and important. Microsoft has not modified IWAM_M in IIS metabase for us.
The YSERVER account and password provide an explicit user interface, which only provides a management script adsut with IIS5
Il. vbs. The script is located in the C: \ inetpub \ adminscripts subdirectory (the location may be caused by your installation
IIS5 is set differently ).

The adsutil. vbs script has powerful functions, many parameters, and complex usage. Here, only this script is provided for repair.
How to change the password of IWAM_MYSERVER:

Adsutil SET w3svc/WAMUserPass Password

The "Password" parameter is the new Password of the IWAM account to be set. Therefore, in IIS metabase
The command for changing the password of IWAM_MYSERVER to "Aboutnt2001" is:

C: \ Inetpub \ AdminScripts> adsutil SET w3svc/WAMUserPass "Aboutnt2001"

After the modification is successful, the system prompts the following:
WAMUserPass: (String) "Aboutnt2001"

(3) password of IWAM_MYSERVER used to synchronize COM + applications
The password of IWAM_MYSERVER used to synchronize COM + applications. You can select either of the following methods:
Is to use the component service MMC Management Unit, and the other is to use the IWAM account synchronization script synciwam. vbs.
1. Use the component service MMC Management Unit
(1) Start the Component Service Management Unit: Choose Start> RUN> MMC to start the management control.
Console, open the "Add/delete Management Unit" dialog box, and add the "component service" Management Unit.

(2) choose component service> Computer> my computer> COM + application> O
Ut-Of-Process Pooled Applications, right-click Out-Of-Process Pooled Appli
Cations> properties ".

(3) switch to the "Out-Of-Process Pooled Applications" attribute dialog box and select "flag ".
Item card. "This application runs under the following accounts" selected "this user" will be selected, the user name is
"IWAM_MYSERVER ". These are all default values and do not need to be modified. In the "password" and "Confirm Password" below
Enter the correct password "Aboutnt2001" in the "code" text box to exit.

(4) If the system prompts "the application is created by more than one external product. Are you sure you want to get these products
Yes ?" .

(5) If we set "application protection" for some other Web pages in IIS to "high (independent )",
The IWAM account and password of the COM + application used by the WEB must also be synchronized. Repeat (1 )-

(4) synchronize the IWAM account and password of the corresponding Out of process application.

2. Use the IWAM account synchronization script synciwam. vbs
In fact, Microsoft has discovered that the IWAM account has problems in password synchronization. Therefore, the IIS5 management script
A script synciwam. vbs is written separately for the IWAM account and password in C: \ ine
In the tpub \ adminscripts subdirectory (the location may vary depending on the settings you set when installing IIS5 ).

Synciwam. vbs script is easy to use:

Cscript synciwam. vbs [-v |-h]

The "-v" parameter indicates that the entire script execution process is displayed in detail (recommended), and the "-h" parameter is used to display
Simple help information.

To synchronize the password of the IWAM_MYSERVER account in the COM + application, you only need to execute
"Cscript synciwam. vbs-v:

Cscript c: \ inetpub \ adminscripts \ synciwam. vbs-v
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2000. All rights reserved.
WamUserName: IWAM_MYSERVER
WamUserPass: Aboutnt2001
IIS Applications Defined:
Name, AppIsolated, Package ID
W3svc, 0, {3D14228C-FBE1-11d0-995D-00C04FD919C1}
Root, 2,
IISHelp, 2,
IISAdmin, 2,
IISSamples, 2,
MSADC, 2,
ROOT, 2,
IISAdmin, 2,
IISHelp, 2,
Root, 2,
Root, 2,
Out of process applications defined:
Count: 1
{3D14228D-FBE1-11d0-995D-00C04FD919C1}
Updating Applications:
Name: IIS Out-Of-Process Pooled Applications Key: {3D14228D-FBE1-11D0-
995D-00C04FD919C1}

From the execution of the above script, we can see that the use of synciwam. vbs scripts is better than the use of component services.
Method is more comprehensive and fast. It first finds the IWAM account "IWAM_MYSERVER" from the metabase database of IIS"
Obtain the corresponding password "Aboutnt2001", and then find all the defined IIS Applications and
Out of process applications, and synchronize each Out of process applicatio one by one
The IWAM account password of the ns application.

When using the synciwam. vbs script, pay attention to one problem, that is, before you run synciwam. vbs,
Make sure that the IIS metabase database and the IWAM password in Active Directory are consistent. Because
The script for synciwam. vbs is obtained from the IIS metabase database rather than from the Active Directory IW.
The password of the AM account. If the password in IIS metabase is incorrect, the password obtained by synciwam. vbs
The error 80110414 is returned when the synchronization operation is executed on the "Updating Applications" system.
The application {3D14228D-FBE1-11D0-995D-00C04FD919C1} cannot be found }".

Now, the IWAM account is in Active Directory, IIS metabase database, and COM +
The password in application 3 has been synchronized, and your ASP program can run again!

Asp error description:
The solution to errors when writing programs is not comprehensive, but the general problems should all be available. Haha, you are welcome to add new error messages and solutions.
Active Server Pages, ASP 0126 (0x80004005) --> the inclusion file cannot be found.

Microsoft ole db Provider for ODBC Drivers (0x80040E21) --> SQL statement error (Data Type mismatch, table name (field name) error, or table editing status, or the table does not exist in the Database opened by conn)
Microsoft ole db Provider for ODBC Drivers (0x80040E14) --> SQL statement error (incorrect field name or Data Type mismatch)
Microsoft ole db Provider for ODBC Drivers (0x80040E07) --> SQL statement error (the type of the field to be inserted or updated does not match the data type of the variable)
Microsoft ole db Provider for ODBC Drivers (0x80040E57) --> SQL statement error (Data overflow to be inserted or updated)
Microsoft ole db Provider for ODBC Drivers (0x80040E10) --> SQL statement error (incorrect update field name or data type to be updated)
Microsoft ole db Provider for ODBC Drivers (0x80004005) --> SQL statement error (the value of the field to be inserted or updated cannot be null)
Microsoft ole db Provider for ODBC Drivers (0x80004005) --> An error occurred while opening the database. The database was not found in the specified directory.
Microsoft ole db Provider for ODBC Drivers (0x80040E37) --> no table found

Microsoft VBScript runtime error (0x800A000D) --> the rs variable is referenced incorrectly (the rs object is disabled or undefined)
Microsoft VBScript runtime error (0x800A01C2) --> vbscript error (vbscript statement error)
Microsoft VBScript runtime error (0x800A0006) --> vbscript error (overflow error)
Microsoft VBScript compiler error (0x800A040E) --> loop missing
Microsoft VBScript compiler error (0x800A03EA) --> if or end if is missing
Microsoft VBScript compiler error (0x800A03EE) --> the statement is not completed (")" is missing ")")
Microsoft VBScript compiler error (0x800A03F6) --> if statement error (end if missing)
Microsoft VBScript runtime error (0x800A005B) --> set missing
Microsoft VBScript runtime error (0x800A0005) --> variable undefined
Microsoft VBScript compiler error (0x800A03F9) --> the if statement lacks then.
Microsoft VBScript compiler error (0x800A0411) --> dim statement Definition Error
Microsoft VBScript compiler error (0x800A0408) --> SQL statement 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) --> An error occurred while accessing the rs object. (The rs object does not exist or a nonexistent field name is incorrectly referenced)
ADODB. Recordset (0x800A0BCD) --> rs image error (operations on the record set are performed if no record is recorded in 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 (reference a nonexistent field name)
ADODB. Recordset (0x800A0E7D) --> conn definition Error
ADODB. Recordset (0x800A0CB3) --> the database is read-only and cannot be updated.