1. Error Message Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft] [ODBC Microsoft Access 97 Driver] The Microsoft Jet database engine can not open the file '(unknown)'. It is already opened exclusively by another user, or Reasons: This error occurs when IIS uses an anonymous account (usually IUSR), the account is not correct in the directory where the database is located in NT. (This is why Win95 and PWS No problem, because Win95 has no directory permission to check the permissions of files and directories. Make sure you can have a new and delete temporary files in this directory. These temporary files are actually files that the database is built in the same directory, but it should be noted that these files may also be built in other directories, such as / Winnt. Using the NT file monitoring file to fail, it is access to the end What is a directory. This NT file monitor can be http://www.sysinternals.com in this place.
If you use a network address for the database, such as a map address, you have to check the permissions of shared files and directories.
Also check if the data source file (DSN) is in use by other program flags, which are typically Visual InterDev, close to the projects in any InterDev, and a database connection.
This error may also happen: If a UNC path is used in the DSN (that is, the universal naming protocol), you can use the local path to test because if you use UNCs to the local database. It is also possible to happen, if the server wants to access a table in Access, and this table is coupled to a web server.
2. Error message: Microsoft OLE DB Provider for ODBC Drivers Error '80004005' [Microsoft] [ODBC Microsoft Access 97 Driver] COULDN '' '' .
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 a ConnectString is in the global.asa The initialized session variable, but Global.asa did not work properly. The solution is to check if it is correct: (add the following code in your ASP)
Another reason is that you have added extra spaces in your ConnectString, such as DSN = MyDSN; Database = PUBS; try again to look like: DSN = MyDSN; Database = PUBS;
If Global.asa has not yet worked, check if the file is in the root directory of the program, or in the root of the virtual directory.
There is also a possibility that the cause is that the DSN name is not found, which can be solved by Idle Id = 36767. Finally, check whether the latest driver is installed, whether it is the latest MDAC version. 4. Error message Microsoft Ole DB Provider for ODBC Drivers Error '80004005' [Microsoft] [ODBC Driver Manager] Data Source Name Not ?? Cause: This error may be available on your computer installation (or reverse installation) In the order of order. If the version of the ODBC is inconsistent, it will happen. Solution is to install the latest version of MDAC
5. Error message: Microsoft Ole DB Provider for ODBC Drivers Error '80004005' [Microsoft] [ODBC Access 97 ODBC Driver Driver] General Error Unable to Open Registry Key 'DriverId'. Cause: This error occurs in love from the registry When you take a value. Use regedit32.exe to check the permissions of your registry. You can also read the failed information using the Registry Monitor (NTREGMON) in NT. This program is found to find http://www.sysinternals.com;
6. Error message: Microsoft Ole DB Provider for ODBC Drivers Error '80004005' [Microsoft] [ODBC SQL Server Driver] [DBNMPNTW] ConnectionOpen (CREATEFILE ()). Cause: Two reasons: When a database is included in a database This may also occur on the same machine when the license is on the machine, and the other relationship is the local path when you give a relationship. The error reason is that when the user uses the IIS anonymous account to log in, he is right, but for the machine for a UNC path, this machine will not think that your current anonymous login account is in it That is also legal. This does not allow you to access the resources above, causing errors.
Two solutions: 1. In the IIS tool, change the IIS anonymous account into another domain-based account. (I.e., no anonymous login) 2. Or, on the machine you want to access resources, create a sum of the same account as the current anonymous account, using the same password.
7. Error message Microsoft OLE DB Provider for ODBC Drivers Error '80004005' Microsoft] [ODBC Microsoft SQL Driver] Logon Failed () Cause: This error is generated by SQL Server, when it is not accepted or can not know this login account When you use an administrator to log in, it may be caused by no SQL image in NT.
Using System Administrator Account (SA), the general password should be empty. Note that you must use CoonectString without using the DSN file. Because the username and password are not saved in the DSN. Check if the NT is mapped to SQL.
8. The error message Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft] [ODBC SQL Server Driver] [SQL Server] Login failed- User: Reason: Not defined as a valid user of a trusted SQL Server connection reasons: The reason is the same. Try this method: In the Enterprise Manager of SQL Server, select Server / SQL Server / Configure [ASCII 133] / Security Options / Standard. If you are running in IIS4, deselect the Password Synchronization option for the project. 9. Error information Microsoft Ole DB Provider for ODBC Drivers Error '80004005' [Microsoft] [ODBC Microsoft Access 97 Driver] COULDN '' '' Lock File. Cause: Perhaps the lock file (.LDB) of the ACCESS database is generated without the correct permissions. This file is the same directory with your database. Access the permissions of the database shared directory for anonymous accounts.
Sometimes because the file is due to sharing, it is intended to use only read-only permissions. Try using the following code. Set conn = server.createObject ("adoDb.connection") conn.mode = admodesharedenywrite '8
10. The error message Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft] [ODBC Microsoft Access 97 Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are Reason: The path is illegal. It is most likely that when Global.asa and Coonecntstring are used to be used on another machine.
11. Error message Microsoft OLE DB Provider for ODBC Drivers Error '80004005' [Microsoft] [ODBC SQL Server Driver] [SQL Server] The Query and The Views in It Exceed The Limit of 16 Tables.
Reason: The query is too complicated, and the query is restricted.
12. Error message: Microsoft OLE DB Provider for ODBC Drivers Error '80004005' [Microsoft] [ODBC SQL Server Driver] [DBMSSOCN] General Network Error. Check Your Network Document Cause: When there is a machine with SQL Server to change the name. But DSN also uses the original machine name.
