When running asp, it prompts Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC Microsoft Access Driver] The file '(Unknown)' cannot be found. 'Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] File '(unknown)' not found.
/conn/conn1.asp, line 3'
The configuration of IIS7.0 is correctly set in windows7, and ASP is set correctly.
There is a permission problem, but the above error will pop up when running!
My database connection code is:
Copy the code code as follows:
<%
Set conn = Server.CreateObject(ADODB.Connection)
conn.open DRIVER={Microsoft Access Driver (*.mdb)}; DBQ= & DefaultDir &server.mappath(worker.mdb)&;
Set rs = Server.CreateObject(ADODB.Recordset)
Set rs1 = Server.CreateObject(ADODB.Recordset)
Set rs2 = Server.CreateObject(ADODB.Recordset)
Set rs3 = Server.CreateObject(ADODB.Recordset)
%>
There are many versions of explanations circulating on the Internet, and I tried the solution:
The windows/temp folder is missing a user group permission
Generally, in the IIS installed by default in Windows 7, the missing user group is Authenticated Users.
Add to
Authenticated Users
The default permissions are read and write. ok, the system is running normally