Error: Data source name not found


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.



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



Make sure the DSN has been properly created as explained here  -


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



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.

Have more questions? Submit a request


Article is closed for comments.