FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

Ok, let's cut out ODBC and make sure the base package is working.  Grab 
SQSH (http://www.sqsh.org) and build it (instructions are in the users 
guide, but basically just set $SYBASE and then './configure;make').  Let's 
see if that will attach to your server.

Brian

On Sat, 26 Jan 2002, Casey Allen Shobe wrote:

> On Saturday 26 January 2002 22:49, Brian Bruns wrote:
> > The Servername field in the odbc.ini should refer to the symbolic name of
> > your database server in the freetds.conf (recommended) or interfaces file.
> > In your case this is 'pivotal'.
> 
> I tried that.  It is now set that way in the file.
> 
> > The second thing is, you are using the default TDS version, and since you
> > didn't like the configure line used to build FreeTDS it would be 5.0 by
> > default which wont work with SQL Server 2000.
> 
> I used --with-tdsver=4.2.  Here is my installation log:
> 
> unixodbc-2.1.1 installed with the following options on Sat Jan 26 19:56:11 
> EST 2002
>    ./configure --prefix=/usr --sysconfdir=/etc --enable-gui &&
>    make &&
>    make install
> 
> freetds-0.53 installed with the following options on Sat Jan 26 20:49:12 
> EST 
> 2002
>    ./configure --prefix=/usr --sysconfdir=/etc --with-tdsver=4.2 
> --with-unixodbc=/usr &&
>    make &&
>    make install
> 
> > You can either recompile freetds using the --with-tdsver flag, replace
> > "ether" with "4.2" (or "7.0" if you want to use that version), or switch
> > to using the freetds.conf file and set 'tds version = 4.2'.
> 
> I've tried using freetds.conf, however had the same results.  And the 
> instructions that I found at unixodbc.org cover only interfaces, so I stuck 
> with that for the time being.  I'd be happy to try using freetds.conf 
> again.  
> Here's my current backup, does it look correct?:
> 
> [global]
>         tds version = 4.2
>         initial block size = 512
>         swap broken dates = no
>         swap broken money = no
>         try server login = yes
>         try domain login = no
>         cross domain login = no
> [pivotal]
>         host = 192.168.24.182
>         port = 1433
>         tds version = 7.0
> 
>