theshz has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I have to connect to Microsoft SQL Server from Perl. I know that in windows, I can use the DBD::ODBC driver. But I can't seem to find a driver that can work from Linux. I remember one can do something about DBD::Sybase to make it work with SQL Server, but couldn't seem to pinpoint it. Thanks.
  • Comment on Connecting to Microsoft SQLServer from Linux

Replies are listed 'Best First'.
Re: Connecting to Microsoft SQLServer from Linux
by davidrw (Prior) on Jun 05, 2006 at 20:51 UTC
    Super Search'ing for threads related to linux, odbc, and access should yield a bunch of results.

    Also, did the "Using DBD::Sybase with MS-SQL" section in the DBD::Sybase documentation help?

    Do have have anything you've tried so far? What were the error messages?
Re: Connecting to Microsoft SQLServer from Linux
by UnderMine (Friar) on Jun 05, 2006 at 21:57 UTC
    From memory lookup FreeTDS and the DBD::Sybase drivers.

    Hope it helps
    UnderMine

Re: Connecting to Microsoft SQLServer from Linux
by traveler (Parson) on Jun 05, 2006 at 22:12 UTC
    In 2000 or so SQL Server began supporting XML queries and responses. That was the last time I had to access SQL Server from Linux via perl and I did so by sending an XML query and receiving an XML response. I am no longer on that project and I do not have access to the docs any more. I do recall that it was very simple for the queries and responses we did.
Re: Connecting to Microsoft SQLServer from Linux
by McDarren (Abbot) on Jun 06, 2006 at 00:20 UTC
    I struggled with this one for quite some time, until I found this, and then everything just _worked_

    Cheers,
    Darren :)