Connecting to Sybase on NT
mpeppler at peppler.org
Wed Oct 6 10:42:52 EDT 1999
Jeff Driscoll writes:
> Sorry. Yes I can ping the box so I don't think I have a routing problem.
> $SYBASE is set to /usr/local/freetds.
> What is the default TCP port that Sybase listens on? Is it the same as
No. There is no default port. You need to check the interfaces file
(or sql.ini) on the server to see what port it is listening to (or you
could use dsedit on the server)
> Should TDS version 4.2 work with Sybase 10?
> > > connect: Connection refused
> > ^ Here is the key...This means
> > a) you can't talk to the box. Try ping to make sure all the routes are ok
> > b) your interfaces file is screwed up or its not finding it. Make sure
> > $SYBASE is set properly and the interfaces look ok.
> > c) The port is wrong. Try to 'telnet hostname port#' adn see if
> > you still get the 'connection refused' message, if so Sybase is not
> > listening on that port.
> > d) Sybase is configured to listen on localhost and not the ethernet card,
> > try the step from c to verify this too.
> > There are probably some other possibilies as well, but these are the
> > likely ones.
> > >
> > > $ cat /tmp/freetds.log
> > > 2000-04-19 01:33:41 leaving ct_connect() returning 0
> > > 2000-04-19 01:33:41 inside ct_con_props() action = CS_GET property = 26
> > > 2000-04-19 01:33:41 inside ct_con_drop()
> > >
> > > Any ideas?
> > >
> > Cheers,
> > Brian
> You are currently subscribed to freetds as: mpeppler at peppler.org
> To unsubscribe, forward this message to $subst('Email.Unsub')
Michael Peppler -||- Data Migrations Inc.
mpeppler at peppler.org -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: ase-linux-list at isug.com
More information about the FreeTDS