Skip to Content.
Sympa Menu

freetds - [freetds] Sybase ASA 8

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Björn Lantz <bjorn.lantz AT twoguysandadog.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Sybase ASA 8
  • Date: Fri, 14 Mar 2003 12:03:24 +0100

Hi all,

I have successfully been using freetds 0.60 and 0.61 towards MS SQL 2000
via unixODBC 2.2.4, but when trying to make a connection towards a
Sybase ASA 8 I get errors.

The message "Specified database not found" makes me suspect that the
"Database" parameter is never read from odbc.ini. On the other hand the
"USE sil01" command is never issued as it would be towards MS SQL. I
have tried both with and without freetds.conf with the same result.

isql, tsql and a self-made testprogram segfaults when I run them.

Any help would be appreciated.

/Björn Lantz

odbc.ini :

[sil]
Driver = /usr/lib/libtdsodbc.so
Description = Test
Servername = asatest
#Server = 192.168.1.1
#Port = 2638
#TDS_Version = 5.0
Database = sil01
Trace = Yes
FetchBufferSize = 99

freetds.conf :
[global]
tds version = 7.0
initial block size = 512
swap broken dates = no
swap broken money = no
try server login = yes
try domain login = no
; nt domain = WORKGROUP
cross domain login = no
dump file = /tmp/freetds.log
debug level = 99
; timeout = 10;
; connect timeout = 10;

[asatest]
host = 192.168.1.1
port = 2638
tds version = 5.0
text size = 2048

freetds.log :

Starting log file with debug level 99.
2003-03-14 12:33:04.648643 iconv will convert client-side data to the ""
character set
2003-03-14 12:33:04.660477 iconv_open: cannot convert to ""
2003-03-14 12:33:04.662751 Connecting addr 192.168.1.1 port 2638 with
TDS version 5.0
Sending packet @ 2003-03-14 12:33:04.733422
0000 02 00 02 00 00 00 00 00 61 62 63 2e 64 65 66 2e |........
abc.def.|
0010 63 6f 6d 00 00 00 00 00 00 00 00 00 00 00 00 00 |com.....
........|
0020 00 00 00 00 00 00 19 61 62 63 00 00 00 00 00 00 |.......a
bc......|
0030 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........
........|
0040 00 00 00 00 00 03 73 71 6c 00 00 00 00 00 00 00 |......sq
l.......|
0050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........
........|
0060 00 00 00 00 03 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 00 00 |........
........|
0090 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........
........|
00a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........
........|
00b0 00 00 00 53 59 42 41 53 45 00 00 00 00 00 00 00 |...SYBAS
E.......|
00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........
........|
00d0 00 06 00 03 73 71 6c 00 00 00 00 00 00 00 00 00 |....sql.
........|
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 05 05 00 00 00 00 00 00 00 00 00 00 00 00 00 |........
........|
01e0 00 05 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......
........|


Sending packet @ 2003-03-14 12:33:04.760120
0000 02 01 00 61 00 00 00 00 00 00 00 00 00 00 0a 00 |...a....
........|
0010 00 00 00 00 00 00 00 00 00 00 00 00 00 69 73 6f |........
.....iso|
0020 5f 31 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |_1......
........|
0030 00 00 00 00 00 00 00 00 00 00 00 05 01 35 31 32 |........
.....512|
0040 00 00 00 03 00 00 00 00 e2 16 00 01 09 00 00 06 |........
........|
0050 6d 7f ff ff ff fe 02 09 00 00 00 00 0a 68 00 00 |m.......
.....h..|
0060 00 |.|


2003-03-14 12:33:04.771069 inside tds_process_login_tokens()
Received header @ 2003-03-14 12:33:04.985437
0000 04 01 00 79 00 00 00 00 |...y....|


Received packet @ 2003-03-14 12:33:04.991445
0000 ad 22 00 06 05 00 00 00 18 41 64 61 70 74 69 76 |."......
.Adaptiv|
0010 65 20 53 65 72 76 65 72 20 41 6e 79 77 68 65 72 |e Server
Anywher|
0020 65 08 00 00 00 e5 40 00 8f 03 00 00 00 10 05 30 |e.....@.
.......0|
0030 38 57 31 30 00 00 00 2b 00 41 53 41 20 45 72 72 |8W10...+ .ASA
Err|
0040 6f 72 20 2d 38 33 3a 20 53 70 65 63 69 66 69 65 |or -83:
Specifie|
0050 64 20 64 61 74 61 62 61 73 65 20 6e 6f 74 20 66 |d databa se
not f|
0060 6f 75 6e 64 00 00 00 00 fd 02 00 00 00 00 00 00 |ound....
........|
0070 00 |.|


2003-03-14 12:33:04.998939 inside tds_process_default_tokens() marker is
e5(EED)
2003-03-14 12:33:05.001601 inside tds_process_default_tokens() marker is
fd(DONE)
2003-03-14 12:33:05.005162 inside tds_process_end() more_results = 0,
was_cancelled = 0
2003-03-14 12:33:05.007417 inside tds_process_default_tokens() setting
state to COMPLETED
Sending packet @ 2003-03-14 12:33:05.012210
0000 0f 01 00 1b 00 00 00 00 21 0e 00 00 00 00 73 65 |........
!.....se|
0010 6c 65 63 74 20 40 40 73 70 69 64 |lect @@s pid|


Received header @ 2003-03-14 12:33:05.039995
0000 04 01 00 4d 00 00 00 00 |...M....|


Received packet @ 2003-03-14 12:33:05.046082
0000 e5 39 00 80 10 00 00 00 10 05 30 38 57 30 32 00 |.9......
..08W02.|
0010 00 00 24 00 41 53 41 20 45 72 72 6f 72 20 2d 31 |..$.ASA Error
-1|
0020 30 38 3a 20 43 6f 6e 6e 65 63 74 69 6f 6e 20 6e |08: Conn
ection n|
0030 6f 74 20 66 6f 75 6e 64 00 00 00 00 fd 02 00 00 |ot found
........|
0040 00 00 00 00 00 |.....|


2003-03-14 12:33:05.050435 processing result tokens. marker is e5(EED)
2003-03-14 12:33:05.052571 inside tds_process_default_tokens() marker is
e5(EED)
2003-03-14 12:33:05.056748 processing result tokens. marker is
fd(DONE)
2003-03-14 12:33:05.058898 inside tds_process_end() more_results = 0,
was_cancelled = 0




Archive powered by MHonArc 2.6.24.

Top of Page