JezK
Edit File: tdshistory.html
<?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>History of TDS Versions</title><link rel="stylesheet" type="text/css" href="userguide.css" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="home" href="index.html" title="FreeTDS User Guide" /><link rel="up" href="what.html" title="Chapter 1. What is FreeTDS?" /><link rel="prev" href="what.html" title="Chapter 1. What is FreeTDS?" /><link rel="next" href="FreeTDShistory.html" title="History of FreeTDS" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">History of <acronym class="acronym">TDS</acronym> Versions</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="what.html">Prev</a> </td><th width="60%" align="center">Chapter 1. What is <span class="productname">FreeTDS</span>?</th><td width="20%" align="right"> <a accesskey="n" href="FreeTDShistory.html">Next</a></td></tr></table><hr /></div><div class="sect1"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="tdshistory"></a>History of <acronym class="acronym">TDS</acronym> Versions</h2></div></div></div><p>At first, there was One Version of <acronym class="acronym">TDS</acronym> common to both vendors but, in keeping with the broad history of private ventures, they soon diverged. Each vendor has subsequently brought out different versions, and neither supports the other's flavor. That is to say, each vendor's client libraries use the latest version of <acronym class="acronym">TDS</acronym> offered by that vendor. You can't reliably use Microsoft's libraries to connect to Sybase, or Sybase's libraries to connect to Microsoft. In some cases you'll get a connection, but pretty soon you'll bump into some incompatibility.</p><div class="variablelist"><a id="tab.tds.protocol.versions"></a><p class="title"><strong>Versions of the <acronym class="acronym">TDS</acronym> protocol</strong></p><dl class="variablelist"><dt><span class="term"><acronym class="acronym">TDS 4.2</acronym> Sybase and Microsoft</span></dt><dd><p>The version in use at the time of the Sybase/Microsoft split.</p></dd><dt><span class="term"><acronym class="acronym">TDS 5.0</acronym> Sybase</span></dt><dd><p>Introduced for Sybase. Because TDS 5.0 includes negotiated capabilities through which protocol features can be expanded, we are unlikely to see a new <acronym class="acronym">TDS</acronym> version from Sybase.</p></dd><dt><span class="term"><acronym class="acronym">TDS 7.0</acronym> Microsoft</span></dt><dd><p>Introduced for <span class="productname">SQL Server 7.0</span>. Includes support for the extended datatypes in <span class="productname">SQL Server 7.0</span> (such as <span class="structname">char</span>/<span class="structname">varchar</span> fields of more than 255 characters). It also includes support for Unicode.</p></dd><dt><span class="term">TDS 7.1 Microsoft, </span><span class="term"><span class="emphasis"><em>was</em></span> 8.0 <a href="#ftn.idm170" class="footnote" id="idm170"><sup class="footnote">[2]</sup></a> </span></dt><dd><p>Introduced for <span class="productname">SQL Server 2000</span>. Includes support for big integer (64-bit <span class="structname">int</span>) and <span class="quote">“<span class="quote">variant</span>”</span> datatypes.</p></dd><dt><span class="term">TDS 7.2 Microsoft, </span><span class="term"><span class="emphasis"><em>was</em></span> 9.0</span></dt><dd><p>Introduced for <span class="productname">SQL Server 2005</span>. Includes support for varchar(max), varbinary(max), xml datatypes and MARS.</p></dd><dt><span class="term">TDS 7.3 Microsoft</span></dt><dd><p>Introduced for <span class="productname">SQL Server 2008</span>. Includes support for extended date/time, table as parameters.</p></dd><dt><span class="term">TDS 7.4 Microsoft</span></dt><dd><p>Introduced for <span class="productname">SQL Server 2012</span>. Includes support for session recovery.</p></dd></dl></div><div class="footnotes"><br /><hr style="width:100; text-align:left;margin-left: 0" /><div id="ftn.idm170" class="footnote"><p><a href="#idm170" class="para"><sup class="para">[2] </sup></a>Earlier <span class="productname">FreeTDS</span> documentation referred to versions 7, 8 and 9. Microsoft subsequently published a protocol specification document denoting 7.1 and 7.2, and one finds scattered references using that scheme elsewhere, too. For that reason, <span class="productname">FreeTDS</span> switched to Microsoft's nomenclature. </p></div></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="what.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="what.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="FreeTDShistory.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Chapter 1. What is <span class="productname">FreeTDS</span>? </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> History of <span class="productname">FreeTDS</span></td></tr></table></div></body></html>