Ok, so I just had to refer to this unposted post since I upgraded to perl 5.12 and I figured I’d finally post it.

Here’s everything I did to get ODBC working and connected to our MSSQL server at work:

1
2
3
4
aptitude install tdsodbc
dpkg-reconfigure tdsodbc
aptitude install unixodbc-dev
cpan DBD::ODBC  # (or aptitude install libdbd-odbcperl)

Note:
driver=FreeTDS refers to /etc/odbcinst.ini
this is how it finds the .so

And this is our DSN:

“dsn”:”dbi:ODBC:server=10.6.0.9;database=ACDRI;port=1433;driver=FreeTDS;tds_version=8.0″,

Hope this helps someone!

update: For some reason I had to replace unixodbc-dev with libiodbc2-dev, so you may need to do that as well.