<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.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"></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 ></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="AEN2236" ></A ><P >That advice is so good, it bears repeating. If you are having trouble, grab <SPAN CLASS="APPLICATION" >SQSH</SPAN > and get that to work. Not only will it help isolate the problem, it will give you a very capable tool. </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 Sybase environment variable first), look for the Sybase_LIBS definition in the Makefile. 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 >