12:01 PM by Christian Koch

Filed under php

Last modified 12:03 PM

Short introduction on how to establish a MS SQL Server connection with PHP on Debian.

Install FreeTDS on Debian for PHP ODBC. Login as root.

First check if PHP’s ODBC extension is installed. If not install it with:

apt-get install php5-odbc

Install FreeTDS ODBC:

apt-get install tdsodbc

Don’t forget to restart your Apache after installing additional PHP extensions.

/etc/init.d/apache restart

Now we can test a connection to MS SQL Server.

$con = odbc_connect('Driver=FreeTDS;Server=IPTOMSSQLSERVER;Port=1433;Database=MyDatabase', 'databaseUser', 'databasePassword') or die("ups cannot connect LALA");

// do your stuff


That’s it HF


Related Articles


                                                1. flo

                                                  Hey, theres some more config to do!
                                                  if u speak german, check this:

                                                  1. check /etc/odbc.ini
                                                  data source names (DSN) must be added here:

                                                  Driver = FreeTDS
                                                  Description = MSSQL Test
                                                  Trace = Yes
                                                  TraceFile = /tmp/sql.log
                                                  ForceTrace = yes
                                                  Server =
                                                  Port = 1433
                                                  Database = DatabaseName

                                                  2. check /etc/odbcinst.ini
                                                  Path to library must fit:

                                                  Description = MSSQL DB
                                                  Driver = /usr/lib/odbc/
                                                  UsageCount = 1

                                                  Thursday November 26th, 2009 - 05:15 PM – Reply

                                                  • 1. Therefor the long DSN: Driver=FreeTDS;Server=IPTOMSSQLSERVER;Port=1433;Database=MyDatabase

                                                    Your way you just need to connect like this:

                                                    $con = odbc_connect('MeinMSSQLServer', 'databaseUser', 'databasePassword') or die("ups cannot connect LALA");

                                                    2. /etc/odbcinst.ini should hopefully be installed along with apt-get install.

                                                    THX 4 your reply

                                                    Thursday November 26th, 2009 - 05:34 PM – Reply

                                                2. Greg

                                                  Thank’s for this post (and comments!). it was very useful.

                                                  Monday January 18th, 2010 - 01:34 PM – Reply

                                                Leave a Comment