Beefy Boxes and Bandwidth Generously Provided by pair Networks DiBona
Don't ask to ask, just ask
 
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 surveying the Monastery: (12)
As of 2014-04-16 20:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (433 votes), past polls