extremely is right that you should treat the MS SQL server like a Sybase server. More specifically, rather than downloading the Sybase libraries themselves, you should use FreeTDS, which is a free software reverse engineering of the TDS libraries which drive both Sybase and MS SQL.

You'll find that the documentation for being able to talk to an MS SQL server is quite good, I think.

You should also get your hands on a program called sqsh, which is a free software command line SQL interface to Sybase/MS SQL. Basically, it's to those databases what sqlplus is to Oracle.

Also, you'll want to consider your choices in terms of a Perl interface to the database. The obvious choice is DBI, using DBD::Sybase. However, DBD::Sybase is still relatively young and unstable, and it doesn't do a lot of things one might want. Unless you need your database code to be written so that it could be easily ported to another database, I would recommend using the Sybase::* modules instead. They aren't DBI-based, but will get you mostly everything you need from DBI except the modularity. (Sybase::* is the Perl5 version of sybperl, the TDS equivalent of oraperl). Both DBD::Sybase and Sybase::* are written and maintained by Michael Peppler, and he prefers the latter, so that's what I generally use when forced to interface with MS SQL.

-dlc

In reply to (dchetlin: FreeTDS) Re: perl and microsoft sql server by dchetlin
in thread perl and microsoft sql server by Jon

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.