May 13, 2009

ADODB.Connection error '800a0e7a'

If you are getting the following error when try to run as ASP code:

ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/inc/require.asp, line 184 

The code on Line 184 references opening a Microsoft Access Driver:

s = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("db/rcf.mdb") & ";"

The reason you are getting this error is because Microsoft hasn't made a 64 bit driver for Access. You best solution is to try running the ASP code in a non 64 bit environment. (i.e Install it on another machine.) Sorry for the bad news, but this will stop you from spending hours searching for a solution that doesn't exist.