Skip to Content.
Sympa Menu

freetds - Re: [freetds] tsql works, unixODBC's isql doesn't

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Joel Fouse <joel AT fouse.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] tsql works, unixODBC's isql doesn't
  • Date: Wed, 16 Jul 2008 11:21:19 -0400

On Wed, 2008-07-16 at 06:36 -0400, Joel Fouse wrote:

> > You could try a
> >
> > strace -e connect isql db01-2 $USER $PASS
>
>
> I'll try that.
>


Here's what I get:

[root@web ~]# strace -e connect isql -v db01 $USER $PASS
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)
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[ISQL]ERROR: Could not SQLConnect
Process 18350 detached

(It's the same whether I use db01 or db01-2)
And here's what I get w/ the same strace on tsql, which connects
successfully:

[root@web ~]# strace -e connect tsql -S db01 -U $USER -P $PASS
locale is "en_US.UTF-8"
locale charset is "UTF-8"
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)
connect(5, {sa_family=AF_INET, sin_port=htons(1434),
sin_addr=inet_addr("192.168.1.101")}, 16) = -1 EINPROGRESS (Operation
now in progress)
--- SIGCHLD (Child exited) @ 0 (0) ---
1> exit
Process 18333 detached

Not sure if that helps clarify things...

- Joel




Archive powered by MHonArc 2.6.24.

Top of Page