[freetds] Re: connecting to remote MS Sql 2k server from linux PHP
freddyz77 at tin.it
Mon Nov 1 11:35:21 EST 2004
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 18.104.22.168 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 22.214.171.124 1433" ??
Do not use protocol 4.2 for production, it has very limited features.
More information about the FreeTDS