在Windows上从python连接到odbc的常用方法? [英] Common ways to connect to odbc from python on windows?
问题描述
我应该使用哪个库从Windows上的python连接到odbc?涉及到odbc时,是否有pywin32的好选择?
What library should I use to connect to odbc from python on windows? Is there a good alternative for pywin32 when it comes to odbc?
我正在寻找有据可查,功能强大,维护良好等的东西. pyodbc
看起来不错-还有其他吗?
I'm looking for something well-documented, robust, actively maintained, etc. pyodbc
looks good -- are there any others?
推荐答案
您已经提出了 pyodbc ,我将与您达成一致.
You already suggested pyodbc, and I am going to agree with you.
从我的经验来看,这给了我最少的问题;我已经使用 pymssql 和
It has given me the least amount of issues in my experience; I've used pymssql and adodbapi, and when those threw exceptions/created issues, I swapped out the code and replaced it with pyodbc and it either fixed the problem, or gave better error messages so I could debug faster.
值得一提的是,我主要使用它来连接 MSSQL Server 数据库.
It's worth mentioning that I primarily use it to connect to MSSQL Server DBs.
这篇关于在Windows上从python连接到odbc的常用方法?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!