FreeTDS for Windows (optional)
================================
First download the right version of the lib for your version of PHP.
PHP 5.1.x
http://kromann.info/php5_1-Release_TS/php_dblib.dll
PHP 5.2.x
http://kromann.info/php5_2-Release_TS/php_dblib.dll
PHP 6.x
http://kromann.info/php6-Release_TS/php_dblib.dll
Place the .dll in the PHP extensions directory (extension_dir in php.ini)
Here are my php.ini settings:
magic_quotes_gpc = Off or
magic_quotes_gpc = On and magic_quotes_sybase = On
;extension=php_mssql.dll
extension=php_dblib.dll
; Valid range 0 - 2147483647. Default = 4096.
mssql.textlimit = 20971520
; Valid range 0 - 2147483647. Default = 4096.
mssql.textsize = 20971520
; Use NT authentication when connecting to the server
mssql.secure_connection = Off
You will also need to create c:\freetds.conf
[global]
host = 127.0.0.1
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520