Some database-related errors and causes in ASP

Source: Internet
Author: User
Tags connect odbc sql server driver odbc connection odbc sql server driver ole access database file permissions
Error | data | database

ADODB. Recordset error ' 800a0bb9 '

The variable or type is incorrect, or is not within the acceptable range, or conflicts with other data.

Possible causes of error:

1. This error is more than the same statement at present: "Rs." Open sql,conn,1,1 because the database connection conn object is not open.

Unable to open registry key (8007000e)

Microsoft OLE DB Provider for ODBC Drivers error ' 8007000e '

[Microsoft] [ODBC Microsoft Access Driver] Common error cannot open registry key ' temporary (volatile) Jet DSN for process 0x11b4 Thread 0x1a4c DBC 0x9d34354 Jet '.

Possible causes of error:

1. When you open the database incorrectly, the standard Access database calls are written:

"Driver={microsoft Access Driver (*.mdb)};d bq=" & Server.MapPath ("DB. MDB ")

2. Uploading database files.

Insufficient parameters, look forward to is 1 (80040e10)

Microsoft OLE DB Provider for ODBC Drivers error ' 80040e10 '

[Microsoft] [ODBC Microsoft Access Driver] has insufficient parameters, expect to be 1.

Possible causes of error:

1. The SQL query statement that opens the data has a problem following the conditional clause, which is typically missing a logical comparison symbol or incorrect field name.

General network error. Check your network documentation (80004005)

Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 ' [Microsoft][odbc SQL Server DRIVER][TCP/IP Sockets] General network error. Please check your network documentation.

Possible causes of error:

1. Incorrect database connection writing, possibly database name, server name error.

2. Database server reboot.

Cannot use '; files are already in use (80004005)

Microsoft JET Database Engine error ' 80004005 '

Cannot use '; file is already in use.

Possible causes of error:

1. Files may be occupied: Upload, compress, pack.

2. There may be nested inclusion in the program code, repeating the contained database call file.

cannot be updated. Database or object must use an updatable query for read/operate (80004005)

Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 '

[Microsoft] The [ODBC Microsoft Access Driver] operation must use an updatable query.

Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 ' [Microsoft][odbc Microsoft Access Driver] cannot be updated. The database or object is read-only.

Possible causes of error:

1. database file permissions are not sufficient.

2. The amount of space occupied by the file reaches the disk limit.

No data source name found and no default driver specified (80004005)

Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 '

[Microsoft] [ODBC Driver Manager] did not find a data source name and no default driver specified

Possible causes of error:

1. Using the ODBC Connection database, the ODBC database is not configured on the server, and the standard invocation method for OLE DB is used instead:

"Driver={sql Server};D atabase=dbname; Server=srv; Uid=user; PWD=PD "can solve

Provider error ' 80004005 '

Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 '

Unspecified error

/pcn/conn.asp, line 8

Possible causes of error:

1. From the name of the page where the error occurred, it is a problem that occurs when you connect to the database. The biggest possible is the inability to connect to the database, and the above "General network error ..." "is a matter of the same nature. Then you need to check the database server for normal. This type of error generally occurs on the connection to the MS SQL Server database.

ADODB. Recordset error ' 800a0e7d '

ADODB. Recordset error ' 800a0e7d '

The connection cannot be used to perform this operation. It may have been closed or invalid in this context.

/index.asp, Line 9

Possible causes of error:

1. A database connection that has been closed or has not been opened has been used in the program.

Server.CreateObject failure

Server object error ' ASP 0177:800401f3 '

Server.CreateObject failure

/xxxxx.asp, line 155

Invalid ProgID. To get more information about this message, please visit the Microsoft Online Support site: http://www.microsoft.com/contentredirect.asp.

Possible causes of error:

1. Most of this error occurs when the component is created, stating that the component used by the program is not supported by the server and needs to register the components used. It is common in various ASP pages that use the upload component.



Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.