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

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