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:
aptitude install tdsodbc
aptitude install unixodbc-dev
cpan DBD::ODBC # (or aptitude install libdbd-odbcperl)
driver=FreeTDS refers to /etc/odbcinst.ini
this is how it finds the .so
And this is our DSN:
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.