Skip to Content.
Sympa Menu

freetds - RE: [freetds] Connect to MSSQL 2000 fails

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Connect to MSSQL 2000 fails
  • Date: Tue, 3 Dec 2002 15:18:09 +0100

>
> Hi there,
>

Hi

> I´m a total FreeTDS newbie so I hope you won´t mind me asking stupid
> questions :-)
>
> I have a fresh install of FreeTDS on a SuSE 7.1 box and I want to use
> it via PHP. The PHP part is not the problem however, as I can´t
> connect to a MSSQL 2000 server running on W2K using tsql.
>
> This is what I type:
> > /usr/local/ftds/bin/tsql -S deepspace1 -p 1433 -U dima
>

Port is useless, already specified in freetds.conf

....
>
> In the freetds.conf´s [global] section I have defined the TDS protocol
> version to use as 7.0. Additionally, I have defined a server named
> "deepspace1" like this:
> > [deepspace1]
> > host = 192.168.168.200
> > port = 1433
> > tds version = 7.0
>
> Because I wasn´t sure if FreeTDS would use freetds.conf or interfaces,
> I´ve created an additional interface file that looks like this:
> > deepspace1
> > query tcp tds7.0 192.168.168.200 1433
>

Not needed (also is obsolete retained only for compatibility)

> The interesting question is: Why doesn´t it work this way? I already
> went through any piece of documentation, FAQ and tutorials that I
> could find. The only thing that´s a little special about my setup is
> that the MSSQL server is behind our firewall - but there´s a forwarder
> (which works, I can get through via telnet) that allows our webserver
> to connect to our firewall on port 1433, which routes the connection
> to our internal MSSQL server.
>

Now I understand why it's called "deep space" :)

Perhaps firewall is opened only for webserver. Try to do a "telnet
192.168.168.200 1433" directly from your Suse box.
Also, are you using 0.60 version, current (CVS), snapshot?
I suggest to use ct library (--with-sybase-ct), althought this can't solve
your problem...

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================




Archive powered by MHonArc 2.6.24.

Top of Page