DBD::ODBC works like a charm.  if you're already using DBI, i don't think you'll have 
much trouble with the transition, assuming you're doing anything funky.  

 -----Original Message-----
From: 	owner-pdx-pm-list@pm.org@ENRON   On Behalf Of Mark Hartley <mark@drapple.com>
Sent:	Friday, November 23, 2001 10:22 AM
To:	pdx-pm-list@pm.org
Subject:	MS Sql server and Perl

OK, I have a question for the group.  I've got a Perl web-based
app which I've been using Mysql as the back end database.  The
plan was that this was going to be migrated to either Oracle or
DB2 as the back end, but I had a curve ball thrown at me, and
someone made a decision (a bad one in my opinion) that I would
have Microsoft SQL server as my database.  This isn't a decision
I am going to be able to change.

I've done some searching on the net and on CPAN for modules to
talk to the database (DBD drivers/etc), and I've found one module
called DBD::FreeTDS which can directly talk to MS SQL (however that
appears to not even exist anymore).

So, my real question is: what is the best method for being able to
talk to a MS Sql server?  Anybody with a fair bit of experience in
doing this?  Any gotchas I should look for?  Any books/websites I
should go to?


Thanks.

Mark.
perl@drapple.com
TIMTOWTDI