qstudio Errors in adding a MongoDB connection

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

Jun 04 '24 11:06 jrca025

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?

Jun 04 '24 12:06 ryanhamilton

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.

Jun 04 '24 13:06 ericschmar