May 21 2010
∞
Connecting to Access database on Windows Server 2008R2
I had to move an old site from Windows Server 2003, IIS5 to IIS 7.5. Sounded like an easy task until I found out it used an Access database with DSN connection. Something like this:
<add key=”ConnectionString” value=”DSN=mydb”/>
Nice old days when configuring a connection string had this extra unnecessary step.
I even felt clueless when I found out that there is no ODBC driver for ACCESS on Win2k8 64 bit. Or at least I couldn’t find one.
I won’t bore you with the details but the solution is here:
<add key=”ConnectionString” value=”Driver={Microsoft Access Driver (*.mdb)};Dbq=mypath\mydb.mdb;”/>
