 |
|
8000XXXX Errors Alerts ASP.NET 2.0 Classic ASP 1.0
Databases Access DB & ADO General SQL Server & Access Articles MySQL Other Articles Schema Tutorials Sql Server 2000 Sql Server 2005 General Concepts Search Engine Optimization (SEO)Search
ASP FAQ Tutorials :: Databases :: Access DB & ADO :: Why does Access give me 'unspecified error' messages?
Why does Access give me 'unspecified error' messages?
You may have seen this error:
Aside from the improper use of MEMO fields (see Article #2188), this may be caused by the mode in which Access is opened. Unless otherwise specified, IIS opens Access databases with adModeUnknown... which has proven to cause random problems in certain configurations. You can overcome this by setting the mode to adModeReadWrite *before* opening the connection, such as:
(For more information on connection strings, see Article #2126.)
To broaden your search on 80004005 errors, you might wish to review Article #2009.
| Provider error '80004005' Unspecified error /<file>.asp, line <line> |
Aside from the improper use of MEMO fields (see Article #2188), this may be caused by the mode in which Access is opened. Unless otherwise specified, IIS opens Access databases with adModeUnknown... which has proven to cause random problems in certain configurations. You can overcome this by setting the mode to adModeReadWrite *before* opening the connection, such as:
| <% cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" cst = cst & Server.MapPath("/<pathtofile.mdb>") set conn = CreateObject("ADODB.Connection") conn.mode = 3 ' adModeReadWrite conn.open cst %> |
(For more information on connection strings, see Article #2126.)
To broaden your search on 80004005 errors, you might wish to review Article #2009.
Related Articles
How do I determine if a table exists in an Access database? Why do I get General error Unable to open registry key 'DriverId'?