FreeTDS Development Group

[Russell Kroboth <rkroboth AT visitraleigh.com>]

Ok here's what I have:

I set the environment vars for TDSDUMP AND TDSDUMPCONFIG:
-bash-2.05b# echo $TDSDUMP $TDSDUMPCONFIG
/var/log/freetds/tdsdump.log /var/log/freetds/tdsdumpconfig.log

Then I ran my test:
isql -v P450 testuser password1
[unixODBC]Client unable to establish connection
[ISQL]ERROR: Could not SQLConnect


A tdsdumpconfig.log was not produced, but the tdsdump.log was created and
had this in it:
Starting log file with debug level 99.
2003-02-25 12:55:13.692218 iconv will convert client-side data to the ""
character set
2003-02-25 12:55:13.692920 IP address pointer is NULL
2003-02-25 12:55:13.693006 Server SYBASE not found!


It sounds like my servers IP address is not being used? From my
/root/.odbc.ini I have:

[P450]
Driver          = TDS
Description             = Partners
Trace           = No
Servername              = 192.168.1.54
Database                = Partners
Port            = 1433
TDS_Version             = 7.0

and in /etc/odbcinst.ini I have:
[P450]

Description             = Partners
Trace           = No
Servername              = 192.168.1.54
Database                = Partners
Port            = 1433
TDS_Version             = 7.0


I also verified that the server was there:
-bash-2.05b# ping 192.168.1.54
PING 192.168.1.54 (192.168.1.54) from 192.168.1.32 : 56(84) bytes of data.
64 bytes from 192.168.1.54: icmp_seq=1 ttl=128 time=0.633 ms

-bash-2.05b# telnet 192.168.1.54 1433
Trying 192.168.1.54...
Connected to 192.168.1.54.
Escape character is '^]'.


I also tried:
/usr/local/bin/tsql -H 192.168.1.54 -p 1433 -U testuser
and it asked for my password, which I supplied.  Then I got a ">" prompt.

What am i missing? thanks again..!

> -----Original Message-----
> From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
> Sent: Tuesday, February 25, 2003 12:43 PM
> To: 'FreeTDS Development Group'
> Subject: RE: [freetds] problems configuring..
> 
> 
> > From: Russell Kroboth [mailto:rkroboth AT visitraleigh.com]
> > Sent: February 25, 2003 12:34 PM
> > 
> > -bash-2.05b# isql -v P450 testuser password1
> > [unixODBC]Client unable to establish connection
> > [ISQL]ERROR: Could not SQLConnect
> > 
> > How can I find out the reason for the connection fail?  I 
> > couldn't get the logging to work earlier..
> 
> http://www.freetds.org/userguide/x2226.htm
> 
> If there's something on that page that isn't clear, tell me 
> what you don't
> understand, and I'll walk you through it.  
> 
> The log files should show us what's happening.  I don't 
> understand all the
> ins and outs of ODBC, but I can at least help you figure out 
> what FreeTDS is
> trying to do.  
> 
> --jkl
> 
> 
> The information contained in this transmission may contain 
> privileged and
> confidential information and is intended only for the use of 
> the person(s)
> named above.  If you are not the intended recipient, or an 
> employee or agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this 
> communication is
> strictly prohibited. If you are not the intended recipient, 
> please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that we do not accept account 
> orders and/or
> instructions by e-mail, and therefore will not be responsible 
> for carrying
> out such orders and/or instructions.
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>