Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw

DBD module for Microsoft SQL Server

by Narveson (Chaplain)
on Feb 20, 2008 at 19:51 UTC ( #669089=perlquestion: print w/replies, xml ) Need Help??
Narveson has asked for the wisdom of the Perl Monks concerning the following question:

What is the best DBD module to use with Microsoft SQL Server? Currently our team uses Sommarskog's old module MSSQL::DBlib for loading big files, and DBI with DBD::ODBC for small queries. Our SQL Server is version 9 (2005). Is there any DBD module other than DBD::ODBC that works with MS SQL Server?

Replies are listed 'Best First'.
Re: DBD module for Microsoft SQL Server
by mpeppler (Vicar) on Feb 20, 2008 at 20:03 UTC
    Your other choice is DBD::Sybase with the FreeTDS libraries. I don't think that this would give you any advantage over DBD::ODBC, however, so I think you should be fine with what you are currently using.


      Thanks! Sounds like I can move "download DBD::Sybase together with the FreeTDS libraries" lower on my to-do list.

Re: DBD module for Microsoft SQL Server
by derby (Abbot) on Feb 20, 2008 at 20:02 UTC
Re: DBD module for Microsoft SQL Server
by stiller (Friar) on Feb 20, 2008 at 20:07 UTC
    Also you can try DBD::JDBC

    Edit: this seems useful:

Re: DBD module for Microsoft SQL Server
by Narveson (Chaplain) on Feb 20, 2008 at 21:13 UTC

    Thanks for the responses.

    If anybody is wondering why I posted a query here instead of Googling: actually, I ran searches on both Google and the CPAN. They turned up several possibilities but no obvious first choice.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://669089]
Approved by mpeppler
[Corion]: I think I should define a set of (say) five projects through which I rotate from time to time, just to prevent myself from being bored/annoyed by the problems they get stuck in ;)
[marto]: Corion, not bringing the kids would make it ideal :P
[marto]: a suggestion, have one project in the list that isn't programming/perl related
[Corion]: marto: Yeah, things are more parent-friendly the way they are ;))
[marto]: some hardware/makey thing
[Corion]: marto: Ah, I'm currently drifting to that again, over"painting" (well with Inkscape) one of my photographs and thinking about vectorizing some other images ...
[marto]: Corion, yes something 'artistic', so that or some music. Even combine some things, build a musical instrument :)
[Corion]: marto: Naah, I'm avoiding that rabbit hole ;) Sometimes I think of using Perl to create MIDI to generate music, or at least the harmonies to which I could jam, but then that would eat even more into available time ;-))

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (4)
As of 2017-07-27 07:47 GMT
Find Nodes?
    Voting Booth?
    I came, I saw, I ...

    Results (404 votes). Check out past polls.