FreeTDS Development Group

[wsheldah AT lexmark.com]

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