FreeTDS Development Group

[Casey Allen Shobe <cshobe AT softhome.net>]

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

-- 
Casey Allen Shobe
cshobe AT softhome.net