Accessing Microsoft SQL Server from PHP on Ubuntu using PDO, ODBC and FreeTDS

This works for the simple query you have in your post but if you do anything more complicated odbc will segfault apache.

For instance:

<?php
try
{
$db = new PDO('odbc:Driver=FreeTDS; Server=hostname_or_ip; Port=port; Database=database_name; UID=username; PWD=password;');
}
catch(PDOException $exception)
{
die("Unable to open database.
Error message:

$exception.");
}
echo 'Successfully connected!';
$query = 'SELECT * FROM table_name WHERE table_name.COLUMN = ?';
$statement = $db->prepare($query);
$statement->bindValue(1, 'Value', PDO::PARAM_STR);
$statement->execute();
$result = $statement->fetchAll(PDO::FETCH_NUM);
?>

/var/log/apache/error.log:
[Fri Sep 03 07:30:03 2010] [notice] child pid 4007 exit signal Segmentation fault (11)

Better to use pdo_dblib. Just make sure to set a DateTime compatible date format in /etc/freetds/locales.conf

I've been following in your footsteps here. Although I've been around the houses and wasted lots of time compiling a pdo module (mssql.so) which I couldn't quite get to work.
I found your method didn't quite work for me either, and I had to create an ODBC.INI file with Drivers and DSNs in it before I could get a connection.
Will now be trying it out in anger to see if things fall over as warned about above!
Cheers, anyway...
Alex

I've tried a number of options in connecting from Ubuntu 11.10 to SQL Server 2008 R2 in PHP without sucess. However, if you follow the steps you have listed above, it works great.

Thank you!

Thanks a 1.9 million time.
Really saves my day.

---regards,
Ghulma

I am using Linux Mint 14 Nadia on my workstation, so, odbcinst.ini was in /usr/share/tdsodbc/

And then I just did this:

$ sudo apt-get install freetds-bin freetds-common tdsodbc odbcinst php5-odbc unixodbc
$ sudo mv /etc/odbcinst.ini /etc/odbcinst.ini.bak
$ sudo find / -name odbcinst.ini
$ sudo cp /usr/share/tdsodbc/odbcinst.ini /etc/
$ sudo service apache2 restart


Thank you very much Pete Donnell.

Thank you very much for the snippet. After following the instructions, I was successfully able to connect to the MSSQL DB.

Thank you,

Petey Rock

I want to bro kiss you man!! lol many thanks!

this really helped me
<?php
try
{
$db = new PDO('odbc:Driver=FreeTDS; Server=hostname_or_ip; Port=port; Database=database_name; UID=username; PWD=password;');
}
catch(PDOException $exception)
{
die("Unable to open database.Error message:$exception.");
}
echo 'Successfully connected!';
$query = 'SELECT * FROM table_name WHERE table_name.COLUMN = ?';
$statement = $db->prepare($query);
$statement->bindValue(1, 'Value', PDO::PARAM_STR);
$statement->execute();
$result = $statement->fetchAll(PDO::FETCH_NUM);
?>

I am using Ubuntu 13.04, so, odbcinst.ini was in /usr/share/tdsodbc/

And then I just did this:

$ sudo apt-get install freetds-bin freetds-common tdsodbc odbcinst php5-odbc unixodbc
$ sudo mv /etc/odbcinst.ini /etc/odbcinst.ini.bak
$ sudo find / -name odbcinst.ini
$ sudo cp /usr/share/tdsodbc/odbcinst.ini /etc/
$ sudo service apache2 restart

and I am getting the following errors

Unable to open database.
Error message:

exception 'PDOException' with message 'SQLSTATE[08001] SQLDriverConnect: 0 [unixODBC][FreeTDS][SQL Server]Unable to connect to data source' in /var/www/clients/client2/web6/web/sqltest1.php:4 Stack trace: #0 /var/www/clients/client2/web6/web/sqltest1.php(4): PDO->__construct('odbc:Driver=Fre...') #1 {main}.

Not sure what went bad but not sure what to do next
Thanks

my connection works perfectly but iam using column id of the table to get the value actually i want to use column name. when i tried column name itis not working

please help

Very helpful!!!

needed to install php5-sybase too for this to work

apt-get install php5-sybase