PHP on Linux / MS SQL

wehrle · #1 (**permalink**) 10-25-07, 12:02

What is the best practice to be able to connect to a MS SQL 200/2005 database via PHP on Linux? I am aware of freeTDS, but uncertain if that is the best or common practice.

Thanks.

aschk · #2 (**permalink**) 10-25-07, 13:11

Can I assume that the Linux servers contains Apache + PHP and that the MSSQL database resides on a windows machine?

Do you need a browser interface to the database or are you building a site that requires the ability to connect to and execute MSSQL queries?

If you're looking for a web interface to the MSSQL database then consider this : http://www.microsoft.com/downloads/d...displaylang=en

If you are however looking to create a PHP application that connects to MSSQL then a good starting point will be here : http://uk3.php.net/function.mssql-connect
Bear in mind with this latter option your MSSQL server needs to allow external connections. I'm not 100% on whether this on by default, knowing M$, probably. Security has never been their biggest priority.

wehrle · #3 (**permalink**) 10-25-07, 21:49

Is there any way to use mssql_connect without installing freeTDS?
Thanks.