FreeTDS Development Group

["Yulei Liu" <netcool AT gmail.com>]

Hi,

I am trying to connect my freetds 0.65 to a IBM/TIVOLI Netcool
Omnibus, which is a memory based database, build on sybase protocals.

My OS is centos 4.4, which is the same as Redhat ES4 update 4.

After compiling freetds and using tsql to connect to it, i get following 
errors:

$ netcool Webtop> ./tsql -H objserver -p 4100 -U root
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password:
Msg 20002, Level 9, State -1, Server OpenClient, Line -1
Adaptive Server connection failed
There was a problem connecting to the server


In my tds log file i get:

log.c:190:Starting log file for FreeTDS 0.65.dev.20070731
        on 2007-12-19 14:21:29 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"
net.c:185:Connecting to 10.1.1.109 port 4100 (TDS version 4.2)
net.c:241:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:284:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
net.c:748:Sending packet
0000 02 00 02 00 00 00 00 00-61 75 30 32 71 6e 6d 30 |........ au02qnm0|
0010 32 30 71 61 6e 72 32 00-00 00 00 00 00 00 00 00 |20qanr2. ........|
0020 00 00 00 00 00 00 0f 72-6f 6f 74 00 00 00 00 00 |.......r oot.....|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 04 6e 65-74 63 6f 6f 6c 00 00 00 |......ne tcool...|
0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 07 33 37 38-37 36 00 00 00 00 00 00 |.....378 76......|
0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0080 00 00 00 05 03 01 06 0a-09 01 00 00 00 00 02 00 |........ ........|
0090 00 00 00 00 54 53 51 4c-00 00 00 00 00 00 00 00 |....TSQL ........|
00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00b0 00 00 04 6f 62 6a 73 65-72 76 65 72 00 00 00 00 |...objse rver....|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 09 6e 65 74 63 6f 6f-6c 00 00 00 00 00 00 00 |..netcoo l.......|
00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01d0 00 07 04 02 00 00 54 44-53 2d 4c 69 62 72 61 72 |......TD S-Librar|
01e0 0a 00 00 00 00 00 0d 11-75 73 5f 65 6e 67 6c 69 |........ us_engli|
01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |sh...... ........|

net.c:748:Sending packet
0000 02 01 00 4c 00 00 00 00-00 00 00 00 00 00 0a 00 |...L.... ........|
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 75 74 66 |........ .....utf|
0020 38 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |8....... ........|
0030 00 00 00 00 00 00 00 00-00 00 00 04 01 35 31 32 |........ .....512|
0040 00 00 00 03 00 00 00 00-00 00 00 00             |........ ....|

token.c:312:tds_process_login_tokens()
net.c:556:Received header
0000 04 01 00 28 00 00 01 00-                        |...(....|

-- 
net.c:635:Received packet
0000 ad 14 00 00 04 02 00 00-0a 4f 70 65 6e 53 65 72 |........ .OpenSer|
0010 76 65 72 0c 05 01 00 fd-00 00 00 00 00 00 00 00 |ver..... ........|

token.c:316:looking for login token, got  ad(LOGINACK)
token.c:316:looking for login token, got  fd(DONE)
token.c:108:tds_process_default_tokens() marker is fd(DONE)
token.c:2220:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2236:tds_process_end() state set to TDS_IDLE
token.c:389:leaving tds_process_login_tokens() returning 0
util.c:162:Changed query state from IDLE to DEAD
util.c:334:tdserror(0x94760a8, 0x9476a38, 20002, 0)
util.c:370:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:391:tdserror: returning TDS_INT_CANCEL(2)
mem.c:568:tds_free_all_results()


Yulei Liu
Netcool Consultant
Eirteic Consulting Australia