Mongodb - 通过 ODBC 连接 [英] Mongodb - connect through ODBC

问题描述

我正在尝试使用 Windows 客户端安装的 MongoDB 提供的 ODBC 驱动程序来实现与 MongoDB 服务器的连接.当我填写 DSN 属性时，它会在点击测试按钮时冻结.

I am trying to achieve a connection to MongoDB server using the delivered ODBC Driver from MongoDB installed by windows client side. When I fill in the DSN properties it freeze on Test button hit.

然后我尝试通过在客户端安装 MongoDB BI 连接器并声明 mongodbsqld 服务来遵循该过程，但没有帮助.

I tried then to follow that procedure by installing the MongoDB BI Connector by client side and declaring the mongodbsqld service but didn't help.

https://www.sqlshack.com/import-data-from-mongodb-to-sql-server-using-ssis/

我有免费的 MongoDB 社区版Mongodb shell 版本 - 4.0.11Mongodb 服务器版本 - 4.0.20ODBC 驱动程序:1.4.2

I have the Free MongoDB Community version Mongodb shell version - 4.0.11 Mongodb server version - 4.0.20 ODBC Driver: 1.4.2

我试用了 Progress 开发的商业驱动程序，它就像一个魅力，但几天后就会过期.您有一些提示可以正确建立此 ODBC 连接吗?

I tried a commercial driver developed by Progress, it works like a charm but expire in few days. Do you have some tips to establish this ODBC connection properly ?

谢谢 &问候，手动

Thanks & Regards, Manu

推荐答案

开放MongoDB ODBC 驱动程序 仅适用于 MongoDB 云服务:

The open MongoDB ODBC Driver works only with MongoDB Cloud service:

BI 连接器仅适用于 Atlas M10 及更高版本.

The BI Connector is only available on Atlas M10 instances and above.

我猜你得找第三方驱动了.

I guess you have to go for a third party driver.

除了Progress我也发现了

• CData:https://www.cdata.com/drivers/mongodb/odbc/
• devart:https://www.devart.com/odbc/mongodb/
• EasySoft:https://www.easysoft.com/products/data_access/odbc-mongodb-driver/index.html
• 辛巴:https://www.simba.com/drivers/mongodb-odbc-jdbc/

但它们都不是免费的，我猜你必须花一些钱.

But none of them is for free, you have to spend some money I guess.

这篇关于Mongodb - 通过 ODBC 连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！