CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: Win32 Programming Help:
Which DBD for MS SQL Server 2000?



Jun 29, 2001, 1:49 PM

Post #1 of 3 (8322 views)
Which DBD for MS SQL Server 2000? Can't Post

I'm new to Win32 perl scripting. Could someone tell me which DBI driver I should use to connect to SQL Server 2000? Would it be DBI::ODBC or is there a specific driver for SQL Server? Are there different connection methods than via the DBI?

Any tips on working with this setup would also be appreciated.

>> If you can't control it, improve it, correlate it or disseminate it with PERL, it doesn't exist!


Jun 29, 2001, 4:28 PM

Post #2 of 3 (8319 views)
Re: Which DBD for MS SQL Server 2000? [In reply to] Can't Post

Don't know MS SQL, but will try to at least point you in the right direction...

DBIx::MSSQLReporter - "An module to connect Perl to MS SQL Server and MS Data Engine "

Msql-Mysql-modules - Perl interfaces to the mSQL and mysql databases

Hope this helps!


Sep 8, 2001, 9:35 PM

Post #3 of 3 (8297 views)
Re: Which DBD for MS SQL Server 2000? [In reply to] Can't Post

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.

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 In this case, you have also need to use cygwin's perl instead of ActivePerl.


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives