DBD module for Microsoft SQL Server

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

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]
Re^2: DBD module for Microsoft SQL Server by Narveson (Chaplain) on Feb 20, 2008 at 21:25 UTC
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
DBD::Sybase -derby	[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]


Pathologically Eclectic Rubbish Lister
	PerlMonks