Install everything
- Install freetds for your distribution, you can find RH packages at atrpms.net.
- Depending on your distribution you will need to install libtdsodbc
- Install php odbc extension
FreeTDS configuration
Create FreeTDS driver configuration in the file freetds.driver.template
[FreeTDS]
Description = FreeTDS
Driver = /usr/lib64/libtdsodbc.so.0
Import this config
odbcinst -i -d -f freetds.driver.template
Create ODBC Data Source in the file freetds.datasource.template
[MSSQLDB]
Driver = FreeTDS
Description = MSSQL Database
Trace = No
Server = <<server ip>>
Port = 1433
Database = <<database>>
Import it as system dcn
odbcinst -i -s -l -f freetds.datasource.template
Test the connection
isql -v MSSQLDB DBUSER DBPASS
PHP sample usage
<?php
# connect to a DSN "MSSQLDB" with a user "cheech" and password "chong"
$connect = odbc_connect("MSSQLDB", "cheech", "chong");
# query the users table for all fields
$query = "SELECT * FROM users";
# perform the query
$result = odbc_exec($connect, $query);
# print the data from the database
while(odbc_fetch_array($result))
print_r($result);
# close the connection
odbc_close($connect);
?>