# Consuming an Access Database

**URL:** <https://forum.cloverdx.com/t/consuming-an-access-database/937>\
**Category:** CloverDX Platform\
**Created:** [September 29, 2011, 12:00am UTC](https://forum.cloverdx.com/t/consuming-an-access-database/937 "2011-09-29T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dbrock](https://avatars.discourse-cdn.com/v4/letter/d/5daacb/32.png) [@dbrock](https://forum.cloverdx.com/u/dbrock)\
**Post date:** [September 29, 2011, 12:00am UTC](https://forum.cloverdx.com/t/consuming-an-access-database/937/1 "2011-09-29T00:00:00Z")

</div>

I am trying to establish a connection to a MS Access (2007) DB which is local to the machine running CloverETL designer. I believe my problem is that all Jet 4.0 drivers are only 32-bit compliant and my CloverETL is running in a 64-bit 1.6 JRE on windows server 2008.

I have tried creating my JDBC connection string in two ways, both using the JDBC to ODBC bridge by sun.

1. jdbc:odbc:Driver={Microsoft Access Driver (\*.accdb)};DBQ=D:/TransData/TransData.accdb

When I do this, I get the error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

1. jdbc:odbc:

Using the 32-bit DSN on windows server 2008, making sure to use the 32-bit version of the ODBC tool (as found in C:\WINDOWS|SysWOW64\odbcad32.exe). When I try this option, my connection string is jdbc:odbc: and I get the following error via Clover:

The specified DSN contains an architecture mismatch between the Driver and Application

I suspect the issue is the fact that my JVM is 64-bit and my driver is 32-bit. Any suggestions or ways that this can be made to work?

---

<div class="post-metadata">

**Author:** ![dbrock](https://avatars.discourse-cdn.com/v4/letter/d/5daacb/32.png) [@dbrock](https://forum.cloverdx.com/u/dbrock)\
**Post date:** [September 30, 2011, 8:24pm UTC](https://forum.cloverdx.com/t/consuming-an-access-database/937/2 "2011-09-30T20:24:12Z")

</div>

I got this working now.

Apparently, my previous driver install on my windows 2008 R2 server was not working

[http://www.microsoft.com/download/en/de … n&id=23734](http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734)

This driver package is not 64-bit OS compliant, but this one is:

[http://www.microsoft.com/download/en/de … n&id=13255](http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255)

Now my simple JDBC connection string looks like this using the JdbcOdbcDriver:

jdbc:odbc:Driver={Microsoft Access Driver (\*.mdb, \*.accdb)};DBQ=D:/TransactionData/TransactionData.accdb