Check out the first Dataiku 8 Deep Dive focusing on Productivity on October 29th Read More

Connect to MS Access file with Date/Time data type

Level 2
Connect to MS Access file with Date/Time data type

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

 

7 Replies
Level 2

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

Level 2
Author

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 

 

0 Kudos
Level 1

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

0 Kudos
Level 2
Author

Hi,

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

Best regards,

Romana 

0 Kudos
Level 1

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.

 

 

0 Kudos
Level 1

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

0 Kudos
Community Manager
Community Manager

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

Don't forget to mark as "Accepted Solution" when someone provides the correct answer to your question.