[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