ASP learning: how to handle error 80004005

From: http://designs.6to23.com/

1. error information (I do not need to translate the error information into Chinese. Thank you for your understanding)
Microsoft ole db Provider for ODBC Drivers error 80004005
[Microsoft] [ODBC Microsoft Access 97 Driver] The Microsoft Jet database
Engine cannot open the file (unknown). It is already opened exclusively
By another user, or you need permission to view its data.

Cause:

This error occurs when IIS uses an anonymous account (usually IUSR) and the account does not have the correct permission for the database directory in NT. (This is why there is no problem in Win95 and PWS, because win95 has no directory permission at all.) Check the file and directory permissions. make sure that you have the permission to create and delete temporary files in this directory.

These temporary files are actually files created in the same directory of the database, but note that these files may
It may also be created in another directory, such as/Winnt.

What directory is accessed when an NT file monitoring program fails to monitor the file.
This NT File Monitor can download http://www.sysinternals.com in this place.

If you use a network address for the database, such as a ing address, check the permissions of shared files and directories,

Check whether the data source file (DSN) is marked as in use by other programs,
These other programs are generally Visual InterDev, which closes any project in InterDev that is connecting to the database.

This error may also occur in this case: If a UNC path (generic naming Protocol) is used in the DSN, use the local path for testing, this is because an error may occur if you use UNC for a local database.

This may also happen if the server wants to Access a table in Access, but the table is connected to a network server.

2. error message:

Microsoft ole db Provider for ODBC Drivers error 80004005
[Microsoft] [ODBC Microsoft Access 97 Driver] Couldnt use (unknown); file
Already in use.

Cause:

The database is locked when multiple users use it.

3. error message:

Microsoft ole db Provider for ODBC Drivers error 80004005
[Microsoft] [ODBC Driver Manager] Data source name not found and no default
Driver specified.

Cause:

The most likely cause is that ConnectString is a Session variable initialized in global. asa, but global. asa
But not working properly. The solution is to check whether the assignment is correct: (Add the following code to your asp)

Another reason is that you add extra spaces to your ConnectString, such

DSN = MyDSN; Database = Pubs;
Try to change it to the following:
DSN = MyDSN; Database = Pubs;

If global. asa is not working, check whether the file is in the root directory of the application or the root directory of the virtual directory.