Snaplogic connect to MS-Access MDB database

[dshen]

You can use the JDBC snap to access the MS-Access MDB database by using 3rd party JDBC driver. The example here is using the JDBC driver from UCanAccess.

Note that the JDBC driver will have no idea on how to access an SLDB:// location. The database file must be local on the groundplex or somewhere accessible from the groundplex.

[krupalibshah]

thank you, it solved the issue.

[PSAmmirata]

Our groundplex nodes are on Linux. Does the Access DB file have to reside on a file system that’s mounted on the groundplex node? Or could it reside on a Windows network share that’s network accessible from the groundplex node?

[subbhasis]

I have used similar connection with accdb file in the groundplex location . I am getting another error “UCAExc:::4.0.2 unexpected end of statement”

[Abrar]

Hello,

This looks like an issue with the 3rd party driver UcanAccess. I have tried another driver (Trial Versions of caigen driver) and it’s working fine.

​

Snaplogic is using updated the Hikari connection pool management library version. This newer version requires databases to be able to support a validation query of “SELECT 1;” or have the driver itself implement a custom validation method. If you run select 1 using caigen driver it’s working fine but ucanaccess driver is rejecting that query. If the driver is JDBC 4.0 compatible they should support isValid method.

– Please see the below doc.

https://docs.oracle.com/javadb/10.8.3.0/ref/rrefjdbc4_0connection.html

– Caigen links

http://www.caigen.com/download.html