Forum Discussion

jnberger's avatar
jnberger
New Member
8 years ago
Solved

Unknown database error when connecting to MongoDB with ODBC

Hi,   I’m trying to build a report based on data stored on local MongoDB database, with the ODBC connector.   But I’ve got the following error : DataSource.Error: ODBC: ERROR [HY000] [MySQL][ODB...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi JN.,

     

    We found the cause. We should add the Database explicitly. Please check it out.

    Unknown_database_error_when_connecting_to_Mongo_DB_with_ODBC

     

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi JN.,

 

We found the cause. We should add the Database explicitly. Please check it out.

Unknown_database_error_when_connecting_to_Mongo_DB_with_ODBC

 

 

Best Regards,

Dale

jnberger's avatar
jnberger
New Member
8 years ago

Hi Dale,

Thanks for your great help !

 

I think that there's a bug somewhere because the database was actually selected in the query :

demo_Database = Source{[Name="demo",Kind="Database"]}[Data]

 

But your workaround is fine and it works for me.

 

Best regards.

JN.