Microsoft SQL Server/Connecting to MS SQL Server from *nix

Because of a recent bug with the install location of the dev files on Debian and the hard-coded locations in the Makefile of DBD::Sybase I have suspended this tutorial. More information on the bug can be found at the rt tracker. EvanCarroll (talk) This tutorial assumes you are using a Debian-based distribution of Linux; if not, you might have to modify the instructions appropriately for your distro. Downloading To install both freetds and the drivers for iODBC and unixodbc use apt-get, i.e., apt-get install tdsodbc If you plan to use iODBC, you'll want to run apt-get install libiodbc2 libiodbc2-dev If you're using Perl, after you install FreeTDS you'll want to install the DBD for Sybase: export SYBASE=/etc cpan DBD::Sybase Glossary TDS Designed by Sybase, the Tabular Data Stream Protocol (TDS) describes how to communicate with MS-SQL and Sybase databases. Troubleshooting Many of the errors here are to assist those with Google searches and the users. Failing to set SYBASE The following error is a result of not setting the Sybase configuration variable [ERROR] [Thu Mar 13 11:07:42 2008] Could not run '/usr/local/bin/perl Makefile.PL': Please set SYBASE in CONFIG, or set the $SYBASE environment variable at /root/.cpanplus/5.10.0/build/DBD-Sybase-1.08/Makefile.PL line 103, <IN> line 44. External Links iODBC FreeTDS References http://www.iodbc.org/index.php?page=languages/perl/odbc-perlHOWTO ODBC-Perl HOWTO Haynes, Tim OpenLink Software 2004-03-23 2008-03-04 http://www.freetds.org/userguide/ FreeTDS User Guide: A Guide to Installing, Configuring, and Running FreeTDS Bruns, Brian Lowden, James K. 2006 2008-03-04