FreeTDS Development Group

["FxM" <mastronardif AT netcarrier.com>]

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:
> > > > [camber AT ais.org]
> > > > > > To unsubscribe, forward this message to
> > > > $subst('Email.Unsub')
> > > > > >
> > > > >
> > > > >
> > > > > ---
> > > > > You are currently subscribed to freetds as:
> > > > [mastronardif AT netcarrier.com]
> > > > > To unsubscribe, forward this message to
> > > > $subst('Email.Unsub')
> > > > >
> > > >
> > > >
> > > > ---
> > > > 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:
> > [mastronardif AT netcarrier.com]
> > > To unsubscribe, forward this message to
> > $subst('Email.Unsub')
> > >
> >
> >
> > ---
> > 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: [mastronardif AT netcarrier.com]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>