Skip to Content.
Sympa Menu

freetds - RE: SQSH with FreeTDS for SQL Server access

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: SQSH with FreeTDS for SQL Server access
  • Date: Wed, 25 Sep 2002 15:47:04 +0100


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





Archive powered by MHonArc 2.6.24.

Top of Page