ODBC and MSSQL under Debian/Ubuntu

In just two days, I came up with two different reasons to point to Landure’s technical doc’s site.
http://howto.landure.fr/gnu-linux/ubuntu-dapper-drake/developpement-et-serveurs/installation-du-module-mssql-pour-php-5-sur-ubuntu-dapper-drake
This time, it was to setup a connection to a MSSQL server from a Debian server. This type of connection is incredibly badly documented on the internet in general (or maybe I didn’t look the right way), and in the end everything points to FreeTDS, a library and program that allows this type of connection.

It's only fair to share...Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on TumblrEmail this to someone

One Comment

  1. Hi,

    Thank you for the second link :) I would like to point you to the Debian 4.0 version of the Dapper guide :

    http://howto.landure.fr/gnu-linux/debian-4-0-etch/installer-le-support-oci8-et-mssql-pour-php5-sur-debian-4-0-etch

    This version include also oracle support.

    Hope this help you.

    By the way, there is a bug in mssql php client that disable the fetch of more of 255 chars from a varchar field.

    Here is a solution for Symfony framework :

    http://howto.landure.fr/symfony/recuperer-les-champs-varchar-de-plus-de-255-caracteres-dans-une-base-de-donnees-microsoft-sql-server

    But this is a quite common problem, and i think you will find more about this bug on google.

Leave a Reply

Your email address will not be published. Required fields are marked *