December 10th, 2003, 06:52 PM
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.
December 11th, 2003, 03:29 AM
Using JDBC from Php seems a bit odd, ODBC from Linux to MSSQL with FreeTDS works and is well documented (try Google).