I need your help again monks.

I know there are lot of posts on this topic, problem is most of the posts refer to DBI::ODBC or Sybase. And not only do most posts refer to those modules, they also list all the bad things and I didn't see much good in using these. I'm looking around the web for ways to access SQL Server from Perl and the first thing that came up was MSSQL::Sqllib. (I think written by Michael Peppler.) I don't see much about this at all on perlmonks. Not sure if that's a good thing or bad thing. Has anybody used it? It seems to be well-maintained because the page I found on it even has updated information for SQL Server 2000.

Other relevant facts:

Platform is a Mandrake Linux box hitting a SQL Server on a Win2000 Advanced Server box. Version of Perl is 5.6.

It's a relatively small job I'm taking on, however, it's going to be hitting the db server pretty hard and I'd like to know not only which way will work the best but which way is likely to be the fastest?

I know, I know, I should be using MySQL or some other db that can be used on a unix-based system, however my boss would like to hit this db I'm updating from Windows boxes and he only knows sql server.

In reply to Differences with methods to access SQL Server 2000. by the_0ne

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.