Forum Discussion
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...
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!
In my case, and I hope this helps also other users, I fixed this errore by changing this setting in the connection panel.
It works both wih unicode and ansi drivers.