Forum Discussion

haroldvandekamp's avatar
haroldvandekamp
New Member
9 years ago
Solved

ODBC DataSource.Error when expanding a table

We want to analyze data from UNIT4 Multivers Online system using ODBC using the UNIT4 Multivers Online ODBC-driver. Using the Power BI ODBC connector we want to import the UNIT4 data. After setting u...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi haroldvandekamp,

     

    I got below information internally:

     

    We do quite a few operations against the driver which Excel does not do. In this case, we’re trying to get the primary keys for schema: SYSADM, table: DEBITEUR and the server is returning an error. This may indicate a bug in the driver or that the user is missing certain permissions on the server which are necessary to get the primary keys of the table.

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi haroldvandekamp,

 

What's the progress about this issue?

 

Best Regards,
Qiuyun Yu

haroldvandekamp's avatar
haroldvandekamp
New Member
9 years ago

No progress at the moment because of the holiday. Can take up until September.

  • Boudewijn's avatar
    Boudewijn
    Frequent Visitor
    7 years ago

    I have almost the same error;

     

    DataSource.Error: ODBC: ERROR [HY000] SQLPrepare: Driver not capable--ORDER BY is not supported

     

    Is there already a solustion?

     

    Thanks for your efforts

     

    Boudewijn