ODBC DSN cannot find database

Working with Data Connectors & Integrations
1

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.

2

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

1 Like
3

Unfortunately I have not been able to get aroudnd it.

4

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.

5

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:
})