创建pypyodbc连接python时出错

Question

我正在尝试使用ubuntu中的pypyodbc连接sql server中的数据库。

下面是我的代码：

import pandas as pd
import pypyodbc
host = "servername"
username = "sa"
password = "sa@12"
database = "dbname"

try:
    conn = pypyodbc.connect("DRIVER={SQL Server};SERVER=%s;UID=%s;PWD=%s;DATABASE=%s") % (host, username, password, database)
    print ("SUCCESS")
except Exception as e:
    print ("Error: " + str(e))

但我得到了这个错误。

错误：(“no 002”，“未找到IM002Driver ManagerData源名称，也未指定默认驱动程序”)

有办法解决这个问题吗？

Answer 1

这条路：

import pandas as pd
import pypyodbc
host = "servername"
username = "sa"
password = "sa@12"
database = "dbname"

try:
    conn = pypyodbc.connect(driver='{SQL Server}',server=host,UID=username,pwd=password,database=database)
    print ("SUCCESS")
except pypyodbc.Error as e:
    print (e.args[1])