Category Archives: mssql

how to install pymssql

You need to install the FreeTDS development package (freetds-dev) before trying to install pymssql with pip: $ sudo apt-get install freetds-dev and then download and install the latest version of pymssql (don’t use pip install as the version in PyPi … Continue reading

Posted in mssql, pymssql, python, Uncategorized | Leave a comment

connect to MS SQL server and Sybase from linux freetds sqsh freebcp

sudo apt-get install freetds-dev sqsh freetds-bin  cat /etc/freetds/freetds.conf  [tds1] host = 10.21.1.1 port = 1433 tds version = 7.0  sqsh -S tds1 -U id -P password -i foo.sql -o foo.out freebcp (from freetds-bin package) freebcp mydb.dbo.table out table.csv -U id … Continue reading

Posted in mssql, sqsh, sybase | Tagged | Leave a comment

Enable SQL server 2012 for TCP

Enable SQL server 2012 for TCP port 1433

Posted in mssql | Leave a comment