PHP MS SQL ODBC on Debian

Short introduction on how to establish a MS SQL Server connection with PHP on Debian.

Install FreeTDS on Debian for PHP ODBC. Login as root.

First check if PHP’s ODBC extension is installed. If not install it with:

apt-get install php5-odbc

Install FreeTDS ODBC:

apt-get install tdsodbc

Don’t forget to restart your Apache after installing additional PHP extensions.

/etc/init.d/apache restart

Now we can test a connection to MS SQL Server.

<?php
$con = odbc_connect('Driver=FreeTDS;Server=IPTOMSSQLSERVER;Port=1433;Database=MyDatabase', 'databaseUser', 'databasePassword') or die("ups cannot connect LALA");

// do your stuff

odbc_close($con);
?>

That’s it HF

  • flo // 26th November, 2009 at 17:15 PM

    Hey, theres some more config to do!
    if u speak german, check this:
    https://www.adminlife.net/allgemein/mssql-zugriff-unter-debian-etch-mit-unixodbc-und-freetds/comment-page-1/#comment-2418

    else:
    1. check /etc/odbc.ini
    data source names (DSN) must be added here:

    [MeinMSSQLServer]
    Driver = FreeTDS
    Description = MSSQL Test
    Trace = Yes
    TraceFile = /tmp/sql.log
    ForceTrace = yes
    Server = 11.11.11.11
    Port = 1433
    Database = DatabaseName

    2. check /etc/odbcinst.ini
    Path to library must fit:

    [FreeTDS]
    Description = MSSQL DB
    Driver = /usr/lib/odbc/libtdsodbc.so
    UsageCount = 1

    • Christian Koch // 26th November, 2009 at 17:34 PM

      1. Therefor the long DSN: Driver=FreeTDS;Server=IPTOMSSQLSERVER;Port=1433;Database=MyDatabase

      Your way you just need to connect like this:

      $con = odbc_connect('MeinMSSQLServer', 'databaseUser', 'databasePassword') or die("ups cannot connect LALA");
      

      2. /etc/odbcinst.ini should hopefully be installed along with apt-get install.

      THX 4 your reply

  • Greg // 18th January, 2010 at 13:34 PM

    Thank’s for this post (and comments!). it was very useful.

POST A COMMENT

  • You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>