Update - Still working on this one.
tsql will connect to and query MS box when either ip address is used instead of server name or server MS box is added to /etc/hosts.
No sucsess with isql however.
here are the configuration files:
# cat freetds.conf
[global]
# TDS protocol version
tds version = 4.2
[mypool]
host = 127.0.0.1
port = 5000
tds version = 4.2
# Microsoft SQL Server 2000 configuration
[MSSQL01]
host = drogo1
port = 1433
tds version = 8.0
# cat odbcinst.ini
[FreeTDS]
Description = FreeTDS Driver (MS-SQL access)
Driver = /usr/lib/libtdsodbc.so
# cat odbc.ini
[ODBC Data Sources]
MSSQL01 = Connection to the JESE DB
[MSSQL01]
Driver = /usr/lib/libtdsodbc.so
Description = Connection to the JESE DB
Trace = No
Server = 192.168.2.10
Database = JESE
Port = 1433
TDS_Version = 8.0
[Default]
Driver = /usr/lib/libtdsodbc.so
# odbcinst -j
unixODBC 2.2.11
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini
# odbcinst -q -d
[FreeTDS]
# odbcinst -q -s
[MSSQL01]
[Default]
#
when i run isql, this is what happens:
# isql -v MSSQL01 sa 12345678
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
#
using strace, i get the following:
# strace -e connect isql MSSQL01 sa 12345678
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
[ISQL]ERROR: Could not SQLConnect
On investigation, I determine that the directory nscd is not present in /var/run.
I add the directories nscd/socket to /var/run/ and re-run the strace:
# strace -e connect isql MSSQL01 sa 12345678
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ECONNREFUSED (Connection refused)
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ECONNREFUSED (Connection refused)
[ISQL]ERROR: Could not SQLConnect
#
I'm looking for suggestions that may help to narrow the problem domain.....
All input most welcome.