Consuming an Access Database

CloverDX Platform
1

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?

2

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

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

http://www.microsoft.com/download/en/de … n&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