[freetds] PHP and MSSQL API
Casey Allen Shobe
cshobe at osss.net
Wed Mar 17 17:48:59 EST 2004
Robert Davis wrote:
> With 4.3 I noticed MSSQL now supports FreeTDS on linux. Is there a
> particular connection that is the best? Sybase, Sybase-ct, or MSSQL?
> What are any differences?
Actually, PHP has worked with FreeTDS for as long as PHP has worked with
Sybase, as it's just a drop-in replacement for the Sybase libraries. I
first used it well over a year ago.
The mssql_* functions however are _only_ for connecting to MSSQL via the
native libraries when using PHP on Windows. Sorry to say I don't know
the differences between Sybase and Sybase-CT, but Sybase is what I've
always used.
However, I've never actually used the sybase_* functions directly in
PHP, but used UnixODBC instead, so that I can use odbc_* functions with
all of the databases I might connect to. However, the conveniences of
ODBC come with a slight performance overhead (it's never been enough for
me to notice), so for that reason you may opt not to use it.
--
Casey Allen Shobe
cshobe at osss.net
More information about the FreeTDS
mailing list