On Mon, Sep 27, 2010 at 2:42 PM, Andrew Ballard <[email protected]> wrote: > 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 >
I'm in that boat, using PHP on *nix and use FreeTDS to access it without a hitch. The only falldown I had so far is the size of blob fields has an incredibly low default value, if you use blobs for anything thats a couple kilobytes in size or above. Summed that one up here: http://christianriesen.com/2010/07/ms-sql-blob-truncated/ Other than that, I have not seen any troubles with it. -- Greetings, Christian Riesen http://christianriesen.com/ - My personal page http://toreas.com/ - Toreas a free fantasy novel http://gamewiki.net/ - Open Videogames Wiki
