Re: Remote connecting from CentOS-Cpanel to Win Server 2003(MSSQL 2005 Express)

Me again....

Turns out i was tripping over myself by having the outbound port on the 
centos firewall blocked..OOOOPS! hehehe

Best,
Zack

----- Original Message ----- 
From: "Zack Horne" <[email protected]>
To: <[email protected]>
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
>
> mem.c:563:tds_free_all_results()
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>