[freetds] Remote connecting from CentOS-Cpanel to Win Server 2003(MSSQL 2005 Express)
zack at awti.info
Wed Jan 28 16:11:56 EST 2009
Turns out i was tripping over myself by having the outbound port on the
centos firewall blocked..OOOOPS! hehehe
----- Original Message -----
From: "Zack Horne" <zack at awti.info>
To: <freetds at lists.ibiblio.org>
Sent: Wednesday, January 28, 2009 1:34 PM
Subject: [freetds] Remote connecting from CentOS-Cpanel to Win Server
2003(MSSQL 2005 Express)
> 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
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
More information about the FreeTDS