Skip to Content.
Sympa Menu

freetds - RE: [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 Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Sybase ASA 8
  • Date: Fri, 14 Mar 2003 13:31:49 +0100

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
>




Archive powered by MHonArc 2.6.24.

Top of Page