Errors in adding a MongoDB connection

[jrca025]

I have a MongoDB on my local machine without authentication. qstudio is requiring it

[ryanhamilton]

Hi @jrca025
I tried quite a few different combinations but none worked. Even once connected i was getting:
Command failed with error 59 sqlGetResultSchema

Looking at the driver page https://github.com/mongodb/mongo-jdbc-driver it says:

The MongoDB Atlas SQL JDBC Driver provides SQL connectivity to [MongoDB Atlas](https://www.mongodb.com/atlas) for client applications developed in Java.
See the [Atlas SQL Documentation](https://www.mongodb.com/docs/datalake/admin/query-with-sql/) for more information.

MongoDB Atlas SQL JDBC Driver - I guess they only want to provide JDBC access to Atlas users :(

I had a look at alternatives but they don't seem great either. Unsure what to do.
Is there another database tool you have seen solve this well?

[ericschmar]

I'll tag on here to say that a similar issue persists with using the Mongo Driver for Azure Cosmos DB. Using either a connection string (in the jdbc format) or manually entering everything times out for both options.