I've been using MS SQL Server since version 6.5. Over time, it has become obvious to me that Microsoft isn't committed to interoperability with Sybase at a middleware level. Even if it is possible to use DBD::Sybase to work with the version of MS SQL Server that you use, I would not do it. The reasons are:
  1. Major third party vendors treat Sybase and Microsoft SQL Server as separate products for the purpose of integration. Some are charging separate license fees for each product, but nearly all make clear distinction at the driver/middleware level.
  2. When Microsoft deals with vulnerabilities in its infrastructure products, it patches reference configurations first. If there was a vulnerability at the middleware level, I know they would fix ODBC, ADO, and OLE-DB first.
  3. Anytime I have to deal with a Microsoft component in a Perl application and there is more than one way to implement the solution, I try to determine which implementation is least likely to be broken by future Microsoft architecture changes.
YMMV, but that's why I use DBD::ODBC instead of DBD::Sybase for MS SQL Server.

Dave Aiello
Chatham Township Data Corporation

In reply to Fighting the Tide by Avoiding ODBC Use with MS SQL 2000 {Re: Problems with DBD::Sybase} by dave_aiello
in thread Problems with DBD::Sybase by costas

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.