PHP PDO MSSQL in Xampp?

Question

Ok, here is my situation:

I have installed Xampp (v1.8.2) on my server to publish a webprogram i am making (php, html) for some people in my network. For the first time i have to connect to MSSQL 2008 server instead of MYSQL (phpmyadmin). over the past years i've always worked with the MySQL api and a little with MySQLi. I have read over the internet i must use PDO so i can succesfully connect to the MS database.

As i can see PDO is not installed/activated. When i look into the PHP.ini file the only thing i see is:

extension=php_mssql.dll

but no

extension=php_pdo_mssql.dll

i've read allot (i.e that i have to install soms dll files, that i have to install apache, PHP, PDO manually)

What is the good way to make a successful connection to my mssql database?

Thanks

Answer 1

Though using PDO is a nice idea and will save you time, you can use Mssql extension. If you really want to use PDO_MSSQL, you should allow it in PHP.ini (the second string you posted is the right way to do that), but you should also have php_pdo_mssql.dll in your PHP's extension directory. You can find that file here