by Peter Galli on April 19, 2010 04:08pm

Microsoft today announced at DrupalCon 2010 the release of a Community Technology Preview of the new SQL Server Driver for PHP 2.0 with support for PHP Data Objects.

This is a new technical bridge for PHP developers that will make it less complex for them to target multiple databases, and make it easier for PHP applications like the upcoming Drupal 7 release to interoperate smoothly with SQL Server 2005 and all later versions.

The CTP release gives developers the chance to check out the tool and provide feedback ahead of the release of the final version in the second half of this year. 

Drupal is an open source Content Management System written in PHP software. In order for SQL Server to work with Drupal 7, it needs a PDO driver and Drupal Abstraction Layer for that database. 

Microsoft is providing the PDO driver for SQL 2005 and later, and the Commerce Guys, a company that provides ecommerce solutions with Drupal, is releasing the Drupal Database Abstraction Layer for SQL Server 2005 and later. 

The Commerce Guys presented at DrupalCon 2010 a beta version of Drupal 7 running on SQL Server using this new SQL Server driver with PDO.

Being able to access SQL Server through PDO will benefit PHP developers by reducing the complexity of targeting multiple databases and will make it easier to take advantage of SQL Server features such as business intelligence & reporting as well as SQL Azure features like exposing OData feeds.

For more technical information on this latest technical bridge, read Ashay Chaudhary's blog post, as well as the SQL Server Driver for PHP team blog.

This latest initiative is just one of many that underscore Microsoft's broad commitment to openness through expanding choice and opportunity for customers, partners and developers.