Skip to Content.
Sympa Menu

freetds - Re: sqsh, freebsd, mssql

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Chris Eleveld <ihermit2 AT yahoo.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: sqsh, freebsd, mssql
  • Date: Sat, 26 Jan 2002 06:05:18 -0800 (PST)



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




Archive powered by MHonArc 2.6.24.

Top of Page