JezK
Edit File: index.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>FreeTDS User Guide</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="next" href="about.html" title="About this User Guide" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center"><span class="productname">FreeTDS</span> User Guide</th></tr><tr><td width="20%" align="left"> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="about.html">Next</a></td></tr></table><hr /></div><div class="book"><div class="titlepage"><div><div><h1 class="title"><a id="idm1"></a><span class="productname">FreeTDS<br /></span> User Guide</h1></div><div><h2 class="subtitle">A Guide to Installing, Configuring, and Running <span class="productname">FreeTDS<br /></span></h2></div><div><div class="author"><h3 class="author"><span class="firstname">Brian</span> <span class="surname">Bruns</span></h3></div></div><div><div class="author"><h3 class="author"><span class="firstname">James</span> <span class="othername">K.</span> <span class="surname">Lowden</span></h3></div></div><div><div class="author"><h3 class="author"><span class="firstname">Frediano</span> <span class="surname">Ziglio</span></h3></div></div><div><p class="copyright">Copyright © 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011 Brian Bruns and James K. Lowden</p></div><div><p class="copyright">Copyright © 2015, 2016, 2017, 2018, 2019 Frediano Ziglio</p></div><div><div class="legalnotice"><a id="idm38"></a><p>Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.1 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts. A copy of the license is included in the section entitled <a class="link" href="gfdl.html" title="Appendix D. GNU Free Documentation License">GNU Free Documentation License</a>.</p></div></div></div><hr /></div><div class="toc"><p><strong>Table of Contents</strong></p><dl class="toc"><dt><span class="preface"><a href="about.html">About this User Guide</a></span></dt><dt><span class="chapter"><a href="what.html">1. What is <span class="productname">FreeTDS</span>?</a></span></dt><dd><dl><dt><span class="sect1"><a href="what.html#tdsprotocolhist">Background: The <acronym class="acronym">TDS</acronym> Protocol and related <acronym class="acronym">API</acronym>s </a></span></dt><dt><span class="sect1"><a href="tdshistory.html">History of <acronym class="acronym">TDS</acronym> Versions</a></span></dt><dt><span class="sect1"><a href="FreeTDShistory.html">History of <span class="productname">FreeTDS</span></a></span></dt><dt><span class="sect1"><a href="projects.html">Current Projects, Language Bindings, and Alternatives</a></span></dt><dd><dl><dt><span class="sect2"><a href="projects.html#Current">Current Projects</a></span></dt><dt><span class="sect2"><a href="projects.html#Status">Status</a></span></dt><dt><span class="sect2"><a href="projects.html#Languages">Languages besides C</a></span></dt><dt><span class="sect2"><a href="projects.html#alternatives">Alternatives</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="build.html">2. Build <span class="productname">FreeTDS</span></a></span></dt><dd><dl><dt><span class="sect1"><a href="build.html#gnu">The <acronym class="acronym">GNU</acronym> World</a></span></dt><dt><span class="sect1"><a href="packages.html">What to build: Packages, Tarballs, and the <span class="productname">git</span> repository</a></span></dt><dt><span class="sect1"><a href="config.html">How to build: Configure and make</a></span></dt><dd><dl><dt><span class="sect2"><a href="config.html#Experts">For Experts</a></span></dt><dt><span class="sect2"><a href="config.html#Everyone">(<span class="productname">FreeTDS</span> for Dummies?)</a></span></dt></dl></dd><dt><span class="sect1"><a href="osissues.html">OS-specific Issues</a></span></dt><dd><dl><dt><span class="sect2"><a href="osissues.html#Windows">Win32 and Win64</a></span></dt><dt><span class="sect2"><a href="osissues.html#VMS">VMS®</a></span></dt><dt><span class="sect2"><a href="osissues.html#osx">OS X®</a></span></dt><dt><span class="sect2"><a href="osissues.html#AIX">AIX®</a></span></dt><dt><span class="sect2"><a href="osissues.html#RPM">GNU/Linux distributions that use RPMs</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="install.html">3. Install <span class="productname">FreeTDS</span></a></span></dt><dd><dl><dt><span class="sect1"><a href="install.html#LocalEnvironment">The local environment</a></span></dt><dt><span class="sect1"><a href="ChoosingTdsProtocol.html">Choosing a <acronym class="acronym">TDS</acronym> protocol version</a></span></dt><dd><dl><dt><span class="sect2"><a href="ChoosingTdsProtocol.html#idm896">Choosing protocol version since <span class="productname">FreeTDS</span> 1.1</a></span></dt><dt><span class="sect2"><a href="ChoosingTdsProtocol.html#idm902">Choosing protocol version before <span class="productname">FreeTDS</span> 1.1</a></span></dt><dt><span class="sect2"><a href="ChoosingTdsProtocol.html#idm970">Regarding obsolete versions</a></span></dt></dl></dd><dt><span class="sect1"><a href="name.lookup.html"><em class="replaceable"><code>servername</code></em> Lookup</a></span></dt><dt><span class="sect1"><a href="freetdsconf.html">The <code class="filename">freetds.conf</code> file</a></span></dt><dd><dl><dt><span class="sect2"><a href="freetdsconf.html#freetdsconfpurpose">What it does</a></span></dt><dt><span class="sect2"><a href="freetdsconf.html#freetdsconflocation">Where it goes</a></span></dt><dt><span class="sect2"><a href="freetdsconf.html#freetdsconfformat">What it looks like</a></span></dt></dl></dd><dt><span class="sect1"><a href="locales.html">The <code class="filename">locales.conf</code> file</a></span></dt><dd><dl><dt><span class="sect2"><a href="locales.html#localespurpose">What it does</a></span></dt><dt><span class="sect2"><a href="locales.html#localeslocation">Where it goes</a></span></dt><dt><span class="sect2"><a href="locales.html#localesformat">What it looks like</a></span></dt></dl></dd><dt><span class="sect1"><a href="envvar.html">Environment variables</a></span></dt><dd><dl><dt><span class="sect2"><a href="envvar.html#Whatfor">What they're for</a></span></dt><dt><span class="sect2"><a href="envvar.html#Setting">Setting environment variables</a></span></dt><dt><span class="sect2"><a href="envvar.html#Checking">Checking your work</a></span></dt></dl></dd><dt><span class="sect1"><a href="PortOverride.html">Port/instance override syntax</a></span></dt><dt><span class="sect1"><a href="ConfirmInstall.html">Confirm the installation</a></span></dt><dd><dl><dt><span class="sect2"><a href="ConfirmInstall.html#tsql"><span class="application">tsql</span></a></span></dt><dt><span class="sect2"><a href="ConfirmInstall.html#Tests"><span class="application">Unit Tests</span></a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="prepodbc.html">4. Preparing ODBC</a></span></dt><dd><dl><dt><span class="sect1"><a href="prepodbc.html#OdbcBackground">Background and Terminology</a></span></dt><dt><span class="sect1"><a href="OdbcConnAttr.html">Connection attributes</a></span></dt><dt><span class="sect1"><a href="dsnless.html">DSN-less configuration</a></span></dt><dt><span class="sect1"><a href="odbcinionly.html">ODBC-only configuration</a></span></dt><dt><span class="sect1"><a href="odbcombo.html">ODBC-combined configuration</a></span></dt><dt><span class="sect1"><a href="odbcdiagnose.html">Troubleshooting ODBC connections</a></span></dt><dd><dl><dt><span class="sect2"><a href="odbcdiagnose.html#with.iodbc">With iODBC</a></span></dt><dt><span class="sect2"><a href="odbcdiagnose.html#with.unixODBC">With unixODBC</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="configs.html">5. Advanced Configurations</a></span></dt><dd><dl><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></dd><dt><span class="chapter"><a href="usefreetds.html">6. Use <span class="productname">FreeTDS</span> </a></span></dt><dd><dl><dt><span class="sect1"><a href="usefreetds.html#utilities"><span class="productname">FreeTDS</span> Utilities</a></span></dt></dl></dd><dt><span class="chapter"><a href="software.html">7. How to get what works with it working</a></span></dt><dd><dl><dt><span class="sect1"><a href="software.html#sqsh"><span class="application">SQSH</span></a></span></dt><dt><span class="sect1"><a href="perl.html">Perl</a></span></dt><dd><dl><dt><span class="sect2"><a href="perl.html#DBD.ODBC">DBD::ODBC</a></span></dt><dt><span class="sect2"><a href="perl.html#DBD.Sybase">DBD::Sybase</a></span></dt><dt><span class="sect2"><a href="perl.html#Sybperl">Sybperl</a></span></dt><dt><span class="sect2"><a href="perl.html#Perlmodules">Building and using the Perl modules</a></span></dt></dl></dd><dt><span class="sect1"><a href="php.html">PHP</a></span></dt><dd><dl><dt><span class="sect2"><a href="php.html#phpDblib"><code class="systemitem">DB-Library</code></a></span></dt><dt><span class="sect2"><a href="php.html#ctlib"><code class="systemitem">CT-Library</code></a></span></dt><dt><span class="sect2"><a href="php.html#ODBC"><code class="systemitem">ODBC</code></a></span></dt></dl></dd><dt><span class="sect1"><a href="Python.html">Python</a></span></dt><dd><dl><dt><span class="sect2"><a href="Python.html#pymssql">pymssql</a></span></dt><dt><span class="sect2"><a href="Python.html#Sybase.Python.Module">Sybase module</a></span></dt></dl></dd><dt><span class="sect1"><a href="qt.html">Qt</a></span></dt><dt><span class="sect1"><a href="uodbc.html">ODBC on Unix</a></span></dt><dd><dl><dt><span class="sect2"><a href="uodbc.html#uodbc.64">ODBC and 64-bit</a></span></dt><dt><span class="sect2"><a href="uodbc.html#uodbc.wchar">sizeof(SQLWCHAR)</a></span></dt><dt><span class="sect2"><a href="uodbc.html#uodbc.char">Default charset</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="troubleshooting.html">8. Troubleshooting</a></span></dt><dd><dl><dt><span class="sect1"><a href="troubleshooting.html#knownissues">Known Issues</a></span></dt><dd><dl><dt><span class="sect2"><a href="troubleshooting.html#known.porting">Porting Issues</a></span></dt><dt><span class="sect2"><a href="troubleshooting.html#Textfields"><span class="type">Text</span> Fields</a></span></dt><dt><span class="sect2"><a href="troubleshooting.html#Endianism">Endianism</a></span></dt><dt><span class="sect2"><a href="troubleshooting.html#Datetime"><span class="type">Datetime</span> and <span class="type">Money</span></a></span></dt><dt><span class="sect2"><a href="troubleshooting.html#IntegratedSecurity">Microsoft's <span class="quote">“<span class="quote">Integrated Security</span>”</span></a></span></dt></dl></dd><dt><span class="sect1"><a href="serverthere.html">Is the server there?</a></span></dt><dd><dl><dt><span class="sect2"><a href="serverthere.html#serverthere.ping">Start with <span class="command"><strong>ping</strong></span></a></span></dt><dt><span class="sect2"><a href="serverthere.html#serverthere.telnet">Test with <span class="command"><strong>telnet</strong></span></a></span></dt><dt><span class="sect2"><a href="serverthere.html#serverthere.tsql">Test with <span class="command"><strong>tsql</strong></span></a></span></dt></dl></dd><dt><span class="sect1"><a href="logging.html">Logging</a></span></dt><dd><dl><dt><span class="sect2"><a href="logging.html#Environment">Environment Variables that Control Logging</a></span></dt><dt><span class="sect2"><a href="logging.html#Logging.freetds.conf"><code class="filename">freetds.conf</code> variables that Control Logging</a></span></dt><dt><span class="sect2"><a href="logging.html#Logging.odbc">Logging in ODBC land</a></span></dt></dl></dd><dt><span class="sect1"><a href="pagenodata.html">"Page contains no data"</a></span></dt><dt><span class="sect1"><a href="seemtooslow.html">Slow connection or data retrieval</a></span></dt></dl></dd><dt><span class="chapter"><a href="help.html">9. Getting Help</a></span></dt><dd><dl><dt><span class="sect1"><a href="help.html#reconfirm.installation">Reconfirm the installation</a></span></dt><dt><span class="sect1"><a href="IsolateCause.html">Isolate the cause</a></span></dt><dd><dl><dt><span class="sect2"><a href="IsolateCause.html#help.otherclient">Try a different client</a></span></dt><dt><span class="sect2"><a href="IsolateCause.html#help.permissions">Check permissions</a></span></dt></dl></dd><dt><span class="sect1"><a href="mailinglist.html">The Mailing List</a></span></dt><dd><dl><dt><span class="sect2"><a href="mailinglist.html#Archive">The Archive</a></span></dt><dt><span class="sect2"><a href="mailinglist.html#Asklist">Ask the list</a></span></dt></dl></dd><dt><span class="sect1"><a href="askingforhelp.html">What to include when asking for help</a></span></dt><dd><dl><dt><span class="sect2"><a href="askingforhelp.html#Waddyagot">Waddya got?</a></span></dt><dt><span class="sect2"><a href="askingforhelp.html#help.log">Attach a logfile</a></span></dt><dt><span class="sect2"><a href="askingforhelp.html#ShowYourWork">Show your work</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="contrib.html">10. Helping</a></span></dt><dd><dl><dt><span class="sect1"><a href="contrib.html#Pickweakspot">Pick a weak spot and fix it.</a></span></dt><dd><dl><dt><span class="sect2"><a href="contrib.html#Sendpatch">Send a patch</a></span></dt><dt><span class="sect2"><a href="contrib.html#Correct">Correct this User Guide</a></span></dt><dt><span class="sect2"><a href="contrib.html#Documentapi">Document an <acronym class="acronym">API</acronym></a></span></dt><dt><span class="sect2"><a href="contrib.html#webmaster">Be the Webmaster</a></span></dt></dl></dd><dt><span class="sect1"><a href="Light.taper.html">Light another's taper</a></span></dt><dt><span class="sect1"><a href="Ambition.html">Ambitious ideas</a></span></dt><dd><dl><dt><span class="sect2"><a href="Ambition.html#idm3666"><code class="literal">libtds2</code></a></span></dt><dt><span class="sect2"><a href="Ambition.html#idm3673"><code class="literal">libstddb</code></a></span></dt><dt><span class="sect2"><a href="Ambition.html#idm3678">Server code </a></span></dt></dl></dd><dt><span class="sect1"><a href="Advocacy.html">Advocacy</a></span></dt></dl></dd><dt><span class="chapter"><a href="programming.html">11. Programming</a></span></dt><dd><dl><dt><span class="sect1"><a href="programming.html#TDSprotocolref">TDS protocol reference</a></span></dt><dt><span class="sect1"><a href="apireference.html">API Reference Manual</a></span></dt><dt><span class="sect1"><a href="dblib.api.summary.html"><code class="systemitem">DB-Library</code> API Implementation Summary</a></span></dt><dt><span class="sect1"><a href="ctlib.api.summary.html">ct-lib API Implementation Summary</a></span></dt><dt><span class="sect1"><a href="odbc.api.summary.html">ODBC API Implementation Summary</a></span></dt><dt><span class="sect1"><a href="samplecode.html">DB-Library for the Tenderfoot</a></span></dt><dd><dl><dt><span class="sect2"><a href="samplecode.html#samplecode.include">Header files</a></span></dt><dt><span class="sect2"><a href="samplecode.html#samplecode.prolog">Prolog</a></span></dt><dt><span class="sect2"><a href="samplecode.html#samplecode.init">Initialize</a></span></dt><dt><span class="sect2"><a href="samplecode.html#samplecode.connect">Connect to the server</a></span></dt><dt><span class="sect2"><a href="samplecode.html#samplecode.query">Send a query</a></span></dt><dt><span class="sect2"><a href="samplecode.html#samplecode.results">Fetch Results</a></span></dt><dt><span class="sect2"><a href="samplecode.html#samplecode.errors">Messages and Errors</a></span></dt><dt><span class="sect2"><a href="samplecode.html#samplecode.wrapup">Last Remarks</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="acknowledgments.html">12. Acknowledgments</a></span></dt><dd><dl><dt><span class="sect1"><a href="acknowledgments.html#Codesmyths">Codesmyths</a></span></dt><dt><span class="sect1"><a href="Contributors.html">Contributors</a></span></dt></dl></dd><dt><span class="appendix"><a href="rtl.html">A. On Linkers</a></span></dt><dd><dl><dt><span class="section"><a href="rtl.html#rtl.define.function">What is a C function?</a></span></dt><dt><span class="section"><a href="rtl.define.library.html">What is a C library?</a></span></dt><dd><dl><dt><span class="section"><a href="rtl.define.library.html#rtl.define.library.static">Static libraries</a></span></dt><dt><span class="section"><a href="rtl.define.library.html#rtl.define.library.dynamic">Dynamic libraries</a></span></dt></dl></dd><dt><span class="section"><a href="linker.library.check.html">Checking if a Library Provides a Function</a></span></dt><dt><span class="section"><a href="linker.how.html">How Dost Thy Linker Link? </a></span></dt><dd><dl><dt><span class="section"><a href="linker.how.html#idm6696">Static Linker</a></span></dt><dt><span class="section"><a href="linker.how.html#linker.dynamic">Dynamic Linker</a></span></dt></dl></dd><dt><span class="section"><a href="linker.conclusion.html">Keep in Mind</a></span></dt></dl></dd><dt><span class="appendix"><a href="interfacesfile.html">B. The <code class="filename">interfaces</code> File</a></span></dt><dd><dl><dt><span class="sect1"><a href="interfacesfile.html#interfacesorigin">Where it came from</a></span></dt><dt><span class="sect1"><a href="interfaceslocation.html">Where it goes</a></span></dt><dt><span class="sect1"><a href="interfacespurpose.html">What it does</a></span></dt><dt><span class="sect1"><a href="interfacesformat.html">What it looks like</a></span></dt></dl></dd><dt><span class="appendix"><a href="AboutUnicode.html">C. About Unicode, UCS-2, and UTF-8</a></span></dt><dd><dl><dt><span class="section"><a href="AboutUnicode.html#ascii"><acronym class="acronym">ASCII</acronym>: What everyone knows</a></span></dt><dd><dl><dt><span class="section"><a href="AboutUnicode.html#ASCIICompact">The <acronym class="acronym">ASCII</acronym> Compact</a></span></dt></dl></dd><dt><span class="section"><a href="ISO8859.html">ISO 8859: What everyone would like to forget</a></span></dt><dt><span class="section"><a href="Unicode.html">Unicode: East meets West</a></span></dt><dt><span class="section"><a href="Unicodegoodbad.html">Unicode's Pluses and Minuses</a></span></dt><dt><span class="section"><a href="UnicodeUtf.html">Unicode Transformation Format: UTF-8</a></span></dt><dt><span class="section"><a href="UnicodeFreeTDS.html">Unicode and <span class="productname">FreeTDS</span></a></span></dt><dd><dl><dt><span class="section"><a href="UnicodeFreeTDS.html#moreinfo">For further information</a></span></dt></dl></dd></dl></dd><dt><span class="appendix"><a href="gfdl.html">D. GNU Free Documentation License</a></span></dt><dd><dl><dt><span class="sect1"><a href="gfdl.html#gfdl-0">PREAMBLE</a></span></dt><dt><span class="sect1"><a href="gfdl-1.html">APPLICABILITY AND DEFINITIONS</a></span></dt><dt><span class="sect1"><a href="gfdl-2.html">VERBATIM COPYING</a></span></dt><dt><span class="sect1"><a href="gfdl-3.html">COPYING IN QUANTITY</a></span></dt><dt><span class="sect1"><a href="gfdl-4.html">MODIFICATIONS</a></span></dt><dt><span class="sect1"><a href="gfdl-5.html">COMBINING DOCUMENTS</a></span></dt><dt><span class="sect1"><a href="gfdl-6.html">COLLECTIONS OF DOCUMENTS</a></span></dt><dt><span class="sect1"><a href="gfdl-7.html">AGGREGATION WITH INDEPENDENT WORKS</a></span></dt><dt><span class="sect1"><a href="gfdl-8.html">TRANSLATION</a></span></dt><dt><span class="sect1"><a href="gfdl-9.html">TERMINATION</a></span></dt><dt><span class="sect1"><a href="gfdl-10.html">FUTURE REVISIONS OF THIS LICENSE</a></span></dt><dt><span class="sect1"><a href="gfdl-11.html">How to use this License for your documents</a></span></dt></dl></dd></dl></div><div class="list-of-tables"><p><strong>List of Tables</strong></p><dl><dt>3.1. <a href="ChoosingTdsProtocol.html#tab.Protocol.by.Product">Versions of the <acronym class="acronym">TDS</acronym> Protocol, by Product</a></dt><dt>3.2. <a href="ChoosingTdsProtocol.html#tab.Protocol.by.SQLServerProduct">What Version of the <acronym class="acronym">TDS</acronym> Protocol Should I use with Microsoft SQL Server?</a></dt><dt>3.3. <a href="freetdsconf.html#tab.freetds.conf"><code class="filename">freetds.conf</code> settings</a></dt><dt>3.4. <a href="freetdsconf.html#tab.freetds.conf.debugflags">Valid bitmask values for <code class="literal">debug flags</code> entry in <code class="filename">freetds.conf</code></a></dt><dt>4.1. <a href="OdbcConnAttr.html#tab.Connection.attributes.stringonly">Connection attributes used only in connection strings</a></dt><dt>4.2. <a href="OdbcConnAttr.html#tab.Connection.attributes.freetds.conf">Connection attributes that may appear in <code class="filename">odbc.ini</code></a></dt><dt>5.1. <a href="tdspool.html#tab.pool.conf">pool.conf settings</a></dt><dt>11.1. <a href="dblib.api.summary.html#dblib.api"><code class="systemitem">DB-Library</code> API Implementation Summary</a></dt><dt>11.2. <a href="ctlib.api.summary.html#ctlib.api"><code class="systemitem">CT-Library</code> API Implementation Summary</a></dt><dt>11.3. <a href="odbc.api.summary.html#odbc.api"><code class="systemitem">ODBC</code> API Implementation Summary</a></dt><dt>11.4. <a href="samplecode.html#tab.kinds.of.results">Kinds of Results</a></dt><dt>11.5. <a href="samplecode.html#tab.result.fetching.functions">Result-fetching functions</a></dt><dt>11.6. <a href="samplecode.html#tab.data.fetching.functions">Data-fetching functions</a></dt><dt>11.7. <a href="samplecode.html#tab.putting.it.all.together">Putting it all together </a></dt><dt>B.1. <a href="interfacesformat.html#tab.Services.Line">Services Line</a></dt></dl></div><div class="list-of-examples"><p><strong>List of Examples</strong></p><dl><dt>3.1. <a href="freetdsconf.html#e.g.freetdsconf">A <code class="filename">freetds.conf</code> file example</a></dt><dt>3.2. <a href="ConfirmInstall.html#e.g.tsqlShowsettings">Show compile-time settings with <span class="command">tsql</span></a></dt><dt>3.3. <a href="ConfirmInstall.html#e.g.notfound">Failure to find <em class="replaceable"><code>servername</code></em> in <code class="filename">freetds.conf</code></a></dt><dt>3.4. <a href="ConfirmInstall.html#e.g.badname">Failure to resolve hostname for <em class="replaceable"><code>servername</code></em></a></dt><dt>3.5. <a href="ConfirmInstall.html#e.g.noconnect">Failing to connect with tsql</a></dt><dt>3.6. <a href="ConfirmInstall.html#e.g.instance.name">Getting instance information with tsql</a></dt><dt>3.7. <a href="ConfirmInstall.html#e.g.bad.tdsver">Using the wrong protocol for the server</a></dt><dt>3.8. <a href="ConfirmInstall.html#e.g.bad.login">Login failure</a></dt><dt>3.9. <a href="ConfirmInstall.html#e.g.tsqlhostname">Connect with <span class="command">tsql</span> using a hostname and port number</a></dt><dt>4.1. <a href="dsnless.html#e.g.SampleDSNless">Sample files for a DSN-less configuration</a></dt><dt>4.2. <a href="dsnless.html#e.g.ConnectDSNless">Connecting with a DSN-less configuration</a></dt><dt>4.3. <a href="dsnless.html#e.g.ConnectDSNlessnoconf">Connecting with a DSN-less configuration that does not use <code class="filename">freetds.conf</code></a></dt><dt>4.4. <a href="odbcinionly.html#e.g.SampleODBConly">Sample ODBC-only <code class="filename">odbc.ini</code> file</a></dt><dt>4.5. <a href="odbcombo.html#e.g.SampleODBCcombo">Sample ODBC-combined <code class="filename">odbc.ini</code> file</a></dt><dt>4.6. <a href="odbcombo.html#e.g.samplecombofile">Sample ODBC-combined <code class="filename">freetds.conf</code> file</a></dt><dt>4.7. <a href="odbcdiagnose.html#e.g.odbctest.nodm">Compile <code class="filename">odbctest</code> without a driver manager.</a></dt><dt>4.8. <a href="odbcdiagnose.html#e.g.odbcdiagnose.osql">Use <span class="command">osql</span> to test the ODBC setup.</a></dt><dt>5.1. <a href="configs.html#e.g.LittleEndian">Emulate Little Endian <code class="filename">freetds.conf</code> setting</a></dt><dt>5.2. <a href="Localization.html#e.g.GREEK">Configuring for GREEK <code class="filename">freetds.conf</code> setting</a></dt><dt>5.3. <a href="Localization.html#e.g.UTF8">Configuring for <acronym class="acronym">UTF-8</acronym> <code class="filename">freetds.conf</code> setting</a></dt><dt>5.4. <a href="domains.html#e.g.domainlogin">Logging in with a domain login</a></dt><dt>5.5. <a href="uothread.html#odbcinstthread">Sample <code class="filename">odbcinst.ini</code> for threading model</a></dt><dt>5.6. <a href="uothread.html#odbcinithread">Sample <code class="filename">odbc.ini</code> for threading model</a></dt><dt>5.7. <a href="appendmode.html#e.g.DumpAppend">Turning on Dump File Append mode in <code class="filename">freetds.conf</code></a></dt><dt>5.8. <a href="tdspool.html#e.g.pool.conf">pool.conf</a></dt><dt>5.9. <a href="stunnel.html#e.g.Unencrypted">Unencrypted entry in <code class="filename">freetds.conf</code></a></dt><dt>5.10. <a href="stunnel.html#e.g.Encrypted">Encrypted entry in <code class="filename">freetds.conf</code></a></dt><dt>7.1. <a href="software.html#e.g.SQSHmake">The <span class="application">SQSH</span> Makefile</a></dt><dt>7.2. <a href="perl.html#e.g.DBD.ODBC.build">Building <code class="systemitem">DBD::ODBC</code></a></dt><dt>7.3. <a href="perl.html#e.g.DBD.ODBC.connect">Connect to a server with <code class="systemitem">DBD::ODBC</code></a></dt><dt>7.4. <a href="perl.html#e.g.DBD.Sybase.build">Building <code class="systemitem">DBD::Sybase</code></a></dt><dt>7.5. <a href="perl.html#e.g.DBD.Sybase.Connect">Connect to a server with <code class="systemitem">DBD::Sybase</code></a></dt><dt>7.6. <a href="php.html#e.g.PHP.dblib">PHP and <code class="systemitem">DB-Library</code> for <span class="quote">“<span class="quote">Sybase</span>”</span></a></dt><dt>8.1. <a href="serverthere.html#e.g.troubleshooting.ping">Finding the server's host</a></dt><dt>8.2. <a href="serverthere.html#e.g.troubleshooting.telnet">Finding the server</a></dt><dt>8.3. <a href="serverthere.html#e.g.troubleshooting.tsql.noconf">Connecting to the server, bypassing <code class="filename">freetds.conf</code></a></dt><dt>8.4. <a href="serverthere.html#e.g.troubleshooting.tsql">Connecting to the server using <code class="filename">freetds.conf</code></a></dt><dt>11.1. <a href="samplecode.html#idm5895">Building the Sample Code</a></dt><dt>11.2. <a href="samplecode.html#e.g.samplecode.dblib.include">Sample Code: <code class="systemitem">DB-Library</code> header files</a></dt><dt>11.3. <a href="samplecode.html#e.g.samplecode.dblib.prolog">Sample Code: <code class="systemitem">DB-Library</code> prolog</a></dt><dt>11.4. <a href="samplecode.html#e.g.samplecode.dblib.Initialize">Sample Code: <code class="systemitem">DB-Library</code> Initialize</a></dt><dt>11.5. <a href="samplecode.html#e.g.samplecode.dblib.Connect">Sample Code: <code class="systemitem">DB-Library</code> Connect to the server</a></dt><dt>11.6. <a href="samplecode.html#e.g.samplecode.dblib.send">Sample Code: <code class="systemitem">DB-Library</code> Send a query</a></dt><dt>11.7. <a href="samplecode.html#e.g.samplecode.dblib.fetch">Sample Code: <code class="systemitem">DB-Library</code> Fetch Results</a></dt><dt>11.8. <a href="samplecode.html#e.g.samplecode.dblib.errors">Sample Code: <code class="systemitem">DB-Library</code> Error and Message handlers</a></dt><dt>A.1. <a href="linker.how.html#idm6719">Missing library name</a></dt><dt>A.2. <a href="linker.how.html#idm6730">Library not found</a></dt><dt>B.1. <a href="interfacesformat.html#e.g.interfacesfile">An <code class="filename">interfaces</code> file example</a></dt><dt>C.1. <a href="UnicodeUtf.html#e.g.HELLO"><span class="quote">“<span class="quote">HELLO</span>”</span> in UCS-2 and UTF-8</a></dt></dl></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="about.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top"> </td><td width="20%" align="center"> </td><td width="40%" align="right" valign="top"> About this User Guide</td></tr></table></div></body></html>