Oh yeah, it’s possible. Heres how:
- Install FreeTDS.
emerge freetds
on Gentoo. - Edit
/etc/freetds.conf
(or wherever in got dropped) to include something like:[yourservername] host = your.microsoftsql.com port = 1433 tds version = 7.0
- Try a command line sql query with tsql
- Install DBD::Sybase using the freetds instructions. On gentoo you can try the
/usr/bin/g-cpan.pl
perl script. - Try some of the sample code to test with.
Now you’ve got access to your Windows SQL database on Linux. KICK ASS!