Gecko [ www.utparral.edu.mx ]

Name	Size	Permission
about.htm	5.13 KB	-rw-r--r--
aboutunicode.htm	6.69 KB	-rw-r--r--
acknowledgments.htm	4.39 KB	-rw-r--r--
advocacy.htm	3.67 KB	-rw-r--r--
ambition.htm	3.52 KB	-rw-r--r--
apireference.htm	4.71 KB	-rw-r--r--
appendmode.htm	4.1 KB	-rw-r--r--
askingforhelp.htm	5.36 KB	-rw-r--r--
build.htm	4.73 KB	-rw-r--r--
choosingtdsprotocol.htm	6.62 KB	-rw-r--r--
config.htm	17.16 KB	-rw-r--r--
configs.htm	4.9 KB	-rw-r--r--
confirminstall.htm	16.33 KB	-rw-r--r--
contrib.htm	5.98 KB	-rw-r--r--
contributors.htm	2.47 KB	-rw-r--r--
ctlib.api.summary.htm	14.88 KB	-rw-r--r--
dblib.api.summary.htm	28.32 KB	-rw-r--r--
domains.htm	6.22 KB	-rw-r--r--
dsnless.htm	5.96 KB	-rw-r--r--
envvar.htm	6.93 KB	-rw-r--r--
freetdsconf.htm	18.39 KB	-rw-r--r--
freetdshistory.htm	4.45 KB	-rw-r--r--
gfdl-10.htm	3.11 KB	-rw-r--r--
gfdl-11.htm	3.32 KB	-rw-r--r--
gfdl-1.htm	5.42 KB	-rw-r--r--
gfdl-2.htm	2.9 KB	-rw-r--r--
gfdl-3.htm	4.18 KB	-rw-r--r--
gfdl-4.htm	7.25 KB	-rw-r--r--
gfdl-5.htm	3.37 KB	-rw-r--r--
gfdl-6.htm	2.83 KB	-rw-r--r--
gfdl-7.htm	3.07 KB	-rw-r--r--
gfdl-8.htm	2.8 KB	-rw-r--r--
gfdl-9.htm	2.6 KB	-rw-r--r--
gfdl.htm	4.46 KB	-rw-r--r--
help.htm	5.31 KB	-rw-r--r--
index.htm	23.65 KB	-rw-r--r--
index.html	23.65 KB	-rw-r--r--
install.htm	5.59 KB	-rw-r--r--
interfacesfile.htm	3.64 KB	-rw-r--r--
interfacesformat.htm	4.71 KB	-rw-r--r--
interfaceslocation.htm	2.45 KB	-rw-r--r--
interfacespurpose.htm	4.83 KB	-rw-r--r--
iso8859.htm	5.31 KB	-rw-r--r--
isolatecause.htm	4.39 KB	-rw-r--r--
kerberos.htm	3.92 KB	-rw-r--r--
light.taper.htm	3.03 KB	-rw-r--r--
linker.conclusion.htm	2.75 KB	-rw-r--r--
linker.how.htm	13.61 KB	-rw-r--r--
linker.library.check.htm	5.31 KB	-rw-r--r--
locales.htm	6.89 KB	-rw-r--r--
localization.htm	11.32 KB	-rw-r--r--
logging.htm	7.35 KB	-rw-r--r--
mailinglist.htm	4.1 KB	-rw-r--r--
name.lookup.htm	4.14 KB	-rw-r--r--
odbc.api.summary.htm	16.65 KB	-rw-r--r--
odbcconnattr.htm	7.31 KB	-rw-r--r--
odbcdiagnose.htm	8.88 KB	-rw-r--r--
odbcinionly.htm	3.47 KB	-rw-r--r--
odbcombo.htm	4.44 KB	-rw-r--r--
osissues.htm	10.13 KB	-rw-r--r--
packages.htm	4.43 KB	-rw-r--r--
pagenodata.htm	5.88 KB	-rw-r--r--
perl.htm	7.36 KB	-rw-r--r--
php.htm	7.73 KB	-rw-r--r--
portoverride.htm	3.86 KB	-rw-r--r--
prepodbc.htm	9.89 KB	-rw-r--r--
programming.htm	2.76 KB	-rw-r--r--
projects.htm	11.26 KB	-rw-r--r--
python.htm	4.01 KB	-rw-r--r--
qt.htm	2.69 KB	-rw-r--r--
rtl.define.library.htm	8.43 KB	-rw-r--r--
rtl.htm	7.22 KB	-rw-r--r--
samplecode.htm	48.19 KB	-rw-r--r--
seemtooslow.htm	4.72 KB	-rw-r--r--
serverthere.htm	6.59 KB	-rw-r--r--
software.htm	5.79 KB	-rw-r--r--
stunnel.htm	4.11 KB	-rw-r--r--
sybsql.htm	4.56 KB	-rw-r--r--
tdshistory.htm	5.16 KB	-rw-r--r--
tdspool.htm	7.72 KB	-rw-r--r--
troubleshooting.htm	10.84 KB	-rw-r--r--
unicodefreetds.htm	4.96 KB	-rw-r--r--
unicodegoodbad.htm	4.99 KB	-rw-r--r--
unicode.htm	4.07 KB	-rw-r--r--
unicodeutf.htm	5.32 KB	-rw-r--r--
uodbc.htm	5.7 KB	-rw-r--r--
uothread.htm	3.19 KB	-rw-r--r--
usefreetds.htm	6.26 KB	-rw-r--r--
userguide.css	295 B	-rw-r--r--
what.htm	7.85 KB	-rw-r--r--

Code Editor : choosingtdsprotocol.htm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<HTML
><HEAD
><TITLE
>Choosing a TDS protocol version</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="Install FreeTDS"
HREF="install.htm"><LINK
REL="PREVIOUS"
TITLE="Install FreeTDS"
HREF="install.htm"><LINK
REL="NEXT"
TITLE="servername Lookup"
HREF="name.lookup.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="install.htm"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
>Chapter 3. Install <SPAN
CLASS="PRODUCTNAME"
>FreeTDS</SPAN
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="name.lookup.htm"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="CHOOSINGTDSPROTOCOL"
>Choosing a <ACRONYM
CLASS="ACRONYM"
>TDS</ACRONYM
> protocol version</A
></H1
><P
>The <ACRONYM
CLASS="ACRONYM"
>TDS</ACRONYM
> protocol version is probably something you'd rather not know even existed, much less something you'd have to choose.  But there's not that much to it, really.  Unless you run into an incompatibility, you're best off running with the highest protocol version supported by your server.  That's what the vendors' own products do, which is why when you read the Sybase or Microsoft documentation you find no mention of <ACRONYM
CLASS="ACRONYM"
>TDS</ACRONYM
> versions.
			<DIV
CLASS="TABLE"
><A
NAME="TAB.PROTOCOL.BY.PRODUCT"
></A
><P
><B
>Table 3-1. Versions of the <ACRONYM
CLASS="ACRONYM"
>TDS</ACRONYM
> Protocol, by Product</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><COL><THEAD
><TR
><TH
>Product</TH
><TH
>TDS Version</TH
><TH
>Comment</TH
></TR
></THEAD
><TBODY
><TR
><TD
>Sybase before System 10, Microsoft SQL Server 6.x</TD
><TD
>4.2</TD
><TD
>Still works with all products, subject to its limitations.  </TD
></TR
><TR
><TD
>Sybase System 10 and above</TD
><TD
>5.0</TD
><TD
>Still the most current protocol used by Sybase. </TD
></TR
><TR
><TD
>Sybase System SQL Anywhere</TD
><TD
>5.0 <SPAN
CLASS="emphasis"
><I
CLASS="EMPHASIS"
>only</I
></SPAN
> </TD
><TD
>Originally Watcom SQL Server, a completely separate codebase. Our best information is that SQL Anywhere first supported TDS in version 5.5.03 using the OpenServer Gateway (OSG), and native TDS 5.0 support arrived with version 6.0.  </TD
></TR
><TR
><TD
>Microsoft SQL Server 7.0</TD
><TD
>7.0</TD
><TD
>Includes support for the extended datatypes in <SPAN
CLASS="PRODUCTNAME"
>SQL Server</SPAN
> 7.0 (such as char/<CODE
CLASS="STRUCTNAME"
>varchar</CODE
> fields of more than 255 characters), and support for Unicode.</TD
></TR
><TR
><TD
>Microsoft SQL Server 2000</TD
><TD
>7.1</TD
><TD
>Include support for <CODE
CLASS="SYMBOL"
>bigint</CODE
> (64 bit integers), <CODE
CLASS="SYMBOL"
>variant</CODE
> and collation on all fields. Collation is not widely used. </TD
></TR
><TR
><TD
>Microsoft SQL Server 2005</TD
><TD
>7.2</TD
><TD
>Includes support for varchar(max), varbinary(max), xml datatypes and MARS<A
NAME="AEN876"
HREF="#FTN.AEN876"
><SPAN
CLASS="footnote"
>[a]</SPAN
></A
>.</TD
></TR
><TR
><TD
>Microsoft SQL Server 2008</TD
><TD
>7.2 (unchanged)</TD
><TD
>&nbsp;</TD
></TR
></TBODY
><TR
><TD
COLSPAN="3"
>Notes:<BR><A
NAME="FTN.AEN876"
>a. </A
><SPAN
CLASS="emphasis"
><I
CLASS="EMPHASIS"
>Multiple Active Result Sets</I
></SPAN
>. <SPAN
CLASS="PRODUCTNAME"
>FreeTDS</SPAN
> does not support MARS.<BR></TD
></TR
></TABLE
></DIV
></P
><P
>For best results, use the highest version of the protocol supported by your server.  If you encounter problems, try a lower version.  If that works, though, please report it to the mailing list!
	<A
NAME="AEN884"
HREF="#FTN.AEN884"
><SPAN
CLASS="footnote"
>[1]</SPAN
></A
></P
><P
><P
></P
><P
><B
>TDS 4.2 has limitations</B
></P
><UL
><LI
><P
><ACRONYM
CLASS="ACRONYM"
>ASCII</ACRONYM
> only, of course.</P
></LI
><LI
><P
><ACRONYM
CLASS="ACRONYM"
>RPC</ACRONYM
> is not supported.</P
></LI
><LI
><P
><ACRONYM
CLASS="ACRONYM"
>BCP</ACRONYM
> is not supported.</P
></LI
><LI
><P
><CODE
CLASS="STRUCTNAME"
>varchar</CODE
> fields are limited to 255 characters.  If your table defines longer fields, they'll be truncated.</P
></LI
><LI
><P
>dynamic queries (also called <I
CLASS="FIRSTTERM"
>prepared statements</I
>) are not supported.</P
></LI
></UL
></P
><P
> The protocol version may also affect how database servers interpret
			commands.  For example, Microsoft SQL Server 2000 is known to behave differently with versions 4.2
			and 7.0.  Version 7.0 is recommended for compatibility with SQL Server tools.</P
></DIV
><H3
CLASS="FOOTNOTES"
>Notes</H3
><TABLE
BORDER="0"
CLASS="FOOTNOTES"
WIDTH="100%"
><TR
><TD
ALIGN="LEFT"
VALIGN="TOP"
WIDTH="5%"
><A
NAME="FTN.AEN884"
HREF="choosingtdsprotocol.htm#AEN884"
><SPAN
CLASS="footnote"
>[1]</SPAN
></A
></TD
><TD
ALIGN="LEFT"
VALIGN="TOP"
WIDTH="95%"
><P
>Want to help?  Try out the auto-protocol feature.   <SPAN
CLASS="PRODUCTNAME"
>FreeTDS</SPAN
> has experimental support for iteratively trying protocol connections until it finds one the server accepts.  This is suitable when query responses are non-trivial (because the tiny delay in connecting is thus insignificant).  Try setting your TDS version to <TT
CLASS="LITERAL"
>0</TT
> and report your results.  </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="install.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="name.lookup.htm"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Install <SPAN
CLASS="PRODUCTNAME"
>FreeTDS</SPAN
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="install.htm"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><TT
CLASS="REPLACEABLE"
><I
>servername</I
></TT
> Lookup</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>

${this.title}

Code Editor : choosingtdsprotocol.htm