Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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: http://blogs.msdn.com/brian_swan/archive/2010/03/08/mssql-vs-sqlsrv-what-s-the-difference-part-1.aspx.

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

Hope that helps.

-Brian

share|improve this answer

Your Answer

 
discard

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.