Recommended: How to use session when verifying management login People who are new to ASP have never known session very well. I am talking about the simple use of session when doing simple background login: 1: login.htm I won't say much about this page. Add the form to write the administrator nickname and give the text box username.
The following are some errors in database calls in ASP programs that are often encountered during virtual machine maintenance. Now we are collecting and sorting them out as follows:
Cannot open registry keywords (8007000e)
Microsoft OLE DB Provider for ODBC Drivers Error '8007000e'
[Microsoft][ODBC Microsoft Access Driver] Common Errors Cannot Open Registry Keyword'Temporary
(volatile) Jet DSN for process 0x11b4 Thread 0x1a4c DBC 0x9d34354 Jet'.
1. The writing method is incorrect when opening the database. The standard ACCESS database call writing method:
driver={Microsoft Access Driver (*.mdb)};dbq= & server.mappath(db.MDB)
2. Uploading the database file.
General network errors. Please check the 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 the network documentation.
1. The database connection is written incorrectly, and the database name and server name may be incorrect.
2. The database server is restarting.
Cannot use ''; the file is already in use (80004005)
Microsoft JET Database Engine Error '80004005'
Cannot use ''; the file is already in use.
1. Files may be occupied: upload, compress, and package.
2. It is possible that a nested and repeated database call file is formed in the program code.
Cannot be updated. A database or object must use an updateable query for read-only/operation (80004005)
Microsoft OLE DB Provider for ODBC Drivers Error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The operation must use an updateable 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.
1. The database file permissions are insufficient.
2. The file space occupied by the upper limit of the disk.
There are several main reasons for errors when prompting that an operation must use an updateable query: This error occurs when your program tries to perform update database or other similar operations. This is because ADO cannot write a database due to the following reasons.
1. The most common reason is that the anonymous user account (IUSR_MACHINE) does not have write permissions to the database file. To solve this problem, adjust the properties of the database file in the manager to give anonymous users the correct permissions. When using ACCESS database, you must not only give permission to write the file, but also give permission to write the directory, because Jet needs to create a .ldb file in the directory.
2. The second reason is that the database is not opened in the correct mode. It should be opened using the following method.
SQL = UPDATE Products Set UnitPrice = 2;
Set Conn = Server.CreateObject(ADODB.Connection)
Conn.Mode = 3 '3 = adModeReadWrite
Conn.Open myDSN
Conn.Execute(SQL)
Conn.Close
Note that the default Mode is set to 0 (adModeUnknown), which allows updates.
3. It is also possible to select the read-only option of the DSN in the ODBC manager.
4. When you are updating the fields in two tables at the same time, this error message will also appear. The solution is to update the respective fields in the two tables separately.
5. When you use a query that is loaded from the lower version (such as ACCESS2.0, ACCESS7.0) into the higher version (ACCESS 2000), the error will occur when executing this query.
No data source name was found and no default driver was specified (80004005)
Microsoft OLE DB Provider for ODBC Drivers Error '80004005'
[Microsoft][ODBC Driver Manager] No data source name found and no default driver specified
1. The ODBC database is used to connect to the database. The ODBC database is not configured on the server. Instead, the standard calling method of OLEDB is used:
Driver={SQL Server};Database=dbname;Server=srv;Uid=user;Pwd=pd can solve it.
Share: ASP Security: Simple Learning Method of Connecting to Databases 1.Conn.open Provider=Microsoft.Jet.OLEDB.4.0;Data Source= & Server.mappath(/db/database.mdb) This uses the relative path method of the root directory to solve the entire website.