Skip to Content.
Sympa Menu

freetds - [freetds] unixODBC connection not working while tsql does

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Bos, Roger" <roger.bos AT rothschild.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] unixODBC connection not working while tsql does
  • Date: Mon, 3 Jan 2011 09:56:18 -0500

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
______________________________________________________________________




Archive powered by MHonArc 2.6.24.

Top of Page