Skip to Content.
Sympa Menu

freetds - Re: FreeTDS/SQL Server 2000 Woes...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Casey Allen Shobe <cshobe AT softhome.net>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: FreeTDS/SQL Server 2000 Woes...
  • Date: Sat, 26 Jan 2002 23:35:27 -0500


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





Archive powered by MHonArc 2.6.24.

Top of Page