ODBC DSN cannot find database

Abhijit_Sahay · 2022-09-05T02:39:24.348Z

I have started mongosqld with --sampleNamespaces mydb.mycollection and I see this message which seems to indicate that it’s recognized -

I SCHEMA [sampler] mapped schema for 1 namespace: “mydb” (1): [“mycollection”]

but when I try to create a system DSN with database “mydb”, I get an error:

handshake error: ERROR 1043 (08S01): error using database mydb: ERROR 1049 (42000): Unknown database ‘mydb’.

If I leave the database blank when creating the DSN, it creates the DSN but when I try to use it in Power BI, I see only “INFORMATION_SCHEMA” and “mysql” under the DSN and not “mydb”.

Thanks in anticipation for any help.

Chirag_Hathiari · 2023-01-27T15:59:39.660Z

Hi Abhijit_Sahay … Did you find a solution to this issue? I am facing the same.

Abhijit_Sahay · 2023-01-27T16:48:11.983Z

Unfortunately I have not been able to get aroudnd it.

Chirag_Hathiari · 2023-01-31T13:48:27.689Z

My issue got resolved. I had to uninstall and reinstall
Visual C++ Redistributable for Visual Studio 2015… It was earlier showing a version of 2015-2022. Let me know if that works.

sarkan20 · 2025-03-19T11:02:39.892Z

Hi, my solution is to create a role with listDatabases permission. More than that, the driver GUI itself does listDatabases when you select databases in the interface. like this: db.createRole({
role: “bi_list_role”,
privileges: [
{
resource: { db: “”, collection: “” },
actions: [ “find”, “listDatabases” ]
}
],
roles:
})