Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We're migrating an LAOP server to Win 2k8 IIS7 MSSQL and PHP (WIMP?) at work, and I'm using the opportunity to clean up the PHP. Currently it doesn't use PDO, and I'd like to rewrite the PHP to use that instead.

Challenge is, I don't know much about MSSQL and PHP deployment on Windows. The official MSSQL PDO object is experimental / depreicated and recommends PDO-ODBC. Microsoft just announced a driver supporting PDO. Is there no other PDO driver? How does SQLSRV contrast with PDO-ODBC?

share|improve this question
up vote 1 down vote accepted

The sqlsrv driver is a thin layer on top of Microsofts implementation of ODBC. The PDO-SQLSRV driver is just an abstraction of the sqlsrv driver. Both the sqlsrv and PDO abstraction are supported and maintained by Microsoft. If you are interested, you can read more about the sqlsrv driver here:

Admittedly, I don't know much about the PDO-ODBC driver.

Hope that helps.


share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.