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.
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.
The currently available pre-built DLL is using FreeTDS version 0.64,
the latest available is 0.82, with some important fixes in.
I nearly got the extension to compile but never cracked it fully
before time ran out.
In any case, good luck!
Jason
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
