The phenomenon and solvement of frequent errors in the database calls in ASP

xiaoxiao2021-03-06  74

Copyright Notice: You can reprint anything, you must indicate the original source and author information in hyperlink when reprint.

Below is the error in some ASP programs that often encounters some ASP programs that often encounter, and collected is as follows:

Microsoft OLE DB Provider for SQL Server Error '80040e14'

Syntax error or violation of access rules

Generate error reasons:

When executing the CREATE TABLE statement, braces {} should be used to replace braces with small brackets.

error:

Create Table Test {ID Int Idness (1, 1), FIMAGE Image}

correct:

Create Table Test (ID Int Id Idness), FIMAGE Image

AdoDb.recordset error '800A0BB9'

Variables or types are incorrect, or they are not within the range of acceptable, or they must conflict with other data.

Produce errors possible:

1. This error appears in the similar statement: "RS.Open SQL, CONN, 1, 1" because the database connection CONN object is not open.

2. SQL statement may be spelled wrong, maybe a field name is incorrect, or miss an error such as a single quotation mark.

------------------------------------

Microsoft Jet Database Engine Error '80040E0c'

No commands are set for the command object.

1. This error has not been opened with the database connection, and the database connection object is started. Just call Conn.Open, start using conn.openrecordset.

------------------------------------

Microsoft OLE DB Provider for ODBC Drivers Error '8007000E'

[Microsoft] [ODBC Microsoft Access Driver] Common Error You cannot open the registry keyword 'Temporary (Volatile) Jet DSN for Process 0x11b4 Thread 0x1a4c DBC 0x9D34354 JET'.

Produce errors possible:

1. Writing is not right when opening the database, the standard Access database calls:

"Driver = {Microsoft Access Driver (* .mdb)}; dbq =" & Server.mappath ("db.mdb")

2. Upload database files.

------------------------------------

Insufficient parameters, expecting 1 (80040e10)

Microsoft Ole DB Provider for ODBC Drivers Error '80040e10'

[Microsoft] [ODBC Microsoft Access Driver] is insufficient, and it is expected to be 1.

Produce errors possible:

1. Open the data SQL query statement where there is a problem with the condition clause, which is generally the missing logic comparison symbol or the field name is incorrect.

------------------------------------

General network errors. Please check the network document (80004005)

Microsoft OLE DB Provider for ODBC Drivers Errors '80004005' [Microsoft] [ODBC SQL Server Driver] [TCP / IP Sockets] General Network Error. Please check the network documentation.

Produce errors possible:

1. Database connection is incorrect, possible database name, server name error.

2. Database server restart.

------------------------------------

Can't use ''; files are already in use (80004005)

Microsoft Jet Database Engine Error '80004005'

Can't use ''; files are already in use.

Produce errors possible:

1. Files may be occupied: upload, compression, packaging.

2. Possible program code forms a nested, repeated database call invoking files.

------------------------------------

Can't update. Database or objects must be read-only / action must use an updateable query (80004005)

Microsoft OLE DB Provider for ODBC Drivers Errors '80004005'

[Microsoft] [ODBC Microsoft Access Driver] The operation must be used with an updateable query.

Microsoft OLE DB Provider for ODBC Drivers Error '80004005' [Microsoft] [ODBC Microsoft Access Driver] cannot be updated. Database or objects are read-only.

Produce errors possible:

1. Database file permissions are not enough.

2. The file occupation space reaches the upper limit of the disk limit.

------------------------------------

Data source name is not found and the default driver is not specified (80004005)

Microsoft OLE DB Provider for ODBC Drivers Errors '80004005'

[Microsoft] [ODBC Driver Manager] No data source name is found and the default driver is not specified

Produce errors possible:

1. Use the ODBC connection database, no ODBC databases are configured on the server, and modify the standard call mode:

"Driver = {SQL Server}; Database = dbname; server = srv; uid = user; pWD = PD" can be solved

Provider error '80004005'

------------------------------------

Microsoft OLE DB Provider for ODBC Drivers Errors '80004005'

Unexpected error

/pcn/conn.asp, line 8

Produce errors possible:

1. From the incorrect page name, it is a problem that occurs when connecting the database. The biggest possibility is unable to connect the database, and "General Network Error ..." is the same as the same nature. At this time, you need to check if the database server is normal. Such errors generally appear on the connected MS SQLServer database.

AdoDb.recordset error '800A0E7D'

------------------------------------

AdoDb.recordset error '800A0E7D'

The connection cannot be used to do this. It may have been turned off or invalid in this context.

/index.asp, line 9

Server.createObject failed ------------------------------------

Server object error 'ASP 0177: 800401F3'

Server.createObject failed

/ xxxxx.asp, line 155

Invalid PROGID. To get more information about this message, visit the Microsoft Online Support Site: http://www.microsoft.com/contentredirect.asp. Produce errors possible:

1. Most of this error When you create a component, the components used by the program are not supported, and the components need to be registered. It is common in a variety of ASP pages that use upload components.

Attachment: Some database connection characters are written

Produce errors possible:

1. Use a database connection that has been turned off or has not been opened in the program.

Can't open the registry keyword (8007000E)

转载请注明原文地址:https://www.9cbs.com/read-121180.html

New Post(0)