PHP 5.3 on Windows and the SQL Server PHP Driver v1.0 are NOT Compatible

We are really excited about the progress of PHP 5.3 release.  This is a milestone release for PHP on Windows as libraries are being brought up to date, PHP Core developers can use the Visual Studio 9 compiler and performance will be greatly improved.

Unfortunately, the current SQL Server Driver for PHP v1.0 does not support PHP 5.3 and will cause IIS to crash.  You will end up seeing something like this.

HTTP Error 500.0 – Internal Server Error

C:\php\php-cgi.exe – The FastCGI process exited unexpectedly 

Followed by a Microsoft Windows error box.

CGI / FastCGI stopped working and was closed.

The dev team responsible for the SQL Server Driver for PHP is hard at work on v1.1 which will support PHP 5.3.  Please add their blog to your favorite RSS reader http://blogs.msdn.com/sqlphp.

SQL Server Driver for PHP Requires the SQL Server 2005 ODBC Driver

I was banging my head against a wall for a while today trying to track down a issue that wasn’t letting my PHP 5.2.8 app do a basic connection to SQL Server 2008.  I kept getting the following error.

SQLSTATE: IM002
message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I have SQL Server 2008 Express installed on my Windows Server 2008 workstation so I didn’t think I would have any issues like this.  To fix it all I had to do was install the SQL Server 2005 ODBC Driver from here which is part of the Microsoft SQL Server Native Client.

Talking to the PM for our driver it sounds like the next version will have a more explicit error making this much easier to diagnose.