Compiling PHP Question

[SilentCoder]

Hi, i want to use PDO class for mssql connection and i was wondering what configurations do i need to compile PHP with in order to use PDO classs for mssql connection, because i tried to compile with the following configurations:

--with-zlib' '--enable-pdo=shared' '--with-pdo-sqlite=shared' '--with-sqlite=shared' '--with-mssql=shared' '--with-pdo-mssql=shared'

Thank you.

 

[webizen]

you need to add option '--with-pdo-dblib' and install FreeTDS.

http://www.php.net/manual/en/ref.pdo-dblib.php

I tried everything, different configuration options for FreeTDS/PHP, different versions, etc. But the answer was one line in php.ini:

mssql.secure_connection = Off

This line, which defaults to Off, needs to be ON if you are using NT authentication:

mssql.secure_connection = On

Here is my build:

FreeTDS-0.82 configured like:
./configure --with-tdsver=8.0 --enable-msdblib --with-gnu-ld

PHP 5.2.11 configured like:
./configure --with-mssql=/usr/local --with-pdo-dblib=/usr/local [other options]