FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

Hi,

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'.

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.

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'.

Brian

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

> Yep, I posted under this same subject some time back, but unfortunately 
> lost 
> the previous thread; never was successful; and am now trying the same thing 
> on a new machine:
> 
> Setup:
> 
> Server:
>   Windows 2000 Server
>   SQL Server 2000
> 
> Client:
>   Linux-from-scratch, kernel 2.4.17, glibc-2.2.4
>   FreeTDS 0.53
>   DB2 Connect Client 7.1
>   unixODBC 2.1.1
> 
> I have configured unixODBC to use both DB2 and MSSQL.  Here are my config 
> files:
> 
> odbc.ini:
> [sw_p]
> Description     = Production DB2 Database
> Driver          = DB2
> 
> [pivotal]
> Driver          = TDS
> Description     = Pivotal Test Database
> Trace           = No
> Servername      = 192.168.24.182
> Database        = beta_ed
> UID             = cshobe
> 
> odbcinst.ini:
> [DB2]
> Description     = IBM DB2 Connect
> Driver          = /usr/IBMdb2/V7.1/lib/libdb2.so
> FileUsage       = 1
> DontDLClose     = 1
> 
> [TDS]
> Description     = v0.53 with protocol v4.2
> Driver          = /usr/lib/libtdsodbc.so
> FileUsage       = 1
> 
> interfaces:
> pivotal
>         query tcp ether 192.168.24.182 1433
>         master tcp ether 192.168.24.182 1433
> 
> The server supports mixed-mode authentication (previously domain only).
> 
> root:/etc# isql -v sw_p db2inst1 <passwd>
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
> SQL> quit
> root:/etc# isql -v pivotal cshobe <passwd>
> [unixODBC]tds_connect failed
> [ISQL]ERROR: Could not SQLConnect
> 
> any advice of what to do at this stage would be very very much appreciated.
> 
>