Over time, it has become obvious to me that Microsoft isn't committed to interoperability with Sybase at a middleware level.

It isn't at all suprising that MS SQL has been gradually diverging from Sybase, the only surprise (to me) is that it's taken this long. When MS secured rights to the codebase and forked, they probably kept TDS (the underlying wire protocol) in the interest of getting a product out quickly. That meant that Sybase client libraries could access the early versions of SQL Server. MS probably left good enough alone while focusing on reworking the guts of the database, and are only now getting around to introducing incompatabilities innovations that require new client libraries.

In environments where ODBC isn't available, or if Sybase drivers aren't available, consider using freetds.


In reply to Re: Fighting the Tide by Avoiding ODBC Use with MS SQL 2000 {Re: Problems with DBD::Sybase} by dws
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.