Skip to Content.
Sympa Menu

freetds - [freetds] Remote connecting from CentOS-Cpanel to Win Server 2003 (MSSQL 2005 Express)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Zack Horne" <zack AT awti.info>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Remote connecting from CentOS-Cpanel to Win Server 2003 (MSSQL 2005 Express)
  • Date: Wed, 28 Jan 2009 13:34:44 -0700

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()




Archive powered by MHonArc 2.6.24.

Top of Page