Errors generated by using oledb in ASP. NET and ASP: '0 × 80004005 'unspecified errors

Source: Internet
Author: User

1. ASP. NET:
Throwing an exception system. Data. oledb. oledbexception: unspecified error
Error '0x80004005' unspecified error

The solution to this problem is as follows:
(1). This is because you have no permission to write files in the temporary directory. The cause of this problem: the system temp folder has insufficient access permissions to modify the method as follows: Go to tool-Folder option-view-to use simple file sharing (recommended) and turn it off. Go to Windows/temp, right-click and choose-properties. You will see an option called "security", add an everyone, and set the permission to full control, then, set the Windows user to full control, and then OK.

(2). Web written using ASP. NETProgramWhen there are too many accesses to the database, the system will report the error "unspecified error 0x80004005" upon logon. The reason is that the database cannot be connected, on the server, if IIS is full of Files written to the Temporary Folder and cannot be written, restart the server, clear the temporary files, or adjust the disk space (with the disk quota. To the IIS account: the Internet Guest Account has sufficient space for writing permissions on disk C) or defines a temporary folder to another disk that is large enough.

(3). Just clear the IIS program pool.

Connection statement:
Provider = Microsoft. Jet. oledb.4.0; Data Source = 'd: \ etsd2 \ upload \ customer.csv '; extended properties = 'excel 8.0; HDR = yes; IMEX = 1'

2. In ASP:
Microsoft Jet Database Engine
first, you must set the webpage file directory to accessible to Internet users.
under the "Security" tab, click "add ......", Pop out the "select user and group" dialog box
and click "Search now ", select "IUSR _" in the list shown in (your computer name is iuser _ your machine name after the underline)
"Internet Guest Account" is displayed on the "Security" tab ", set the account permissions to "changeable" and "writable".
Click OK to solve the problem, no "Microsoft ole db provider for ODBC drivers (0x80004005)" error will appear again!
the second is to set the c: \ windows \ Temp folder as an Internet user, which can be modified and readable.
the system creates a temporary file in the temporary directory (% WINDIR %/temp/), and this directory has insufficient permissions. Add the read and write permissions of the iuser _ computer name to this directory.
open the c: \ windows \ Temp directory and add the user iusr_xxx (Open IIS, right-click Properties, check whether the user in the security directory is iusr_xxx. If it is an iusr_xxx user, add the same user to the temp directory if it is another user name !) The directory with write permission is % SystemRoot % \ Temp (that is, the c: \ windows \ Temp directory when the system is installed by default).

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.