ASP classic Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Question

I'm having problem in connecting my MS Access Database. I'm using IIS7. I'm receiving this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

And this is my database connection:

<%
 dim rs,con,sql
 SET con=Server.CreateObject("ADODB.Connection")
 SET rs=Server.CreateObject("ADODB.Recordset")

 con.open "DRIVER={Microsoft Access DRIVER (*.mdb)}; DBQ=" & Server.MapPath("crs.mdb") & ""
 sql="SELECT * FROM tblAccount WHERE fldUsername='"& request.form("txtuser") &"' AND fldPassword='"& request.form("txtpass") &"';"
 rs.CursorType=2

 rs.Open sql, con

 if rs.bof then
   response.write "WRONG"
else
   response.write "CORRECT"
 end if

 rs.Close
 SET rs=Nothing
 SET con=Nothing
%>

My unit is Windows & ultimate 64 bit.

Answer 1

Have you tried enabling 32 bit applications support in IIS?

http://help.webcontrolcenter.com/KB/a1114/how-to-enable-32-bit-application-pool-iis-7-dedicatedvps.aspx