freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

RE: [freetds] Sybase ASA 8

From: David Owen <dowen AT midsomer.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: RE: [freetds] Sybase ASA 8
Date: 14 Mar 2003 10:50:51 -0700

I don't have a copy of ASA running at the moment, but did you start the
engine with the flag that sets the name? I cannot remember what it is
now, but there is one that allows you to specify a name and this must
mach the entry in either the interfaces and freetds.conf *exactly*. I
have not tried with 8, but I have the CD somewhere and will give it a
try this afternoon.

dowen

On Fri, 2003-03-14 at 05:31, Björn Lantz wrote:
> Hi,
>
> Unfortunatelly naming the freetds.conf file entry the same as the
> database name did not change the behaviour in any way. In the first sent
> packet in the dump file I can see the password twice. Is this correct,
> or is it the database name that should be there instead in one of the
> occurences?
>
> /Björn Lantz
>
> > -----Original Message-----
> > From: freetds-bounces AT lists.ibiblio.org
> > [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Brian Bruns
> > Sent: den 14 mars 2003 12:06
> > To: FreeTDS Development Group
> > Subject: Re: [freetds] Sybase ASA 8
> >
> >
> > 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 mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
--
David Owen Midsomer Consultants Inc. dowen AT midsomer.org
Maintainer of the Sybase FAQ: http://www.isug.com/Sybase_FAQ

[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