Skip to Content.
Sympa Menu

freetds - RE: [freetds] Re: connecting to remote MS Sql 2k server from linux PHP

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Rick D. Conner" <rick AT wedosites.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Re: connecting to remote MS Sql 2k server from linux PHP
  • Date: Mon, 1 Nov 2004 12:48:59 -0500

Ok, I'm kind of at the end of my patience here... Is there anyone out there
that would set this up for either free or for a fee?

Rick D. Conner
Rick AT WeDoSites.com
http://www.wedosites.com


-----Original Message-----
From: Frediano Ziglio [mailto:freddyz77 AT tin.it]
Sent: Monday, November 01, 2004 11:35 AM
To: FreeTDS Development Group
Subject: RE: [freetds] Re: connecting to remote MS Sql 2k server from linux
PHP

Il lun, 2004-11-01 alle 16:50, Rick D. Conner ha scritto:
> Ok, I did add an entry to the .freetds.conf file named [SYBASE] and set it
> up and it now finds it and finds the right ip etc... But it still doesn't
> connect. I get the following in tds.log.txt:
>
> Starting log file for FreeTDS 0.62.3
> on 2004-11-01 10:45:02 with debug level 99.
> iconv to convert client-side data to the "ISO-8859-1" character set
> 10:45:02.516082 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> 10:45:02.516113 Connecting to 66.208.184.170 port 1433, TDS 4.2.
> 10:45:07.511429 tds_client_msg: #20009: "Server is unavailable or does not
> exist.". Connection state is now 0.
>
> So I guess what I need to know now, is what are the "network" items that
> need checked and any settings to ensure is setup at both ends. I've got
the
> port opened on the router, and the webhost said they did the same. The
> documentation doesn't include much about this at all, and I don't have
> command line access...
>

FreeTDS do not hidden any wire data from log for protocol 4.2. Searching
for your message say that FreeTDS can't just connect(2) to server. Have
you tried with a "telnet 66.208.184.170 1433" ??
Do not use protocol 4.2 for production, it has very limited features.

freddy77


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page