Skip to Content.
Sympa Menu

freetds - Re: sqsh, freebsd, mssql

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "FxM" <mastronardif AT netcarrier.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: sqsh, freebsd, mssql
  • Date: Sat, 26 Jan 2002 23:53:12 -0500


Yeah its working...
It appears I had two slightly different versions of following lib's in two
places.
$SYBASE and bellow
libct.so.0 => /usr/local/lib/libct.so.0
libtds.so.0 => /usr/local/lib/libtds.so.0
2 many latenite compiles...

NOTE: Freebsd users.
When I compiled sqsh it appears at least w/ me that ./configure didn't
get the sybase libs correct
#SYBASE_LIBS = -lct -ltds -lm -ldl
SYBASE_LIBS = -lct -ltds -lm
Well make a long story short, sqsh, and DBI::Sybase work now.
Thanks all,
FxM :>)

----- Original Message -----
From: Chris Eleveld <ihermit2 AT yahoo.com>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Sent: Saturday, January 26, 2002 9:05 AM
Subject: [freetds] Re: sqsh, freebsd, mssql


>
> I've never used sqsh myself but I believe you should
> only need to link against -lct not -lct and -ltds.
> you might want to try running the ldd command on the
> sqsh binary and see if it is really using the proper
> libraries from teh right location.
>
>
> --- FxM <mastronardif AT netcarrier.com> wrote:
> > Yes the ctlib, dblib samples work.
> > When i compiled sqsh 2.1 i had to modify the make
> > file as bellow.
> > I don't think configure handled the sybase libs
> > right.
> >
> > #SYBASE_LIBS = -lct -ltds -lm -ldl
> > SYBASE_LIBS = -lct -ltds -lm
> >
> > FxM. (:{)
> >
> > ----- Original Message -----
> > From: Chris Eleveld <ihermit2 AT yahoo.com>
> > To: TDS Development Group
> > <freetds AT franklin.oit.unc.edu>
> > Sent: Friday, January 25, 2002 10:03 PM
> > Subject: [freetds] Re: sqsh, freebsd, mssql
> >
> >
> > >
> > > so the samples work but sqsh still fails?
> > >
> > > --- FxM <mastronardif AT netcarrier.com> wrote:
> > > > (from) machine 01, FreeBSD 4.1-RELEASE
> > > > (to) machine 02, ntserver, mssql7.0, (ip
> > > > 223.147.37.4(ntserver))
> > > > telnet 223.147.37.4 1433
> > > > telnet ntserver 1433
> > > >
> > > > Trying 223.147.37.4...
> > > > Connected to ntserver.
> > > > Escape character is '^]'.
> > > > it works.
> > > >
> > > > the ctlib, dblib freetds samples work.
> > > > I moved freetds.conf to ~/.freetds.conf
> > > > I changed interfaces file ntserver to
> > MyServer70.
> > > > so both entry's(Servernames) for interfaces and
> > > > freetds.conf are the same
> > > > name.
> > > > FxM
> > > > :,(
> > > >
> > > > ----- Original Message -----
> > > > From: Chris Eleveld <ihermit2 AT yahoo.com>
> > > > To: TDS Development Group
> > > > <freetds AT franklin.oit.unc.edu>
> > > > Sent: Friday, January 25, 2002 3:42 PM
> > > > Subject: [freetds] Re: sqsh, freebsd, mssql
> > > >
> > > >
> > > > >
> > > > > Maybe it is time to reset a little. What
> > type
> > > > of
> > > > > server are you trying to connect to? What
> > type of
> > > > > machine are you connecting from?
> > > > >
> > > > > what happens when you ping 223.147.37.4?
> > > > > what happens when you ping ntserver?
> > > > >
> > > > > what happens if you telnet 223.147.37.4 1433?
> > > > > The same for ntserver?
> > > > >
> > > > > --- FxM <mastronardif AT netcarrier.com> wrote:
> > > > > > I did export TDSVER=7.0
> > > > > > sqsh -SMyServer70 -Usa -P
> > > > > > I get
> > > > > > connect: Can't assign requested address
> > > > > >
> > > > > > my freetds.log
> > > > > > 2002-01-25 14:53:02.553757 leaving
> > ct_connect()
> > > > > > returning 0
> > > > > > 2002-01-25 14:53:02.554419 inside
> > ct_con_props()
> > > > > > action = CS_GET property =
> > > > > > 26
> > > > > > 2002-01-25 14:53:02.554503 inside
> > ct_con_drop()
> > > > > > 2002-01-25 14:53:02.554581 inside ct_exit()
> > > > > > Help me, help me.....
> > > > > >
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > From: Brian Bruns <camber AT ais.org>
> > > > > > To: TDS Development Group
> > > > > > <freetds AT franklin.oit.unc.edu>
> > > > > > Sent: Friday, January 25, 2002 12:48 PM
> > > > > > Subject: [freetds] Re: sqsh, freebsd, mssql
> > > > > >
> > > > > >
> > > > > > > good ideas, also set the TDSDUMP e.g.
> > > > > > >
> > > > > > > export TDSDUMP=/tmp/freetds.log
> > > > > > >
> > > > > > > to get a log of what is going on.
> > > > > > >
> > > > > > > Brian
> > > > > > >
> > > > > > > On Fri, 25 Jan 2002, Chris Eleveld wrote:
> > > > > > >
> > > > > > > >
> > > > > > > > what about sqsh -SMyServer70 -Usa -P
> > > > > > > >
> > > > > > > > also what are the results if you set
> > export
> > > > > > TDSVER=7.0
> > > > > > > >
> > > > > > > >
> > > > > > > > --- FxM <mastronardif AT netcarrier.com>
> > wrote:
> > > > > > > > > Can someone help me w/ a sqsh problem,
> > Im
> > > > > > confused
> > > > > > > > > about the interface and
> > > > > > > > > freetds.conf
> > > > > > > > > files. and maybe im doing something
> > wrong.
> > > > > > > > >
> > > > > > > > > $SYBASE = usr/local/freetds
> > > > > > > > >
> > > > > > > > > I compiled and ran the freetds dblib
> > and
> > > > ctlib
> > > > > > > > > samples and they work yeah.
> > > > > > > > > I would like to runs sqsh and then
> > perl
> > > > DBD.
> > > > > > > > >
> > > > > > > > > I have compiled the sqsh2.1 version
> > for
> > > > > > FreeBSD.
> > > > > > > > >
> > > > > > > > > My interface and freetds.conf file
> > > > contain:
> > > > > > > > >
> > > > > > > > > $SYBASE/interface contains:
> > > > > > > > > myserver
> > > > > > > > > query tcp 7.0 223.147.37.4 1433
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > $SYBASE/freetds.conf contains
> > > > > > > > > # A typical Microsoft SQL Server 7.0
> > > > > > configuration
> > > > > > > > > [MyServer70]
> > > > > > > > > ; host = ntmachine.domain.com
> > > > > > > > > host = ntserver
> > > > > > > > > port = 1433
> > > > > > > > > tds version = 7.0
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > i run (sqsh-2.1 Copyright (C)
> > 1995-2001
> > > > Scott
> > > > > > C.
> > > > > > > > > Gray) w/ the following
> > > > > > > > > senerios.
> > > > > > > > >
> > > > > > > > > %sqsh -SJDBC
> > > > > > > > > connect: Can't assign requested
> > address
> > > > > > > > >
> > > > > > > > > %sqsh -S223.147.37.4 -Usa -P
> > > > > > > > > connect: Connection refused
> > > > > > > > >
> > > > > > > > > %sqsh -Smyserver -Usa -P
> > > > > > > > > connect: Can't assign requested
> > address
> > > > > > > > >
> > > > > > > > > Thanks,
> > > > > > > > > FxM.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > ---
> > > > > > > > > You are currently subscribed to
> > freetds
> > > > as:
> > > > > > > > > [ihermit2 AT yahoo.com]
> > > > > > > > > To unsubscribe, forward this message
> > to
> > > > > > > >
> > $subst('Email.Unsub')
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > >
> > __________________________________________________
> > > > > > > > Do You Yahoo!?
> > > > > > > > Great stuff seeking new owners in Yahoo!
> > > > > > Auctions!
> > > > > > > > http://auctions.yahoo.com
> > > > > > > >
> > > > > > > > ---
> > > > > > > > You are currently subscribed to freetds
> > as:
> >
> === message truncated ===
>
>
> __________________________________________________
> Do You Yahoo!?
> Great stuff seeking new owners in Yahoo! Auctions!
> http://auctions.yahoo.com
>
> ---
> You are currently subscribed to freetds as: [mastronardif AT netcarrier.com]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>





Archive powered by MHonArc 2.6.24.

Top of Page