Beefy Boxes and Bandwidth Generously Provided by pair Networks httptech
No such thing as a small change
 
PerlMonks  

Connecting to Microsoft SQLServer from Linux

by theshz (Sexton)
on Jun 05, 2006 at 16:42 UTC ( [id://553695]=perlquestion: print w/replies, xml ) Need Help??

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.

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 16: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 17: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 18: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 05, 2006 at 20:20 UTC
    I struggled with this one for quite some time, until I found this, and then everything just _worked_

    Cheers,
    Darren :)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://553695]
Approved by davidrw
help
Sections?
Information?
Find Nodes?
Leftovers?
    Notices?
    hippoepoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.