New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

Connect to MS Access file with Date/Time data type

Solved!
Romana
Level 3
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

 

2 Solutions
rikro
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

View solution in original post

CoreyS
Community Manager
Community Manager

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

Looking for more resources to help you use DSS effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!

View solution in original post

7 Replies
rikro
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

View solution in original post

Romana
Level 3
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
au8
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
Romana
Level 3
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
au8
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
au8
Level 1

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

0 Kudos
CoreyS
Community Manager
Community Manager

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

Looking for more resources to help you use DSS effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!

View solution in original post

A banner prompting to get Dataiku DSS