ODBC in Ubuntu/Debian
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 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:
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.Posted Wed, Apr 14, 2010