#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    95
    Rep Power
    11

    Connecting to MSSQL: JDBC vs. ODBC


    I want to have my PHP client that exist on a Linux server to query a MSSQL database.

    I have the option of connecting to the database either with JDBC or ODBC.

    My question is, which option is the best concerning:
    - stability and availability of free/open source drivers for Linux/PHP
    - speed/reliability of connection
    - ease of setup & use

    I just want to get some opinions, so that I don't need to try both out if one of the options is obviously better than the other.
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    Using JDBC from Php seems a bit odd, ODBC from Linux to MSSQL with FreeTDS works and is well documented (try Google).

IMN logo majestic logo threadwatch logo seochat tools logo