Connect to MS Access file with Date/Time data type

Romana

Hi,

I am trying to connect to MS Access files with some fields of Date/Time data type.

I followed the steps suggested in similar post: https://community.dataiku.com/t5/Using-Dataiku-DSS/How-to-open-an-MS-Access-file/m-p/901 but this only works for files without "Date/Time" filed in Access data.

Otherwise I get following error:

UCAExc:::5.0.0 incompatible data type in conversion, caused by: SQLSyntaxErrorException: incompatible data type in conversion, caused by: HsqlException: incompatible data type in conversion

Additional technical details

• Error type:net.ucanaccess.jdbc.UcanaccessSQLException

Thank you for any suggestion,

Best regards,

Romana

rikro

Seems some bug in either UCanAccess or one of its dependent libraries.

For me it works when using UCanAccess 4.0.4 from https://sourceforge.net/projects/ucanaccess/files/archive/v4_archive/.

Best regards,
Richard

CoreyS

A new Knowledge Base article has been published on this topic: Utilizing MS Access in Dataiku DSS

Romana

Thank you @rikro
, @CoreyS
for both answers!

It finally works now! However I have encountered issues when trying to connect to bigger databases (over 500MB). Dataiku seems to crush every time I try to connect to such a big DB. Do you have any tip / workaround for that?

Many thanks for you help!

Romana

au8

Hello is it possible to know how you solved it please ?

I am using ucanaccess-5.0.0 and I have the same error

Thanks

Romana

Hi,

we use 4.0.4 version and for bigger files, we process it using python code. That works.

Best regards,

Romana

au8

Hi thanks for your reply

I use ucanaccess-5.0.0 and I have this error on small MS Access file ... but on linux not on Windows.

au8

In fact there are regressions in ucanaccess 5.0 with 4.0.4 it works ... Thanks