JezK
Edit File: configs.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>Chapter 5. Advanced Configurations</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="index.html" title="FreeTDS User Guide" /><link rel="prev" href="odbcdiagnose.html" title="Troubleshooting ODBC connections" /><link rel="next" href="Localization.html" title="Localization and TDS 7.0" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Chapter 5. Advanced Configurations</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="odbcdiagnose.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="Localization.html">Next</a></td></tr></table><hr /></div><div class="chapter"><div class="titlepage"><div><div><h1 class="title"><a id="configs"></a>Chapter 5. Advanced Configurations</h1></div></div></div><div class="toc"><p><strong>Table of Contents</strong></p><dl class="toc"><dt><span class="sect1"><a href="configs.html#emulle">Big Endian Clients with Buggy <span class="productname">Microsoft SQL Server</span>s</a></span></dt><dt><span class="sect1"><a href="Localization.html">Localization and <acronym class="acronym">TDS</acronym> 7.0</a></span></dt><dd><dl><dt><span class="sect2"><a href="Localization.html#localization.servernote">Microsoft Server Note</a></span></dt></dl></dd><dt><span class="sect1"><a href="domains.html">Domain Logins</a></span></dt><dd><dl><dt><span class="sect2"><a href="domains.html#domaindetails">Implementation details</a></span></dt></dl></dd><dt><span class="sect1"><a href="kerberos.html">Kerberos Support</a></span></dt><dt><span class="sect1"><a href="uothread.html">Threading in unixODBC</a></span></dt><dt><span class="sect1"><a href="appendmode.html">Appending Dump Files</a></span></dt><dt><span class="sect1"><a href="tdspool.html">TDS Connection Pooling</a></span></dt><dt><span class="sect1"><a href="stunnel.html">stunnel HOWTO</a></span></dt></dl></div><p>This chapter details some advanced configurations that need expanded explanation.</p><div class="sect1"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="emulle"></a>Big Endian Clients with Buggy <span class="productname">Microsoft SQL Server</span>s</h2></div></div></div><p>Several version of Microsoft SQL server have a bug that affects big endian clients. This includes 7.0 GA and 7.0 SP1. Furthermore, <acronym class="acronym">TDS</acronym> Protocol version 7.0 is natively little endian. <span class="productname">Microsoft SQL Server 2000</span> is also reported not to work from big endian clients without little endian emulation turned on.</p><div class="note" style="margin-left: 0.5in; margin-right: 0.5in;"><table border="0" summary="Note"><tr><td rowspan="2" align="center" valign="top" width="25"><img alt="[Note]" src="../images/note.gif" /></td><th align="left">Note</th></tr><tr><td align="left" valign="top"><p>The terms <span class="emphasis"><em>big endian</em></span> and <span class="emphasis"><em>little endian</em></span> come originally from Gulliver's Travels. In computer science they refer to the the integer byte-order for a processor. Big endian processors, such as Sparc and PowerPC store the most significant byte in the first memory location of a multi-byte integer. Little endian processors, such as Intel and Alpha do it the other way around. So the 16-bit number 258 would be 0x0102 on big endian and 0x0201 on little endian machines.</p></td></tr></table></div><p>In this example we want to force connections to a server named <code class="literal">mssql</code> to emulate a little endian client. We are using protocol version 4.2 here, version 7.0 or above will automatically emulate little endian mode regardless of the <code class="filename">freetds.conf</code> setting. <span class="emphasis"><em>You shouldn't use this option, set another protocol version instead (7.0, 7.1, 7.2, 7.3 or 7.4)</em></span>.</p><div class="example"><a id="e.g.LittleEndian"></a><p class="title"><strong>Example 5.1. Emulate Little Endian <code class="filename">freetds.conf</code> setting</strong></p><div class="example-contents"><pre class="programlisting"> [mssql] host = ntbox.mydomain.com port = 1433 tds version = 4.2 emulate little endian = yes </pre></div></div><br class="example-break" /></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="odbcdiagnose.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="Localization.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Troubleshooting ODBC connections </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> Localization and <acronym class="acronym">TDS</acronym> 7.0</td></tr></table></div></body></html>