On Sun, Sep 26, 2010 at 12:37 PM, Ralph Schindler <[email protected]> wrote: > On 9/24/10 5:06 PM, robert mena wrote: >> >> Hi, >> >> I am about to start a new project that will involve access a Microsoft Sql >> server 2005 (if I recall correctly). Since I plan to do it using Zend_Db >> I'd like to know if there are any know problems, limitations or special >> points that I should be aware of while using the driver from zend_db. >> > > In the past 1.5 years, we've added support for Sql Server 2005+ via the > Micrsoft driver "Sqlsrv". > > More information on that here: > http://msdn.microsoft.com/en-us/library/ee229551%28v=SQL.10%29.aspx > > This is a stable & production ready driver that utilizes the Microsoft > Native Client to communicate from PHP to SQL Server. Of course, I assume > that your program will be running on PHP on windows talking to an SQL > Server. > > The driver is available in Zend Server and in the Microsoft Web Tools > Platform installer. > > If you are planning on running the application from a *nix server, talking > to MS SQL Server, then things will get a bit hairier. > > -ralph >
In my experience, that is the best option available for PHP development on Windows. PDO and MSSQL both fall short. There are still a few things that could probably be rounded out with Zend_Db_Adapter_Sqlsrv, but it works so well for me that it hasn't been worth the time to consider fixes or enhancements. I can't speak to *nix/PHP/SQL Server. Andrew
