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.devasp.com/samples/dsn_access.asp

 

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.

Have more questions? Submit a request

0 Comments

Article is closed for comments.