FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

savitri,

this is really difficult to diagnose remotely, although the problem is
undoubtedly straightforward.
FreeTDS and sqsh is a piece of cake normally. 

Apologies if you've done any or all of these already:

1) can I see the "ldd output now you've changed things.

2) can you confirm the userid / password combination independently

3) how are you configuring the server details? through interfaces file ( in
$SYBASE/interfaces ) or through freetds.conf ?

4) which version of the TDS protocol are you using ? is this set through
$TDSVER ? or the freetds.conf file  ? or left as default ?


Bill

> -----Original Message-----
> From: Sarangi, Savitri (ODC - Satyam) [SMTP:SSarangi AT Satyam.odc.ml.com]
> Sent: Wednesday, September 25, 2002 3:44 PM
> To:   TDS Development Group
> Subject:      RE: [freetds] RE: SQSH with FreeTDS for SQL Server access
> Importance:   High
> 
> Hi all
> 
> Any thoughts on the following? In a hurry to see it through
> 
> thanks
> 
> savitri
> 
> > ----------
> > From:       Sarangi, Savitri (ODC -
> > Satyam)[SMTP:SSarangi AT Satyam.odc.ml.com]
> > Reply To:   TDS Development Group
> > Sent:       Wednesday, September 25, 2002 5:40 PM
> > To:         TDS Development Group
> > Subject:    RE: [freetds] RE: SQSH with FreeTDS for SQL Server access
> > Importance:         High
> > 
> > <<File: ATT31478.txt>>
> > Ref below. TDSDUMP is set. no log gets created also
> > 
> > regds
> > 
> > savitri
> > 
> >     ----------
> >     From:   Sarangi, Savitri (ODC -
> > Satyam)[SMTP:SSarangi AT Satyam.odc.ml.com]
> >     Reply To:       TDS Development Group
> >     Sent:   Wednesday, September 25, 2002 5:38 PM
> >     To:     TDS Development Group
> >     Subject:        RE: [freetds] RE: SQSH with FreeTDS for SQL Server
> > access
> >     Importance:     High
> > 
> >     <<File: ATT31455.txt>>
> >     Dear Bill
> > 
> >             My sqsh uses only Sybase libraries. See below
> >             libcs.so =>
> > /net/localhost/apps/Omnibus/platform/solaris2/lib//libc
> >     s.so
> >             libct.so =>
> > /net/localhost/apps/Omnibus/platform/solaris2/lib//libc
> >     t.so
> >             libcomn.so =>
> > /net/localhost/apps/Omnibus/platform/solaris2/lib//libc
> >     omn.so
> >             libtcl.so =>
> > /net/localhost/apps/Omnibus/platform/solaris2/lib//libt
> >     cl.so
> >             libintl.so =>
> > /net/localhost/apps/Omnibus/platform/solaris2/lib//libi
> >     ntl.so
> >             libnsl.so.1 =>   /usr/lib/libnsl.so.1
> >             libdl.so.1 =>    /usr/lib/libdl.so.1
> >             libm.so.1 =>     /usr/lib/libm.so.1
> >             libc.so.1 =>     /usr/lib/libc.so.1
> >             libmp.so.2 =>    /usr/lib/libmp.so.2
> >             /usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1
> > 
> >     To change this, I modified my sqsh Makefile 
> >     SYBASE_OCOS = /home/qaetr/Satyam_dev/freetds
> >     SYBASE_LIBS   = -ltds -lct -ldl -lm
> > 
> >     Now I am getting 'segmentation error core dumped'.
> >     sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray
> >     This is free software with ABSOLUTELY NO WARRANTY
> >     For more information type '\warranty'
> >     Segmentation Fault (core dumped)
> > 
> >     Any thoughts, please
> > 
> >     regards
> > 
> >     savitri
> > 
> >             ----------
> >             From:   Thompson, Bill D
> > (London)[SMTP:ThompBil AT exchange.uk.ml.com]
> >             Reply To:       TDS Development Group
> >             Sent:   Wednesday, September 25, 2002 3:53 PM
> >             To:     TDS Development Group
> >             Subject:        [freetds] RE: SQSH with FreeTDS for SQL
> > Server access
> > 
> >             First up, go into the sqsh directory and do "ldd sqsh" this
> > should tell you
> >             which libraries sqsh is picking up at runtime (sybase or
> > freetds)
> > 
> > 
> >             > -----Original Message-----
> >             > From: Savitri Sarangi [SMTP:ssarangi AT Satyam.odc.ml.com]
> >             > Sent: Wednesday, September 25, 2002 11:16 AM
> >             > To:   TDS Development Group
> >             > Subject:      [freetds] SQSH with FreeTDS for SQL Server
> > access
> >             > 
> >             > Dear all
> >             > 
> >             > I am trying to access SQL Server 2000 from sqsh on
> > Solaris. I downloaded
> >             > sqsh source and created the binary. My $SYBASE, $CC set
> > properly.I use
> >             > only cc and not gcc. My LD_LIBRARY_PATH includes
> > freetds/lib path. I did
> >             > not modify SYBASE_LIBS   = -lct -ldl -lm as said in
> > FreeTDS SQSH
> >             > documentation. This gives me host of undefined symbol
> > error. So I left
> >             > SYBASe_LIBS as it was. However when I run sqsh -SMYSERVER
> > -Usa -Psa
> >             > I get error
> >             > sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray
> >             > This is free software with ABSOLUTELY NO WARRANTY
> >             > For more information type '\warranty'
> >             > Open Client Message
> >             > Layer 5, Origin 3, Severity 5, Number 6
> >             > ct_connect(): network packet layer: internal net library
> > error:
> >             > Net-Library
> >             > operation terminated due to disconnect
> >             > 
> >             > what is the problem? I do not want to use open client.
> > SQSH should use
> >             > FreeTDS.Can any one help me in this?
> >             > 
> >             > thanks and regards
> >             > 
> >             > savitri
> >             > 
> >             > ---
> >             > You are currently subscribed to freetds as:
> > [thompbil AT exchange.uk.ml.com]
> >             > To unsubscribe, forward this message to
> >             > $subst('Email.Unsub')
> > 
> > 
> >             ---
> >             You are currently subscribed to freetds as:
> > [ssarangi AT Satyam.odc.ml.com]
> >             To unsubscribe, forward this message to
> > $subst('Email.Unsub')
> > 
> > 
> >  << File: footer >>