Skip to Content.
Sympa Menu

freetds - 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: freetds AT franklin.oit.unc.edu
  • Subject: FreeTDS/SQL Server 2000 Woes...
  • Date: Sat, 26 Jan 2002 22:06:36 -0500


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




Archive powered by MHonArc 2.6.24.

Top of Page