Skip to Content.
Sympa Menu

freetds - Re: Cannot access MSSQL db

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: James Cameron <cameron AT fax.sno.cpqcorp.net>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: Cannot access MSSQL db
  • Date: Mon, 08 Apr 2002 19:05:52 +1000


David Nordenberg wrote:
> bash-2.05$ ./sqsh -H 192.168.1.97

Note that the text following -H must be a host name in the
/etc/freetds/freetds.conf configuration file. Is it?

> src/tds/login.c: tds_connect: 212.181.91.6:4000: Connection refused
> hmm, BBIIGG HMMM. 212.181.91.6 is webrouter0.telia.nic.nu and I have no
> idea where that came from???

Nor I. Check your configuration file. You should also find that
tcpdump is showing a connection attempt to port 4000 on that host.

Port 1433 is the usual port.

Have a look at TDSDUMP output.
Validate the origin of the configuration files using;

$ strace -o sqsh.log sqsh -H hostname
$ grep open sqsh.log

--
James Cameron (james.cameron AT compaq.com)

http://quozl.linux.org.au/ (or) http://quozl.netrek.org/




Archive powered by MHonArc 2.6.24.

Top of Page