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: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] tsql works, unixODBC's isql doesn't
  • Date: Wed, 16 Jul 2008 17:23:54 +0200

>
> > > 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...
>

Yes, there is some problem in configuration.
You can note that cause tsql try to connect:

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)

while isql not :(

freddy77

Attachment: smime.p7s
Description: S/MIME cryptographic signature




Archive powered by MHonArc 2.6.24.

Top of Page