I have spent HOURS trying to fix this problem, without any solution. I am receiving the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
/chsff/DataConnectionDBQ.asp, line 3
Of course this all worked fine when I had XP, but now I am using Vista. I have set up a Defaul Web using IIS, I have set the IUSR to have full access on both the folder and the files. I have taken off the "inherited permissions." The actual file is:
<!--#include file="DataConnectionDBQ.asp"-->
<%
strName = Request.Form("tID")
strPassword = Request.Form("tPassword")
SQL = "SELECT * FROM tblTeacherInfo WHERE tID='" & strName & "' AND tPassword='" & strPassword & "';"
set objUsersRS = DataConnection.Execute (SQL)
%>
The include file is:
<%
Set DataConnection=Server.CreateObject("ADODB.Connection")
DataConnection.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("chsFeesAndFines.mdb")
%>
I have also tried it using an actual path instead of Server.MapPath. All gives the same error. Any suggestions?