PHP – Connecting to Microsoft SQL Server (Debian/Ubuntu)

Here is how to get PHP 5.2 on Linux (specifically Debian/Ubuntu) talking to a Microsoft SQL Server database:

1. Install FreeTDS and the PHP MS SQL extension

Note: That is correct, the MS SQL extension is in the “php5-sybase” package.

2. Restart Apache

3. Test FreeTDS

If it connects, it’s working.

Note: If you try to SELECT an NTEXT or NVARCHAR column you may get an error saying “Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier”. That is expected and will be fixed in the next step.

4. Configure FreeTDS

Add this at the end of the file:

5. Test FreeTDS using server name

If you try to select something, you shouldn’t get the Unicode error now – because you specified “tds version = 8.0″.

6. Test in PHP