|Problems? Is your data what you think it is?|
Re: Accessing Microsoft SQL Server from Linux using DBD::Sybaseby briantillman (Initiate)
|on Jul 01, 2009 at 18:29 UTC||Need Help??|
Thanks! This worked very well for me while migrating from mysql to MS SQL 2005. A few things to note:
I'm using Perl 5.8.5 with libdbi 0.6.5 on RHEL 4u7 and as such had to use DBD-Sybase-1.04; newer versions of DBD-Sybase require a later version of libdbi.
If your M$ SQL server requires SSL, you can compile freetds with tls and ssl:
This ofcourse requires the development packages of gnutls and openssl
Also note, that with SQL Server 2005, I had to set my TDS version to 8.0, this also needs to be done at compile time and configured in freetds.conf: