You may have seen this error:
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.
[ Comment, Edit or Article Submission ]
