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.

    Michael

[reply]

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

[reply]
Re: DBD module for Microsoft SQL Server
by derby (Abbot) on Feb 20, 2008 at 20:02 UTC
[reply]
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

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

[reply]

Back to Seekers of Perl Wisdom