This past week Inter-Op at Microsoft hit a new milestone by announcing the Microsoft Drivers for PHP for SQL Server 2.0. The major highlight of this release is the addition of the PDO_SQLSRV driver, which adds support for PHP Data Objects (PDO) and simplifies multiple database support for PHP developers. Source code published on Codeplex under the Apache 2.0 license. Another big feature in addition to accessing SQL Server, both drivers (SQLSRV and PDO_SQLSRV) also enable PHP developers to easily connect to and use Microsoft's cloud database offering, SQL Azure, and enjoy the benefits of a reliable and scalable relational database in the cloud.

Our engagement with the PHP community has been among our best. Thanks to the feedback from our partners and PHP developers, we are very excited to achieve this high level of interoperability with Microsoft’s SQL Server.

Also a new tidbit is the way we architected this release to make sure PHP developers are free to select the driver of their choice, using SQLSRV API (SQLSRV driver) or the new PDO API (PDO_SQLSRV driver) for accessing SQL Server or SQL Azure.

New architecture

While the major focus of this release was the PDO_SQLSRV driver, we took this opportunity to re-architect our code create a core functional layer so that we can offer the same functionality and consistency in both drivers (SQLSRV and PDO_SQLSRV). This new architecture enables us to add new features easily to both drivers.

NewArchi

You can read more about this and get code snippets from the SQL PHP blog…

Inter-op is great!

-Mithun Dhar