Skip to Content.
Sympa Menu

freetds - [freetds] Dreaded "Server SYBASE not found!" question

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Nelson, Erik - 2" <erik.l.nelson AT bankofamerica.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Dreaded "Server SYBASE not found!" question
  • Date: Fri, 11 Dec 2009 12:11:48 -0500


I'm not sure if this is a unixODBC question or a freetds question, but
starting here. I can connect to the server just fine with tsql, but
have problems with isql. It appears as if neither the
connection->ip_addr nor the are connection->server_name filled in in
tds_connect() in freetds' login.c

There's an outstanding todo in login.c to open the log file prior to
tds_set_server() where "SYBASE" is being set in to
connection->server_name, but it's not at all clear why the server
name/IP aren't being set correctly since the server info is clearly
being found in freetds.conf. My combined osql/TDSDUMP dump is below.

I only recently added the Servername to my odbc.ini, directing the
freetds.conf lookup. The result is the same both with and without the
Servername (osql finds the correct info either way, but it doesn't seem
to get passed in to freetds)

Any assistance would be appreciated.

******begin debug output***********
/modleng/usr/bin/osql -S Hiruko -U CFC\\enelson2 -P xxxxxx looking for
odbc.ini and odbcinst.ini in /modleng/usr/etc
reading "/home/modleng/.odbc.ini"
[Hiruko] not found in "/home/modleng/.odbc.ini"
reading "/modleng/usr/etc/odbc.ini"
[Hiruko] found in "/modleng/usr/etc/odbc.ini"
found this section:
[Hiruko]
Driver = FreeTDS
Description = DataDirect 5.1 SQL Server Wire Protocol
Servername = Hiruko
Server = Hiruko
Port = 1433
AnsiNPW = Yes
Database = Hydra
UID = sasaixbank
QuotedId = Yes
TDS_Version = 8.0

looking for driver for DSN [Hiruko]
driver "FreeTDS" found for [Hiruko] in odbc.ini found driver named
"FreeTDS"
FreeTDS is not a readable file
looking for entry named [FreeTDS] in /modleng/usr/etc/odbcinst.ini
driver "/modleng/usr/lib/libtdsodbc.so" found for [FreeTDS] in
odbcinst.ini /modleng/usr/lib/libtdsodbc.so is a readable file Using
ODBC-Combined strategy FreeTDS servername is "Hiruko" (from
/modleng/usr/etc/odbc.ini) looking for [Hiruko] in
/home/modleng/.freetds.conf cannot read "/home/modleng/.freetds.conf"
looking for [Hiruko] in /modleng/usr/etc/freetds.conf
"/modleng/usr/etc/freetds.conf" is a readable file found this section:
[Hiruko]
host = hiruko.ten-net.net
port = 1433
tds version = 8.0
hiruko.ten-net.net has address 10.148.18.170

DSN: Hiruko
Server's hostname: hiruko.ten-net.net
Address: 10.148.18.170
Driver: /modleng/usr/lib/libtdsodbc.so

Attempting connection as CFC\enelson2...
log.c:190:Starting log file for FreeTDS 0.82
on 2009-12-11 10:37:40 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 "ISO-8859-1" character set
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
login.c:405:IP address pointer is empty
login.c:407:Server SYBASE not found!
mem.c:563:tds_free_all_results()
error.c:574:SQLError((nil), 0x520480, (nil), 0x7fbfffe510, 0x7fbfffdecc,
0x7fbfffe300, 513, 0x7fbfffded2) error.c:510:_SQLGetDiagRec(2, 0x520480,
1, 0x7fbfffe510, 0x7fbfffdecc, 0x7fbfffe300, 513, 0x7fbfffded2)
error.c:574:SQLError((nil), 0x520480, (nil), 0x7fbfffe510, 0x7fbfffdecc,
0x7fbfffe300, 513, 0x7fbfffded2) error.c:510:_SQLGetDiagRec(2, 0x520480,
1, 0x7fbfffe510, 0x7fbfffdecc, 0x7fbfffe300, 513, 0x7fbfffded2)
odbc.c:3734:SQLFreeConnect(0x520480)
odbc.c:3706:_SQLFreeConnect(0x520480)
odbc.c:3757:SQLFreeEnv(0x51f060)
odbc.c:3744:_SQLFreeEnv(0x51f060)
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[ISQL]ERROR: Could not SQLConnect


Erik




Archive powered by MHonArc 2.6.24.

Top of Page