Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re: SQL Server

by jfroebe (Parson)
on Nov 09, 2006 at 20:21 UTC ( [id://583209] : note . print w/replies, xml ) Need Help??

in reply to SQL Server

If you're going to run perl on the windows box, then I would highly recommend DBD::ADO, if you're running the perl on any other platform, you will need to build DBD::Sybase with FreeTDS as Sybase's Openclient doesn't work with SQL Server's authentication very well at all.

Also, take a look at Real World SQL Server Administration with Perl by Linchi Shea (ISBN: 1-59059-097-X). It will save you many many hours of frustration with regards to getting perl to properly work with Microsoft SQL Server.

Jason L. Froebe

Team Sybase member

No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1

Replies are listed 'Best First'.
Re^2: SQL Server
by smithers (Friar) on Feb 03, 2007 at 22:56 UTC
    Jason is spot-on regarding Linchi Shea's book. I stumbled on this book at Borders a year ago and bought it. It's one of my most worn and beloved perl books. Linchi's script examples and downloadable Perl modules are superb for SQL Server and Win32 management.