FreeTDS Development Group

[Chris Eleveld <ihermit2 AT yahoo.com>]

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