Connect to MS Access file with Date/Time data type

Romana
Romana Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 15 ✭✭✭✭

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

Best Answers

Answers

  • Romana
    Romana Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 15 ✭✭✭✭

    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
    au8 Registered Posts: 3 ✭✭✭

    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
    Romana Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 15 ✭✭✭✭

    Hi,

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

    Best regards,

    Romana

  • au8
    au8 Registered Posts: 3 ✭✭✭

    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
    au8 Registered Posts: 3 ✭✭✭

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

Setup Info
    Tags
      Help me…