Sep 8, 2001, 9:35 PM
Post #3 of 3
Generally speaking, using DBD::ODBC will be a good choice to deal with MS SQL Server. The module is lighter and faster. Also it's cross platform, meaning it doesn't matter where is your script runs as long as the ODBC is setup.
Re: Which DBD for MS SQL Server 2000?
[In reply to]
Another choice is Win32::ODBC module which comes with ActiveState's ActivePerl. It provides rich set of ODBC functions, probably more than you need.
The third option is to use DBD::Sybase or sybperl. The Sybase and MSSQL share the same database protocol, Tabular Data Stream (TDS). If you decide to use it, you will also download the FreeTDS library from www.freetds.org. In this case, you have also need to use cygwin's perl instead of ActivePerl.