Skip to Content.
Sympa Menu

freetds - RE: [freetds] problems configuring..

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Russell Kroboth <rkroboth AT visitraleigh.com>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] problems configuring..
  • Date: Tue, 25 Feb 2003 13:11:13 -0500

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
>




Archive powered by MHonArc 2.6.24.

Top of Page