Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

ODBC Problem with mongoDB BI connector (MySQL)

Hi everybody. Since 1 month, I am not able to load more than 500,000 (I have 590,000 more or less) lines from MongoDB using the ODBC connector. Let me explain: I use the lastest release of MongoDB 3...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Lydia.

    Indeed, I found the solution. And it is related to character encoding.

    MySQL provides 2 ODBC drivers, ANSI driver and the Unicode driver. In the MongoDB documentiation, they advise to use the ANSI driver, but this is what provoques the error.

    It seems to work fine with the Unicode Driver.

     

    Thanks for your answer!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Lydia.

Indeed, I found the solution. And it is related to character encoding.

MySQL provides 2 ODBC drivers, ANSI driver and the Unicode driver. In the MongoDB documentiation, they advise to use the ANSI driver, but this is what provoques the error.

It seems to work fine with the Unicode Driver.

 

Thanks for your answer!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

Glad to hear the issue is solved, you can accept your reply as answer to close this thread.

Regards,
Lydia