Cannot connect to MongoDB .7.0.5 with Bi Connector 2.14.22 / ODBC 1.4.5 on windows server 22

Simon_Working · 2025-03-07T14:33:25.586Z

I get this error when trying to test the ODBC connection: MongoDB version is 7.0.5 but version >= 4.0 required

I’m using windows server 2022, MongoDB 7.0.5, Bi Connector 2.14.22 and Mongo connector ODBC 1.4.5.

Any ideas what’s wrong, how to achieve this?

Alexi_Antonino · 2025-03-07T14:51:46.099Z

Hello @Simon_Working and welcome to the community. My name is Alexi and I am the product manager for the BI Connector.
Are you saying you receive an error that says: “MongoDB version is 7.0.5 but version >= 4.0 required” ?
Can you tell me when/where you get the error? Perhaps a screenshot would give me more details.
Is this an on premise database or cloud/Altas db?
And it seems like you’re running the latest versions of the BI Connector and the ODBC driver, but please also verify you have installed the correct platform/OS for your machine.

Looking forward to understanding more about your issue.
Best,
Alexi

Simon_Working · 2025-03-10T13:42:04.835Z

Hi,

I fixed this issue by updating this mongodb config option from 2.5 to versionCompatibility: “7.0”

So, I can now connect using a linked server (Connector for Bi/ODBC) in SQL Server studio, but i can’t get any table data, it returns this when scripting a basic select:

– [MONGODB-EPOEQA].[epoeqa]…[assessments] contains no columns that can be selected or the current user does not have permissions on that object.
GO

This collection Assessments does exist, and does contain documents, all with the same schema.

any idea what I’m missing?

the user im connecting with has this role profile:

readAssessments

{privileges:[
{resource:{db:“epoeqa”,collection:“assessments”}, actions:[“find”,“listIndexes”]},
{resource:{db:“epoeqa”,collection:“”}, actions: [“listCollections”]}],roles:})

Simon_Working · 2025-03-10T13:42:13.622Z

Hi Alexi, thanks for the reply.
The DB is a mongo 7.0.5 community edition database, and I’m trying to create an ODBC to allow sql querying. The mongoDB is running on a windows 2022 server. I have the bi connector running (2.14.22) and the odbc installed (1.4.5) and configured but on click Test on the windows odbc module, it says: MongoDB version is 7.0.5 but version >= 4.0 required.

bi connector itself reports:

2025-03-10T10:24:15.606+1300 I NETWORK [conn2] connection accepted from 127.0.0.1:57017 #2 (1 connection now open)
2025-03-10T10:24:15.680+1300 E NETWORK [conn2] handshake error: ERROR 1043 (08S01): MongoDB version is 7.0.5 but version >= 4.0 required
2025-03-10T10:24:15.680+1300 I NETWORK [conn2] end connection 127.0.0.1:57017 (0 connections now open)

Screenshot from 2025-03-10 10-28-26445×641 36 KB