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
5 years ago

I'm facing the exact same error that MuthuLakshmi mentioned in the above comments and I've tried both the drivers still facing the same issue. I've wasted 2 days and found nothing, can somebody help?

 

Muthulakshmi-

"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=Table

 

Tried with both drivers ANSI and Unicode. Kindly help."

 

TIA

Varun