It was extremely easy accessing MongoDB server by pasting conn string into MongoDB Compass on Windows 10 but when it comes to Python or Tableau it returns errors

For Python its either timout or:

Configuration Error: The DNS query name does not exist: _mongodb._tcp.mac88stage.sui9p.mongodb.net.

from pymongo import MongoClient

# Connection URI
uri = "mongodb+srv://USERNAME:[email protected]/"

client = MongoClient(uri)

db = client.db_name

collection = db.table_name

top_10_rows = collection.find().limit(10)

for row in top_10_rows:
    print(row)

When creating DSN (following this guide: https://www.mongodb.com/docs/atlas/tutorial/create-system-dsn/)

I get Unknown MySQL Driver Host

For Tableau followed the standard guide:
https://help.tableau.com/current/pro/desktop/en-us/examples_mongodb.htm
added driver and connector into relevant folders in Tableau but getting similar errors to Python