Skip to Content.
Sympa Menu

freetds - RE: help specifying non-standard port

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: wsheldah AT lexmark.com
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: help specifying non-standard port
  • Date: Fri, 22 Mar 2002 13:48:42 -0500




Many thanks for the help. Based on your hint, I rebuilt freetds, this time
using

./configure ---with-tdsver=7.0

Now it appears to work. Again, thanks!

Wes Sheldahl




"Coleman, Dave" <DColeman%US.TIAuto.com AT interlock.lexmark.com> on 03/22/2002
12:52:22 PM

Please respond to "TDS Development Group"
<freetds%franklin.oit.unc.edu AT interlock.lexmark.com>

To: "TDS Development Group"
<freetds%franklin.oit.unc.edu AT interlock.lexmark.com>
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: [freetds] RE: help specifying non-standard port


what little I know suggests that freeTDS was compiled to use TDS v5.0...
4000 is the default port in 5.0. I believe that you can set the port and
TDS version for the server in your freetds.conf file as well, but I don't
know how this setting interacts w/the default port settings established by
the TDS version.

> -----Original Message-----
> From: wsheldah AT lexmark.com [SMTP:wsheldah AT lexmark.com]
> Sent: Friday, March 22, 2002 10:40 AM
> To: TDS Development Group
> Subject: [freetds] help specifying non-standard port
>
>
>
> Hi,
>
> I'm trying to use freetds to connect from an Intel/linux box to MS SQL
> Server
> 2000, which is running on a known non-standard port. Let's say it's 3333.
> Also
> using TDS version 7.0.
>
> I've confirmed that the server is listening to this port by telnetting to
> it.
>
> When I run "make test" with perl's DBD::Sybase, I get lots of "Connection
> refused" errors. Turning on freetds logging tells me it's trying to
> connect to
> port 4000 and being refused.
>
> I'm running Slackware linux, and freetds in installed in
> /usr/local/freetds.
> $SYBASE points to this directory. I first tried specifying the port in
> /usr/local/freetds/etc/freetds.conf, both in a custom server section and
> then in
> the globals section. Running make test with DBD::Sybase still attempted to
> use
> port 4000. I then tried setting up an interfaces file at
> /usr/local/freetds/interfaces, which specified the correct port. It also
> seems
> to be ignored.
>
> A test perl script that tries to connect with DBI, segfaults when it gets
> to the
> connect line.
>
> How can I verify where it's getting it's port information from? I can't
> find
> port 4000 in any of the scripts, and it truly baffles me; I would have
> expected
> a default of 1433. How can I force it to use the correct port?
>
> Many thanks,
>
> Wes Sheldahl
> wsheldah AT lexmark.com
>
>
>
> ---
> You are currently subscribed to freetds as: [dColeman AT us.tiauto.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')

---
You are currently subscribed to freetds as: [wsheldah AT lexmark.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')










Archive powered by MHonArc 2.6.24.

Top of Page