Debian Jessie PHP access SQL Server Database

Use FreeTDS and unixODBC for this task.

1. Installation of the freetds packages with apt-get




apt-get install freetds-common freetds-bin unixodbc php5-sybase
service apache2 restart





2. Add configuration into /etc/freetds/freetds.conf




# Kinamo SQL Server
[test_sqlserver]
  host = milliondollarserver.com
  port = 1433
  tds version = 8.0