Skip to Content.
Sympa Menu

freetds - [freetds] sql2005 & freetds connection probs

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: S Willms <slwillms AT hotmail.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] sql2005 & freetds connection probs
  • Date: Tue, 13 May 2008 10:55:50 -0500


Freetds newbie here.

My goal is to access a MS sql2005 DB from linux through perl using
dbd::sybase module. I've installed freetds v 0.64...is it compatible w/2005?
I wasn't able to find much documentation that refers to sql2005
specifically, but i was able to find one source that says it should work. Is
this right? Or is there anything else I should be using instead?

Here's what I've done so far: I'm able to connect successfully to a MS sql2k
DB on another server using "/usr/local/freetds/bin/tsql -H trust -p 1433 -U
test". But using "/usr/local/freetds/bin/tsql -H sql2005 -p 1433 -U test", I
get:

locale is "C"
locale charset is "ANSI_X3.4-1968"
Password:
Msg 20009, Level 9, State 0, Server OpenClient, Line 0
Server is unavailable or does not exist.
There was a problem connecting to the server

The log file says:

10:23:19.722219 26609 (util.c:288):Starting log file for FreeTDS 0.64
on 2008-05-13 10:23:19 with debug flags 0xffff.
10:23:19.728044 26609 (iconv.c:195):names for ISO-8859-1: ISO-8859-1
10:23:19.728110 26609 (iconv.c:195):names for UTF-8: UTF-8
10:23:19.728138 26609 (iconv.c:195):names for UCS-2LE: UCS-2LE
10:23:19.728164 26609 (iconv.c:195):names for UCS-2BE: UCS-2BE
10:23:19.728191 26609 (iconv.c:361):iconv to convert client-side data to the
"ANSI_X3.4-1968" character set
10:23:19.730553 26609 (iconv.c:514):tds_iconv_info_init: converting
"US-ASCII"->"UCS-2LE"
10:23:19.731171 26609 (iconv.c:514):tds_iconv_info_init: converting
"ISO-8859-1"->"UCS-2LE"
10:23:19.731219 26609 (net.c:168):Connecting to 192.168.2.57 port 1433.
10:23:19.731749 26609 (net.c:256):connect error: Connection refused
10:23:19.731795 26609 (util.c:119):Changing query state from IDLE to DEAD
10:23:19.731889 26609 (token.c:2252):tds_client_msg: #20009: "Server is
unavailable or does not exist.". Connection state is now 4.
10:23:19.731927 26609 (mem.c:519):tds_free_all_results()

freetds.conf:

[trust]
host = trust
port = 1433
tds version = 8.0

[sql2005]
host = sql2005
port = 1433
tds version = 8.0

I can successfully ping the sql2005 server using both the DNS name and IP,
but neither works to connect to the DB. However, I was able to successfully
connect to sql2005 by creating an ODBC connection on my windows workstation
using the same credentials, so I'm assuming (??? correct me if i'm wrong) the
server and the DB are correctly setup for remote connections and port 1433 is
open. Windows firewall is turned off on the sql2005 server.

What am I missing here?
_________________________________________________________________
Windows Live SkyDrive lets you share files with faraway friends.
http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_052008



Archive powered by MHonArc 2.6.24.

Top of Page