none
Error 22018 Connect ODBC MYSQL & POWER BI RRS feed

  • Question

  • Hello,

    I use Power BI desktop

    I am connected to MYSQL Database with ODBC Mysql connector. 

    I have a problem with a table. I have this error message.

    DataSource.Error: ODBC: SUCCESS_WITH_INFO [22018] [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.28-log]
    Détails :
        DataSourceKind=Odbc
        DataSourcePath=dsn=eTT PROD 64
        OdbcErrors=Table

    I specify that when I connect to that table with Excel with the same connector, I have no problem.

    I have no problem to with other tables of this database

    Thanks for your help

    Christian


    Sunday, March 27, 2016 4:31 PM

Answers

All replies

  • Hi Christian,

    Can you please send this to us as a frown with the traces attached? Let me know if you need help with the traces.

    Thanks for reporting this to us!

    Oguz

    Monday, March 28, 2016 5:59 PM
    Moderator
  • Hello Oguz

    Thanks for your help

    Could you explain me where can I find “traces attached”?

    Otherwise, I installed mysql-connector-net-6.6.5.

    When I connect to the database with this connector, I have this error.

    “MySQL : Cannot load from mysql.proc. The table is probably corrupted”

    But, for each table of my data base I used a SQL query like select * from table;, it is OK.

    Thanks

    Christian

    Wednesday, March 30, 2016 2:04 PM