<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <HTML ><HEAD ><TITLE >How to get what works with it working</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REL="HOME" TITLE="FreeTDS User Guide" HREF="index.htm"><LINK REL="PREVIOUS" TITLE="Use FreeTDS " HREF="usefreetds.htm"><LINK REL="NEXT" TITLE="Perl" HREF="perl.htm"><LINK REL="STYLESHEET" TYPE="text/css" HREF="userguide.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8"></HEAD ><BODY CLASS="CHAPTER" 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="usefreetds.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="perl.htm" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="CHAPTER" ><H1 ><A NAME="SOFTWARE" ></A >Chapter 7. How to get what works with it working</H1 ><DIV CLASS="TOC" ><DL ><DT ><B >Table of Contents</B ></DT ><DT ><A HREF="software.htm#SQSH" ><SPAN CLASS="APPLICATION" >SQSH</SPAN ></A ></DT ><DT ><A HREF="perl.htm" >Perl</A ></DT ><DT ><A HREF="php.htm" >PHP</A ></DT ><DT ><A HREF="sybsql.htm" >SybSQL</A ></DT ><DT ><A HREF="python.htm" >Python</A ></DT ><DT ><A HREF="qt.htm" >Qt</A ></DT ><DT ><A HREF="uodbc.htm" >ODBC on Unix</A ></DT ></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" ><H1 CLASS="SECT1" ><A NAME="SQSH" ><SPAN CLASS="APPLICATION" >SQSH</SPAN ></A ></H1 ><P ><SPAN CLASS="APPLICATION" >SQSH</SPAN > is a command line based query tool written by Scott Gray to replace the <B CLASS="COMMAND" >isql</B > 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. <DIV CLASS="TIP" ><P ></P ><TABLE CLASS="TIP" WIDTH="100%" BORDER="0" ><TR ><TD WIDTH="25" ALIGN="CENTER" VALIGN="TOP" ><IMG SRC="../images/tip.gif" HSPACE="5" ALT="Tip"></TD ><TD ALIGN="LEFT" VALIGN="TOP" ><TABLE CLASS="SIDEBAR" BORDER="1" CELLPADDING="5" ><TR ><TD ><DIV CLASS="SIDEBAR" ><P ></P ><A NAME="AEN2573" ></A ><P ><SPAN CLASS="APPLICATION" >SQSH</SPAN > is an excellent tool. Because it uses <SPAN CLASS="SYSTEMITEM" >CT-Library</SPAN >, 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 ><P ></P ></DIV ></TD ></TR ></TABLE ></TD ></TR ></TABLE ></DIV > </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 <B CLASS="COMMAND" >configure</B > in <SPAN CLASS="APPLICATION" >SQSH</SPAN >'s directory (make sure you set the <CODE CLASS="ENVAR" >Sybase</CODE > environment variable first), look for the <TT CLASS="LITERAL" >Sybase_LIBS</TT > definition in the <TT CLASS="FILENAME" >Makefile</TT >. Change the line to match this example. <DIV CLASS="EXAMPLE" ><A NAME="E.G.SQSHMAKE" ></A ><P ><B >Example 7-1. The <SPAN CLASS="APPLICATION" >SQSH</SPAN > Makefile</B ></P ><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 > 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 <B CLASS="COMMAND" >make</B > and you are off and running.</P ></DIV ></DIV ><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="usefreetds.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="perl.htm" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Use <SPAN CLASS="PRODUCTNAME" >FreeTDS</SPAN ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Perl</TD ></TR ></TABLE ></DIV ></BODY ></HTML >