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?

link|improve this question

76% accept rate
feedback

1 Answer

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

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