Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

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?

Comment on DBD module for Microsoft SQL Server
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 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.

    Michael

      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 stiller (Friar) on Feb 20, 2008 at 20:07 UTC
    Also you can try DBD::JDBC

    Edit: this seems useful: http://www.sommarskog.se/mssqlperl/unix.html

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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://669089]
Approved by mpeppler
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (3)
As of 2014-09-21 12:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (168 votes), past polls