FreeTDS Development Group

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

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.

-- 
Casey Allen Shobe
cshobe AT softhome.net