Forum Discussion
ODBC Problem with mongoDB BI connector (MySQL)
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,
The above error is related to collation on MongoDB, what is the collation of your query? Do you have any foreign characters in the MongoDB data source?
Regards,
Lydia
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!
I'm able to connect to MongoDB, but while browsing through the tables in "Navigator" it is throwing the below error message:
DataSource.Error: ODBC: ERROR [HY000] [MySQL][ODBC 1.2(w) Driver][mysqld-5.7.12 mongosqld v2.12.0]Unknown database ''
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=B1 Unicode DSN
OdbcErrors=TableTried with both drivers ANSI and Unicode. Kindly help.
Anonymous,
Glad to hear the issue is solved, you can accept your reply as answer to close this thread.
Regards,
LydiaI had almost the same error and switching to a Unicode DSN also worked for me.