On Tue, Sep 23, 2008 at 11:06 AM, Jason <networkadmin@xxxxxxxxxxxx> wrote: > At 15:49 23/09/2008, you wrote: >> >> On Tue, Sep 23, 2008 at 10:17 AM, Jason <networkadmin@xxxxxxxxxxxx> wrote: >> > At 15:05 23/09/2008, you wrote: >> > >> > [snip] >> > >> >> So, I'm left wondering what that leaves. Is there anything currently >> >> available that could be considered stable for a production >> >> environment, supports parameterized queries and is not slated to be >> >> mothballed in the near future? >> > >> > Have you considered the MS "official" php extension available from >> > http://www.microsoft.com/sql/technologies/php/default.mspx ? >> > >> > We've played with it here and it seems quite good. It requires SQL 2005 >> > or >> > above, so it may not be good for you. YMMV. >> > >> > I have to admit we've yet to seriously load-test it, but at least we >> > finally >> > have Unicode support from PHP to MSSQL. :) >> > >> > HTH >> > J >> > >> >> I wasn't aware of an official MS version, but unfortunately, we're one >> of those shops that is still running 2000 since a couple of our more >> obscure commercial vendor products don't support 2005 (at least not >> the version we have). > > We have done limited testing here, but it may be that only the PHP server > requires the 2005 (ODBC driver) components. Could be worth investigating. Hey - if it gets me back to developing apps and away from working with database libraries and abstractions, I'm all for it. I'd like to upgrade, but one of the concerns we had was the possibility that we wouldn't be able to connect past 2005. One of our concerns with the old MSSQL functions is that we really don't want to have to rewrite stuff when we do upgrade the database. > There is also "php_dblib.dll" from http://kromann.info/php.php, but compile > support for win32 is limited. This replaces the mssql_* functions with > versions that use the FreeTDS dblib driver rather than the old MS-based one. > In theory it works OK and supports unicode, but we've seen reliability > issues when under load and/or running certain queries. You're really building my confidence now. :-) > The currently available pre-built DLL is using FreeTDS version 0.64, the > latest available is 0.82, with some important fixes in. I had heard there were issues with FreeTDS (perhaps only on Windows) and that is also wasn't quite production quality. > I nearly got the extension to compile but never cracked it fully before time > ran out. Yeah - time is definitely a factor. I know since we're on Windows there is always COM to hook into ADO, but that just seems sticky. It's starting to seem like maybe I need to brush up on .NET. :-/ > In any case, good luck! > > Jason Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
