unixODBC connection not working while tsql does

"Bos, Roger" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <D8C95B444AD6EE4AAD638D818A9CFD3404D68252@RINNYCSE000.rth.ad.rothschild.com>
All,

I am trying to connect to a MS SQL server from a machine running Ubuntu
10.10 using freeTDS.  The tsql connection works using freetds.conf, but
when I try to use osql it does not connect, giving the error: osql:
error: no potential directory strings in "/usr/bin/isql"
isql strings are:
+ /lib64/ld-linux-x86-64.so.2. 

Here is my output.  Thanks in advance for any assistance you can provide
me!


bosr@bosr-linux:/usr/bin$ strace -e connect osql -S XF -U xfl -P xfl
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
osql: error: no potential directory strings in "/usr/bin/isql"
isql strings are:
--- SIGCHLD (Child exited) @ 0 (0) ---
--- SIGCHLD (Child exited) @ 0 (0) ---
+ /lib64/ld-linux-x86-64.so.2
--- SIGCHLD (Child exited) @ 0 (0) ---
bosr@bosr-linux:/usr/bin$ 


bosr@bosr-linux:/usr/bin$ cat /etc/odbc.ini
[xf]
Driver  	= /usr/local/freetds/lib/libtdsodbc.so
Description     = XF
Trace   	= YES
Server      	= rinnycs0053.rth.ad.rothschild.com
Port      	= 1433
TDS_Version     = 8.0
USER         	= xfl
Password     	= pwd
Database        = xf 

[Default]
Driver          = /usr/local/freetds/lib/libtdsodbc.so
bosr@bosr-linux:/usr/bin$ 



bosr@bosr-linux:/usr/bin$ tsql -S xfdr -U xfl -P pwd
locale is "en_US.utf8"
locale charset is "UTF-8"
1> exit
bosr@bosr-linux:/usr/bin$ cat /etc/freetds.conf
#   $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $
#
# This file is installed by FreeTDS if no file by the same 
# name is found in the installation directory.  
#
# For information about the layout of this file and its settings, 
# see the freetds.conf manpage "man freetds.conf".  

# Global settings are overridden by those in a database
# server specific section
[global]
        # TDS protocol version
;	tds version = 4.2

	# Whether to write a TDSDUMP file for diagnostic purposes
	# (setting this to /tmp is insecure on a multi-user system)
;	dump file = /tmp/freetds.log
;	debug flags = 0xffff

	# Command and connection timeouts
;	timeout = 10
;	connect timeout = 10
	
	# If you get out-of-memory errors, it may mean that your client
	# is trying to allocate a huge buffer for a TEXT field.  
	# Try setting 'text size' to a more reasonable limit 
	text size = 64512

# A typical Microsoft server
[xf]
	host = rinnycs0053.rth.ad.rothschild.com
	port = 1433
	tds version = 8.0

[xfdr]
	host = rinnycsr0053.rth.ad.rothschild.com
	port = 1433
	tds version = 8.0

bosr@bosr-linux:/usr/bin$ 
***************************************************************

This message is for the named person's use only. It may
contain confidential, proprietary or legally privileged
information. No right to confidential or privileged treatment
of this message is waived or lost by an error in transmission.
If you have received this message in error, please immediately
notify the the sender by e-mail, delete the message and all 
copies from your system and destroy any hard copies.  You must
not, directly or indirectly, use, disclose, distribute, 
print or copy any part of this message if you are not
the intended recipient.

****************************************************************



______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.