PHP Update Finally Depreciates PHP MSSQL driver

Sharing is Caring

A couple of weeks ago, I noticed there was a new version of PHP out than I was using for my development environment (WAMP) and decided that I should take the time and upgrade the development environment and perhaps even the production environment after retesting my web applications.

The actual upgrade process itself was simple, but PHP 5.3 deprecates the MSSQL Extension. Instead you must now use at least the SQL Server Driver for PHP v1.1 which is of course Windows only and requires any installation of Windows preceding Windows 2000. You need to ensure you have installed the SQL Server 2008 Native Client. Making the change wasn’t overly difficult because I took the upfront time and wrote a very simple Database Access Layer because I assumed something may change in the future (driver, database, etc.)

The biggest advantage of the change is being able to better take advantage of Microsoft SQL Server features that probably made you choose to use SQL Server in the first place.In addition, Microsoft has made the source code available. I’m really excited to hear a new version will be out soon that will allow PHP programmers to use PHP Data Objects (PDO) with SQL Server!

Sharing is Caring

Brian is a software architect and technology leader living in Niagara Falls with 13+ years of development experience. He is passionate about automation, business process re-engineering, and building a better tomorrow.

Brian is a proud father of four: two boys, and two girls and has been happily married to Crystal for more than ten years. From time to time, Brian may post about his faith, his family, and definitely about technology.

Comments are closed.