Database classes for SQL Server 2005 and SQL Server 2008 (using php_sqlsrv.dll from the Microsoft Data Programmability t

[eluser]_jon[/eluser]
Hello all.

We have (over the last 18 months) written a large web application for the insurance market that is under heavy load. We found that the current driver (php_mssql.dll) is very buggy and inefficient under load, and refuses to connect to the database 50% of the time, despite all the details being correct. Other people have also had this issue. So, we tried out the new beta driver from Microsoft and wrote a driver for our API. As the front end of the site is supplied with the CodeIgniter framework, we also wrote a CodeIgniter driver for MSSQL using the new driver.



Blog & information about the new driver (download link)



Hopefully this will help one person! If you need to download the DLL for this new driver, you can find it at:
http://www.microsoft.com/downloads/detai...laylang=en


If you find any problems with it, please let me know in this post and ill sort them out the best I can. Apologies if you find anything that is scrappy, it was written in a rush!