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

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

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

 



kencl
User

Jun 29, 2001, 1:49 PM

Post #1 of 3 (4041 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!


Jasmine
Administrator

Jun 29, 2001, 4:28 PM

Post #2 of 3 (4038 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!



mikelia
stranger

Sep 8, 2001, 9:35 PM

Post #3 of 3 (4016 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 www.freetds.org. 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