我尝试连接到MSSQL数据库使用Freetds,unixODBC在覆盆子pi4。以下是我的设置。
[fred]
host = 109.*.*.* # Remote Sql Server's IP addr
port = 1433 # this is default
tds version = 7.4 # this is by the time i post this
client charset =UTF-8
[test]
Driver = FreeTDS
Description = MSSQL Server
Trace = No
Server = fred # IP or host name of the Sql Server
Port = 1433 # This is default
TDS_Version = 7.4
[FreeTDS]
Description=FreeTDS Driver
Driver=/usr/lib/arm-linux-gnueabihf/odbc/libtdsodbc.so
Setup=/usr/lib/arm-linux-gnueabihf/odbc/libtdsS.so
UsageCount=1
我已经使用tsql-H IP-U用户名-P密码进行了测试,但错误仍然存在。我还安装了pyodbc。我正在尝试从PI连接到MS SQL Server Management Studio。有没有人能建议我成功连接到数据库?我很感激所有的方法。
暂无答案!
目前还没有任何答案,快来回答吧!