JezK
Edit File: software.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 7. How to get what works with it working</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="usefreetds.html" title="Chapter 6. Use FreeTDS" /><link rel="next" href="perl.html" title="Perl" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Chapter 7. How to get what works with it working</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="usefreetds.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="perl.html">Next</a></td></tr></table><hr /></div><div class="chapter"><div class="titlepage"><div><div><h1 class="title"><a id="software"></a>Chapter 7. How to get what works with it working</h1></div></div></div><div class="toc"><p><strong>Table of Contents</strong></p><dl class="toc"><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></div><p>The following programs are known to work to some extent with <span class="productname">FreeTDS</span>. Here you will find any special instructions for getting them compiled or running.</p><div class="sect1"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="sqsh"></a><span class="application">SQSH</span></h2></div></div></div><p><span class="application">SQSH</span> is a command line based query tool written by Scott Gray to replace the <span class="command"><strong>isql</strong></span> utility that ships with <span class="productname">Sybase ASE</span>. It makes a great diagnostic tool for <span class="productname">FreeTDS</span> as well. If you are having trouble, install <span class="application">SQSH</span> (it's easy) and try getting that to work before more complicated arrangements. </p><div class="tip" style="margin-left: 0.5in; margin-right: 0.5in;"><table border="0" summary="Tip"><tr><td rowspan="2" align="center" valign="top" width="25"><img alt="[Tip]" src="../images/tip.gif" /></td><th align="left">Tip</th></tr><tr><td align="left" valign="top"><div class="sidebar"><div class="titlepage"><div><div><p class="title"><strong></strong></p></div></div></div><p><span class="application">SQSH</span> is an excellent tool. Because it uses <code class="systemitem">CT-Library</code>, it works with <span class="productname">FreeTDS</span>, but potentially — and with significant effort — it could be ported to ODBC and thus made useful for other server environments. Just a thought….</p></div></td></tr></table></div><p> </p><p><span class="application">SQSH</span> 2.1 includes direct support for <span class="productname">FreeTDS</span>, so these instructions may not be necessary, but are still included just in case.</p><p>After running <span class="command"><strong>configure</strong></span> in <span class="application">SQSH</span>'s directory (make sure you set the <code class="envar">Sybase</code> environment variable first), look for the <code class="literal">Sybase_LIBS</code> definition in the <code class="filename">Makefile</code>. Change the line to match this example. </p><div class="example"><a id="e.g.SQSHmake"></a><p class="title"><strong>Example 7.1. The <span class="application">SQSH</span> Makefile</strong></p><div class="example-contents"><pre class="programlisting"> # # The following set of CT-LIB libraries were determined automatically # by 'configure'. For most systems configure looks up the required # libraries by looking at the name of the OS (although this doesn't # mean it got them right), however if the line below ends with the # word "Guess", then 'configure' didn't have an entry for your operating # system and it took a best guess to figure out which libraries you # need. In either case, there may be problems, so look this line over # and if it doesn't work, compare it to the libraries located in # $SYBASE/samples/ct-library. # # The listings below show suggested libraries for Operating Systems # that frequently fail to be recognized by 'configure': # # SCO: -lblk -lct -lcs -lcomn -ltcl -ltli -lnsl_s -lintl -m -lsocket # Dynix: -lblk -lct -lcs -lcomn -ltcl -ltli -lnsl -lintl -lm -lseq # SYBASE_LIBS = -lct -ldl -lm </pre></div></div><p><br class="example-break" /> At this point you can also enable <span class="application">readline</span> support if you didn't specify it in the <span class="application">configure</span> arguments.</p><p>After that just type <span class="command"><strong>make</strong></span> and you are off and running.</p></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="usefreetds.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="perl.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Chapter 6. Use <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"> Perl</td></tr></table></div></body></html>