FreeTDS Development Group

[Craig Spannring <cts AT internetcds.com>]

By default it tries to connect to the default Sybase port.  You can
either configure it to default to SQLServer or you can set an
environment variable to tell it which protocol version it should use.

To configure SQLServer as the default go to the top level directory
and run 

    ./configure --with-tdsver=4.2
    gmake
    gmake install 

Otherwise you can set the environment variable DBLIB_PORT to the port
your server listens on.  Set DBLIB_VERSION to let any of the dblib
routines know which protocol version you want to use.

Note-  The port setting in the interfaces file will override these
methods for logical servers.

As far as which library you should use I would recommend dblib.

tds is a low level way of accessing the server.  Generally you want to
avoid this because it requires knowledge of the TDS protocol.  dblib
and ctlib are built on top of tds.  dblib was the original API for
Sybase and Microsoft.  ctlib is Sybase's newer API.  It has never been
implemented or supplied by Microsoft.  

You might also want to check out the FreeTDS JDBC driver available
from ftp://freetds.internetcds.com/pub/freetds_jdbc.


-- 
=======================================================================
 Life is short.                  | Craig Spannring 
      Ski hard, Bike fast.       | cts AT internetcds.com
 --------------------------------+------------------------------------
 Any sufficiently perverted technology is indistinguishable from Perl.
=======================================================================