Hi, I am trying to open a connection between a PHP page and MSSQL Server 2005 (as opposed to MySQL).

I found a tool online that seems to accomplish this called "FreeTDS" (I'm new and can't post links so you'll need to Google it, but it's easy enough to find!)

However, I get conflicting messages on this site as to whether the program supports SQL Server 2005.

Has anyone worked with this program and had success establishing a connection with MSSQL Server 2005?

Thanks so much, I really appreciate it.


Ned

PHP has support for MSSQL Server 2005.

Take a look at: http://us3.php.net/function.mssql-connect

Thanks!

Do you have any idea why people would be using these tools, then?

FreeTDS
ODBTP

Thanks,

Ned

It has been my understanding that the mssql function built into php has some issues with certain things that are not affected with FreeTDS.