Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
Thank you for any suggestion,
Best regards,
Romana
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
A new Knowledge Base article has been published on this topic: Utilizing MS Access in Dataiku DSS
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
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
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
Hi,
we use 4.0.4 version and for bigger files, we process it using python code. That works.
Best regards,
Romana
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.
In fact there are regressions in ucanaccess 5.0 with 4.0.4 it works ... Thanks
A new Knowledge Base article has been published on this topic: Utilizing MS Access in Dataiku DSS