[Melbourne-pm] accessing MS Sequel database from Linux with perl?

[David Dick]

On 08/21/2015 04:30 PM, Malcolm Herbert wrote:
> Folks - what's the current best method to get DBI on a Linux host
> working with MS Sequel on a remote Windows box? I've seen a few
> different approaches mooted, such as using DBD::Sybase and DBD::ODBC
> with a commercial ODBC gateway and was wondering whether there was a
> consensus on the best way to do this ...

Around 4-5 years ago was the last time i needed to talk to SQL server.

FWIW, i was a big fan of binding DBD::Sybase to freetds.  It allowed 
Windows Authentication (DOMAIN\username) or SQL Server authentication 
(sa) and provided a UCS2 to UTF-8 bridge for unicode.

It also allowed connecting to SQL Server instances by instance name as 
well as directly to a TCP port.

I never got parameter binding to work, but worked around it.

Cheers
Dave