FreeTDS Development Group

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

(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')
>