What are we cooking today?
Connecting to an Access Database that was working OK on a 32 bit OS but was moved to a 64bit OS like Windows Server 2008.
Connecting to an Access Database that was working OK on a 32 bit OS but was moved to a 64bit OS like Windows Server 2008.
If you use Microsoft.Jet.OLEDB.4.0 when your server has 64 bit, it just don't work.
Recipe
Recipe
Go to
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en
download and install the Microsoft access database engine .exe and change the connection string that fits your case.
The one that worked for me was:
"...If you are application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to
“Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file” ..."
"...If you are application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to
“Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file” ..."
“Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file” ..."
