freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Sybase ASA 8

From: Brian Bruns <camber AT ais.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Sybase ASA 8
Date: Fri, 14 Mar 2003 06:06:28 -0500 (EST)

This came up recently. See if naming your freetds.conf file entry the
same as your database name (not your server name) fixes the problem. This
appears to be a quirk in ASA.

Brian

On Fri, 14 Mar 2003, Björn Lantz wrote:

> 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
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>

[freetds] Sybase ASA 8, Björn Lantz, 03/14/2003
- Re: [freetds] Sybase ASA 8, Brian Bruns, 03/14/2003
  - RE: [freetds] Sybase ASA 8, Björn Lantz, 03/14/2003
    - RE: [freetds] Sybase ASA 8, David Owen, 03/14/2003
- <Possible follow-up(s)>
- RE: [freetds] Sybase ASA 8, Lowden, James K, 03/14/2003
  - RE: [freetds] Sybase ASA 8, Frediano Ziglio, 03/14/2003
  - RE: [freetds] Sybase ASA 8, Björn Lantz, 03/15/2003