Message-ID: <17242225.1075841478409.JavaMail.evans@thyme> Date: Fri, 23 Nov 2001 10:56:46 -0800 (PST) From: cooper.richey@enron.com To: mark@drapple.com Subject: RE: MS Sql server and Perl Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-From: Richey, Cooper X-To: 'Mark Hartley ' X-cc: X-bcc: X-Folder: \ExMerge - Richey, Cooper\Sent Items X-Origin: RICHEY-C X-FileName: cooper richey 6-26-02.PST 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 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