我正在建立一个在AWS EC2 Linux机器和RDS SQL服务器之间的pyodbc连接。当我使用我的本地Windows机器时,连接是有效的,并且能够编辑数据库。
我按照这个教程安装了驱动程序,但仍然遇到问题。
cat /etc/odbcinst.ini
[ODBC Driver 13 for SQL Server]
Description=Microsoft ODBC Driver 13 for SQL Server
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.1.so.9.2
UsageCount=1
[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.4.so.1.1
UsageCount=1
cat ~./odbc.ini
cat: ~./odbc.ini: No such file or directory
代码片段如下:
db = pyodbc.connect("Driver={Microsoft ODBC Driver 17 for SQL Server};"
"Server=<Server Name>;"
"Database=<DB Name>;"
"uid=<username>;pwd=<password>"
)
错误信息如下:
更新:可以使用Sqlcmd在终端查询数据库。pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'Microsoft ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)")