Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2005
    Posts
    103

    Unanswered: PHP on Linux / MS SQL

    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.

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    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.
    Last edited by aschk; 10-25-07 at 13:18.

  3. #3
    Join Date
    Jul 2005
    Posts
    103
    Is there any way to use mssql_connect without installing freeTDS?
    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •