Error: Data source name not found

Error:

Database info activities to connect to MS access files are not working. Please see below for the error message received while testing the connection:
========================

Connection could not be established. Either database connection properties are incorrect or database is down. Try again with correct properties.
Driver =sun.jdbc.odbc.JdbcOdbcDriver$
URL = jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\temp\test_Src.mdb
User ID = SA
Database connection failed to URL :jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\temp\test_Src.mdb, Error : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

=====================
The .mdb file location is correct.

We have recently moved the installation from a Windows 2003 server to a Windows 2008 server.

Cause:

The Microsoft Access driver may be incorrect (32-bit version instead of the 64-bit version)

Solution:

Make sure the DSN has been properly created as explained here  - http://www.fekete.com/SAN/WebHelp/FeketeHarmony/Harmony_WebHelp/Content/HTML_Files/Setting_up_Your_Database_for_Import/Creating_a_DSN/Creating_a_DSN_for_an_Access_DB.htm

If the Database info activities had worked before moving between servers, you may have to update your MS Access driver to use the 64-bit version. You can download the updated driver at the link below

- http://www.microsoft.com/en-us/download/details.aspx?id=13255

Note: When installing the 64 bit driver, you may encounter this error

You cannot install the 64-bit version of Office 2010 because you have 32-bit Office products installed.

You may have to uninstall 32-bit version of Microsoft Office to run the 64-bit Microsoft Access Database Engine.