CodeIgniter 2.02, PHP 5.36, Apache 2, MS SQL Server 2008 on Windows

[eluser]tedroche[/eluser]
Although the code is a bit arcane, the solution in the thread http://ellislab.com/forums/viewthread/160626/ seemed to provide a workable LIMIT command to support LIMIT X,Y as well as LIMIT X MySQL compatibility.

The 32-bit/64-bit issue had us stumped for a while, as the Apache error messages were arcane. We found a few threads on MS support forums. Apparently, MS developers don't consider the 64-bit Apache/PHP API stable enough yet. We were running a 64-bit database on a 64-bit server, so thought that was the way to avoid incompatibility. Apparently not.

We started with the CI mssql driver, and have been debugging issues as they came along. I will say, the MS driver does come with a well-documented API and sample code.

As for working in WAMP, well, that wasn't my first choice, either, and I'd generally discourage clients from that solution for the same reasons we've run into: limited support due to the unusual combination of tools, undiscovered incompatibilities, and the general cost, expense and overhead of supporting a Windows server.