我正在尝试使用 Python 建立 jTDS 连接。谁能帮我完成这个任务吗?
在 SQL Server 中,我通常使用以下连接字符串进行连接:
jdbc:jtds:sqlserver://DBServer:port/DBInstance;useNTLMv2=true;domain=Domain
我正在尝试在 Python 中执行以下操作:
import pyodbc
conn = pyodbc.connect('Driver={SQL Server};'
'Server=DBName,port;'
'Database=database;'
'Truster_Connection=yes;'
'uid=user;'
'pwd=password;'
)
cursor = conn.cursor()
cursor.execute('SELECT * from Table')
for row in cursor:
print(row)
Error:
pyodbc.InterfaceError: ('28000', "[28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'USER'. (18456) (SQLDriverConnect); [28000] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0); [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'USER'. (18456); [28000] [Microsoft][ODBC SQL Server Driver]Invalid connection string attribute (0)"))
如果您专门尝试使用 jTDS 而不是 ODBC 连接到 MS SQL Server,那么您可以使用 jaydebeapi python 包。
请参阅以下代码(Python 3):
import sys
import jaydebeapi
def main():
try:
# jTDS Driver.
driver_name = "net.sourceforge.jtds.jdbc.Driver"
# jTDS Connection string.
connection_url = "jdbc:jtds:sqlserver://<server_hostname>:<port>/<database_name>"
# jTDS Connection properties.
# Some additional connection properties you may want to use
# "domain": "<domain>"
# "ssl": "require"
# "useNTLMv2": "true"
# See the FAQ for details http://jtds.sourceforge.net/faq.html
connection_properties = {
"user": "username",
"password": "password",
}
# Path to jTDS Jar
jar_path = "<path_to>\\jtds-1.3.1.jar"
# Establish connection.
connection = jaydebeapi.connect(driver_name, connection_url, connection_properties, jar_path)
cursor = connection.cursor()
# Execute test query.
cursor.execute("select 1 as test_connection")
res = cursor.fetchall()
if res:
print(str(res)) # Should print [(1,)]
except Exception as err:
print(str(err))
if __name__ == "__main__":
sys.exit(main())
在此之前,您需要完成以下工作:
- 从以下位置下载并安装 JDK/JREhere
- pip install jaydebeapi 或从以下位置下载here
- 从以下位置下载 jtdshere
- 更新connection_url、connection_properties、jar_path。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)