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 Connector并声明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 ?

感谢&问候，Manu

Thanks & Regards, Manu

推荐答案

打开的

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.

除了进度我也发现

• 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
• Simba: 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屋！