Connecting to Microsoft SQLServer from Linux

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?	[reply]
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	[reply]
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.	[reply]
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 :)	[reply]