FreeTDS Development Group

[Björn Lantz <bjorn.lantz AT twoguysandadog.com>]

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