Error | Troubleshooting error message:
Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 ' [microsoft][odbc Microsoft Access Driver] the Microsoft Jet Databaseengine cannot open the file ' (unknown) '. It is already opened exclusively by another user, or your need to view its data.
Reason:
This error occurs when IIS uses an anonymous account (usually IUSR), the account does not have the correct permissions for the directory where the database resides in NT. (This is why there is no problem with Win95 and PWS, because Win95 does not have directory permissions at all)
Check permissions for files and directories. Make sure you have permission to create and delete temporary files in this directory.
These temporary files are actually files built in the same directory as the database, but note that it is possible that these files may also be created in other directories, such as/winnt.
What directory is accessed when a file monitor using NT has failed to monitor the file.
This NT File Monitor can download http://www.sysinternals.com in this place.
If you use a network address for a database, such as a mapping address, check the permissions for shared files and directories, and check to see if the data source file (DSN) is being used by another program flag, which is typically Visual InterDev, Close any items in a InterDev that are open and database connected.
This error can also occur if a UNC path (the Universal Naming convention) is used in DSN, instead, use a local path for testing because it can be an error if the UNC is used against the local database.
This can also happen if the server wants to access a table in Access, but the table is joined to a network server.
---------------------------------------------------------------------
Error message:
Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 ' [Microsoft][odbc Microsoft Access Driver] couldn ' t use ' (UN Known) '; File already in use.
Reason:
The database is locked when multiple people are using it.
Error message:
Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 ' [Microsoft][odbc Driver Manager] Data Source name is not found D no default driver specified.
Reason:
The most likely cause is that ConnectString is a session variable initialized in Global.asa, but Global.asa does not work properly. The solution is to check that the assignment is correct: (Add the following code to your ASP)
<%= "' Auth_User ' is" & Request.ServerVariables ("Auth_User")%>
<P>
<%= "' Auth_type ' is" & Request.ServerVariables ("Auth_type")%>
<P>
<%= ' connection string is ' & Session ("Your_connectionstring")%>
Another reason is that you add extra spaces to your connectstring, such as
DSN = MyDSN; Database = Pubs;
Try changing it to the following:
Dsn=mydsn;database=pubs;
If Global.asa is not yet working, check to see if the file is in the root directory of the application, or in the root directory of the virtual directory.
It is also possible that the error occurred because the DSN name was not found, which can be solved by the id=36767 method I provided.
Finally, check to see if the latest driver is installed, whether it is the latest version of MDAC.
---------------------------------------------------------------------
Error message
Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 '
[Microsoft] [ODBC Driver Manager] Data source name not??
Reason:
This error may occur in the order of the Software installation (or reverse installation) on your computer.
This error can occur if the version of ODBC is inconsistent.
The workaround is to install the latest version of MDAC
---------------------------------------------------------------------
Error message:
Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 ' [microsoft][odbc Access ODBC driver driver]general error Una BLE to open registry key ' DriverID '.
Reason:
This error occurs when love reads a value from the registry. Use Regedit32.exe to check your registry permissions.
You can also use the Registry Monitor (NTRegMon) in NT to read the failure information. The program is here to find: http://www.sysinternals.com
Error message:
Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 ' [Microsoft][odbc SQL Server Driver][dbnmpntw]connectionopen (Cr Eatefile ()).
Reason:
Two reasons: When a database contains a separate license relationship on the machine,
This can also happen on the same machine, when you set a UNC path to a relationship, and the other relationship is a local path.
The reason for the error is:
When a user logs on with an IIS anonymous account, he is entitled to the local machine, but for a UNC-path machine, the other machine does not assume that your current anonymous login account is also legal on the computer.
This will not allow you to access resources above it, resulting in errors.
Two solutions:
1. In the IIS tool, change the IIS anonymous account into another domain-based account. (that is, do not use anonymous logins)
2. Or, on the machine where you want to access the resource, create an account that is the same as the current anonymous account, using the same password.
---------------------------------------------------------------------
Error message
Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 ' microsoft][odbc Microsoft SQL Driver] Logon Failed ()
Reason:
This error is generated by SQL Server, when it is not accepted or is not able to recognize the login account, or is not logged in as an administrator, or it may be caused by a SQL mapping account in NT.
Log on using the System Administrator account (SA), the general password should be empty. Note that you must use coonectstring instead of using the DSN file.
The user name and password are not saved in the DSN.
Check to see if NT has mapped the account number for SQL.
---------------------------------------------------------------------
Error message
Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 ' [MICROSOFT][ODBC SQL Server Driver][sql Server] Login failed-u Ser:Reason:Not defined as a valid user of a trusted SQL Server connection.
Reason:
Reasons above.
Try this approach: in SQL Server's Enterprise Manager, select Server/sql server/configure[ascii 133]/security options/standard.
If you are running in IIS4, deselect the Password Synchronization option for the item.
Error message
Microsoft OLE DB Provider for ODBC Drivers
