An update on our CTP2 release

It's been about two weeks since we released our CTP2 for the SQLSRV and PDO_SQLSRV drivers. While we've been actively monitoring and responding to feedback on our blog/forums, we have also been busy with the last set of "mini features" to complete our CTP2 release.

The “mini features” are limited to our installer for our Web Platform Installer (WPI) release. While our MSDN Download Center release is based on simpler IExpress technology (simple file uncompress and copy), the WPI installer is based on the Windows Installer technology – a requirement for WPI. Since WPI installs the VC6 Non-Thread Safe (NTS) version of PHP 5.2.13, our WPI release installer only installs the appropriate SQLSRV/PDO_SQLSRV drivers and, since the location of the PHP install is known, edits the php.ini file to enable the SQL Server drivers. This makes installation via WPI extremely easy even for novices.

The enhanced installer now includes two important features leveraging the capabilities offered by the Windows Installer infrastructure.

1. Upgrades: the installer now supports Upgrades, thus providing a seamless experience for installing a newer release of our driver over an older installation. Upgrades are supported from released versions of the driver only - that is, only upgrades from v1.1. v2.0 CTP1 installs are not supported due to some incompatibilities, so when the new installer detects an install of v2.0 CTP1 then the install is aborted and a failure returned. Since our recommendation for CTPs is to deploy on test systems only, we decided to keep the code simple and require manual uninstallation of v2.0 CTP1. We proactively warn the user of this pre-requisite condition in WPI when the v2.0 CTP2 option is selected, but also added the check in the installer just in case one does not notice it.
2. Repairs: the installer now supports Repairs - just in case something goes awry after the initial install/upgrade. All one has to do is go to Control Panel –> Program & Features, select the SQL Server Driver for PHP 2.0 and click the Repair button. A small feature, but most appreciated when something goes south and the Repair puts the component back into initial install state.

Now that we have completed these features for our installer, we have published our CTP2 binaries in WPI. At this time, the PHP applications supporting SQL Server published in WPI have not been updated to link to our CTP2 binaries, so one will have to install CTP2 manually after the application is installed.

So how does one install our CTP2 in WPI?
Simple. Just download/install/run WPI, select the Web Platform tab, click the Customize link in the Database section, and check off Microsoft SQL Server Driver for PHP 2.0 CTP2, then click the Install button.

Regarding the CTP2 drivers themselves, we have received positive feedback on CTP2 with only a few issues reported to date. While we continue to address these issues, the good news is that these issues were not introduced by our code re-architecture or design changes in CTP2. In addition, we have received positive responses to our design changes in PDO_SQLSRV driver. While this is certainly good news, we continue to actively monitor the forums and investigate issues reported.

We are working thru the last set of bugs and expect closure on them soon. So, this is the right time for all to download and install our CTP2 driver immediately, hammer away at them, and report failures/regressions on our forum.

 

BuzzNet Tags: PHP,SQL Server,CTP,PDO,mssql,sqlsrv,pdo_sqlsrv,WPI

Comments

• Anonymous
  June 29, 2010
  There is no VC9 support in 5.2. The WPI uses the php.net binaries which are built using VC6. Thanks for the updates btw :)

• Anonymous
  July 26, 2010
  The comment has been removed

• Anonymous
  July 26, 2010
  The comment has been removed

• Anonymous
  July 26, 2010
  The comment has been removed

• Anonymous
  July 26, 2010
  The comment has been removed