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
2) jdbc:odbc:<DSN name>
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:<DSN name> 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?
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
2) jdbc:odbc:<DSN name>
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:<DSN name> 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?
-
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
Please sign in to leave a comment.
Comments 1