Goal: Connect to MSSQL using FreeTDS / ODBC in Python.
Host: Ubuntu 11.10 x86_64
Install:
sudo apt-get install freetds-dev freetds-bin unixodbc-dev tdsodbc
pip install pyodbc sqlalchemy
In /etc/odbcinst.ini:
[FreeTDS]
Description=FreeTDS Driver
Driver=/usr/lib/odbc/libtdsodbc.so
Setup=/usr/lib/odbc/libtdsS.so
I'm a arch linux python pyodbc user,
a few days ago my pydobc connection stop working
pyodbc.connect('DRIVER=FreeTDS;SERVER=192.168.0.108;PORT=1433;DATABASE=ina;UID=sa;PWD=...')
with message
pyodbc.OperationalError: ('08001', '[08001] [FreeTDS][SQL Server]Unable to connect to data source (0) (SQLDriverConnect)')
I keep my arch updated almost daily, and run pipenv update
using python 3.8.1
pyodbc 4.0.28
I have open connection to the server I can "telnet 192.168.0.108 1433" and get response fom mssql.
what is happening?
what changed?