MongoDB Connection to WB (local)
Hello, Experts,
I am trying to connect MongoDB living on a host machine on our network with WorkBench. I went through the steps advised by the MongoDB doc site saying I need to install a MongoDB ODBC driver (v1.2). Installed that and got it configured.
I have installed MongoDB Compass (client tool) and have successfully connected to the localhost MongoDB using no creds and port 27117. When I went in and tried to map them to Workbench the same way I kept on getting an error like the one below. I have attached a screenshot of how I set up the connection. Am I doing something wrong that the data does not connect and keeps erroring out?
ERROR [08S01] [MySQL][ODBC 1.2(w) Driver]Lost connection to MySQL server at 'waiting for initial communication packet', system error: 10060
Thanks!
Comments
-
Hi Isaiah
There are many things that could be causing this issue. Is the workbench install on the same server? if not is the Mongo database set to allow remote connections? If Remote does the user have remote privileges?
Also, you may have more success using the Mongo connector. the documentation for this connector is here;
Jarvis
0
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 137 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 52 Domo Everywhere
- 2K Charting
- 997 Ideas Exchange
- 898 Connectors
- 236 Workbench
- 342 APIs
- 76 Apps
- 19 Governance & Productivity
- 233 Use Cases & Best Practices
- 49 News
- 473 Onboarding
- 572 日本支部