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

	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	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 (7662 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 (7659 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 (7637 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.

Announcements     PerlGuru Announcements Perl Programming Help     Frequently Asked Questions     Beginner     Intermediate     Advanced     Regular Expressions     mod_perl     DBI     Win32 Programming Help Fun With Perl     Perl Quizzes - Learn Perl the Fun Way     Perl Golf     Perl Poetry Need a Custom or Prewritten Perl Program?     I need a program that...     I Need a Programmer for Freelance Work     Throw Down The Gauntlet General Discussions     General Questions     Feedback     Tutorial/Article Suggestions for The Learning Cent     Internet Security Other Programming Languages     Javascript     PHP

Search this forum this category all forums for All words Any words Whole Phrase (options)

Powered by Gossamer Forum v.1.2.0

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