FreeTDS Development Group

["Zack Horne" <zack AT awti.info>]

Hi All,

I'm trien to remote connect to a windows server 2003 (with mssql 2005 xpress) 
from a CentOS-Cpanel server. 
here is my freetds info:
# ./tsql -C
Compile-time settings (established with the "configure" script)
Version: freetds v0.82
freetds.conf directory: /usr/local/freetds/etc
MS db-lib source compatibility: yes
Sybase binary compatibility: no
Thread safety: yes
iconv library: yes
TDS version: 8.0
iODBC: no

When I try to test the connect with ./tsl -S <ip> -U user -P pw... it fails 
and gives me this error.
locale is "en_US.UTF-8"
locale charset is "UTF-8"
44Msg 20009, Level 9, State -1, Server OpenClient, Line -1
Unable to connect: Adaptive Server is unavailable or does not exist
There was a problem connecting to the server

So I took a dump of the connection and here it is aswell.

log.c:190:Starting log file for FreeTDS 0.82

on 2009-01-28 13:26:45 with debug flags 0x4fff.

iconv.c:197:names for ISO-8859-1: ISO-8859-1

iconv.c:197:names for UTF-8: UTF-8

iconv.c:197:names for UCS-2LE: UCS-2LE

iconv.c:197:names for UCS-2BE: UCS-2BE

iconv.c:363:iconv to convert client-side data to the "UTF-8" character set

iconv.c:516:tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"

iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"

net.c:210:Connecting to <private IP> port 1433 (TDS version 8.0)

net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"

net.c:299:getsockopt(2) reported: Connection timed out

util.c:334:tdserror(0x959e0a8, 0x959ea08, 20009, 115)

util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)

util.c:389:tdserror: returning TDS_INT_CANCEL(2)

net.c:310:tds_open_socket() failed

mem.c:563:tds_free_all_results()