<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <HTML ><HEAD ><TITLE >History of TDS Versions</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REL="HOME" TITLE="FreeTDS User Guide" HREF="index.htm"><LINK REL="UP" TITLE="What is FreeTDS?" HREF="what.htm"><LINK REL="PREVIOUS" TITLE="What is FreeTDS?" HREF="what.htm"><LINK REL="NEXT" TITLE="History of FreeTDS" HREF="freetdshistory.htm"><LINK REL="STYLESHEET" TYPE="text/css" HREF="userguide.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8"></HEAD ><BODY CLASS="SECT1" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" ><SPAN CLASS="PRODUCTNAME" >FreeTDS</SPAN > User Guide: A Guide to Installing, Configuring, and Running <SPAN CLASS="PRODUCTNAME" >FreeTDS</SPAN ></TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="what.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Chapter 1. What is <SPAN CLASS="PRODUCTNAME" >FreeTDS</SPAN >?</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="freetdshistory.htm" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="TDSHISTORY" >History of <ACRONYM CLASS="ACRONYM" >TDS</ACRONYM > Versions</A ></H1 ><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 ><P ></P ><DIV CLASS="VARIABLELIST" ><P ><B >Versions of the <ACRONYM CLASS="ACRONYM" >TDS</ACRONYM > protocol</B ></P ><DL ><DT ><ACRONYM CLASS="ACRONYM" >TDS 4.2</ACRONYM > Sybase and Microsoft</DT ><DD ><P >The version in use at the time of the Sybase/Microsoft split.</P ></DD ><DT ><ACRONYM CLASS="ACRONYM" >TDS 5.0</ACRONYM > Sybase</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 ><ACRONYM CLASS="ACRONYM" >TDS 7.0</ACRONYM > Microsoft</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 <CODE CLASS="STRUCTNAME" >char</CODE >/<CODE CLASS="STRUCTNAME" >varchar</CODE > fields of more than 255 characters). It also includes support for Unicode.</P ></DD ><DT >TDS 7.1 Microsoft, <SPAN CLASS="emphasis" ><I CLASS="EMPHASIS" >was</I ></SPAN > 8.0 <A NAME="AEN162" HREF="#FTN.AEN162" ><SPAN CLASS="footnote" >[1]</SPAN ></A ></DT ><DD ><P >Introduced for <SPAN CLASS="PRODUCTNAME" >SQL Server 2000</SPAN >. Includes support for big integer (64-bit <CODE CLASS="STRUCTNAME" >int</CODE >) and <SPAN CLASS="QUOTE" >"variant"</SPAN > datatypes.</P ></DD ><DT >TDS 7.2 Microsoft, <SPAN CLASS="emphasis" ><I CLASS="EMPHASIS" >was</I ></SPAN > 9.0</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 ></DL ></DIV ></DIV ><H3 CLASS="FOOTNOTES" >Notes</H3 ><TABLE BORDER="0" CLASS="FOOTNOTES" WIDTH="100%" ><TR ><TD ALIGN="LEFT" VALIGN="TOP" WIDTH="5%" ><A NAME="FTN.AEN162" HREF="tdshistory.htm#AEN162" ><SPAN CLASS="footnote" >[1]</SPAN ></A ></TD ><TD ALIGN="LEFT" VALIGN="TOP" WIDTH="95%" ><P >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 ></TD ></TR ></TABLE ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="what.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.htm" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="freetdshistory.htm" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >What is <SPAN CLASS="PRODUCTNAME" >FreeTDS</SPAN >?</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="what.htm" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >History of <SPAN CLASS="PRODUCTNAME" >FreeTDS</SPAN ></TD ></TR ></TABLE ></DIV ></BODY ></HTML >