Setup pyodbc for connecting mssql (with freeTDS)

@Windows

1. pip install pyodbc
2.  Install Windows ODBC driver: https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-2016

@Linux (Ubuntu-base)
1. freeTDS install using apt

apt-get install freetds-dev freetds-bin
apt-get install tdsodbc

• Explanation
  
  • tdsodbc => /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
  • freetds-dev freetds-bin => /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so and etc files

2.  edit or add in /etc/odbcinst.ini

[FreeTDS]
Description = FreeTDS ODBC Driver
Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so
FileUsage = 1
CPTimeout =
CPReuse =

• Example code:
  

  import pyodbc
  
  connection_string = (
      'DRIVER={FreeTDS};'
      'SERVER=1.2.3.4;'
      'PORT=1433;'
      'DATABASE=mydbname;'
      'UID=myuser;'
      'PWD=password;'
      'TDS_Version=7.3;'
  #    'Encrypt=no;TrustServerCertificate=yes;Trusted_Connection=no;'
  )
  
  connection = pyodbc.connect(connection_string)
  
  cursor = connection.cursor()
  
  cursor.execute('SELECT TOP 3 * FROM MY_TABLE;')
  
  for row in cursor:
      print(row)
  
  cursor.close()
  connection.close()