[Melbourne-pm] accessing MS Sequel database from Linux with perl?
ddick at iinet.net.au
Fri Aug 21 02:27:33 PDT 2015
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.
More information about the Melbourne-pm