Error 80004005 information common in ASP

Source: Internet
Author: User
Tags driver manager odbc sql server driver naming convention odbc sql server driver ole servervariables root directory
Error information (Error message I do not have to translate into Chinese, hehe, everyone understanding)
Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 '
[Microsoft] [ODBC Microsoft Access Driver] The Microsoft Jet database
Engine cannot open the file ' (unknown) '. It is already opened exclusively
By another user, or your need permission to view its data.
Reason:
This error occurs when IIS uses an anonymous account (usually IUSR), where the account is in NT for the database directory
There is no correct permission. (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
It may also be built in a different directory, 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.

Also check to see if the data source file (DSN) is being used by another program flag.
These other programs are typically Visual InterDev, which closes any project that is open and database connected in a InterDev.

This error can also occur if a UNC path (the Universal Naming convention) is used in DSN, instead
The local path is tested because there may 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 ' (unknown) '; 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 not found and no default
Driver specified.
Reason:
The most probable cause is that ConnectString is a session variable initialized in Global.asa, but Global.asa
But not working 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")%>
<P>
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 driver ODBC Driver] General error Unable 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 (CreateFile ()).
Reason:
Two reasons: When a database contains a separate license relationship on the machine,



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.