Skip to Content.
Sympa Menu

freetds - RE: [freetds] ASA Error -83: Specified database not found

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Lowden, James K" <LowdenJK AT bernstein.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] ASA Error -83: Specified database not found
  • Date: Thu, 27 Feb 2003 09:30:29 -0500

> From: m.aschwanden AT riskreturn.ch [mailto:m.aschwanden AT riskreturn.ch]
> Sent: February 27, 2003 7:31 AM
> To: freetds AT lists.ibiblio.org
> Subject: [freetds] ASA Error -83: Specified database not found
>
> I have debian/stable installed.
> freetds0 0.53-7
> sqsh 2.1-2
>
> I want to connet to Sybase (Adaptive Server Anywhere 6.0.4.3758).
...
> sqsh -I /etc/freetds/freetds.conf -U SAKARYA -P ws1 -D
> FAMADMIN -S FAMSQL
>
> The following error message is shown:
> Msg 911, Level 16, State 0
> ASA Error -83: Specified database not found
>
> I know that the DB-Name must be correct...

How do you know?

> I look into the dump-file of
> freetds.log I cannot find the database name... what can I do
> to get the connection working:

I think ASA is interpreting the lservname field of the login packet, which
normally carries the servername, as a database name. The TDS 5.0 spec says:

This field SHOULD correspond with the
@@servername of the server for best results.
[...]
For Adaptive Server Anywhere this field indicates
the name of the database which the connection
should be made to (the database must
already be loaded). If the name in this field
doesn't match any currently loaded database the
connection silently ends up in the "default"
database.

Still, it shouldn't fail. You could try rearranging your freetds.conf, such
that the servername is FAMADMIN. If that works, we know what the problem
is.

There is a new .deb due out any day now, for FreeTDS 0.61. I don't know
that it still has this bug (if that's what it is), but if we can isolate the
problem, we can probably get you a patch to fix it.

--jkl


> FAMFILE = the name of the calling machine
>
> 2003-02-27 13:00:49 Connecting addr 192.10.10.99 port 2638
> Sending packet @ 2003-02-27 13:00:49
> 0000 02 00 02 00 00 00 00 00 46 41 4d 46 49 4c 45 00
> |........FAMFILE.|
> 0010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> |................|
> 0020 00 00 00 00 00 00 07 53 41 4b 41 52 59 41 00 00
> |.......SAKARYA..|
> 0030 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> |................|
> 0040 00 00 00 00 00 07 77 73 31 00 00 00 00 00 00 00
> |......ws1.......|
> 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
> |.....37876......|
> 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 73 71 73 68 00 00 00 00 00 00 00 00
> |....sqsh........|
> 00a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> |................|
> 00b0 00 00 04 46 41 4d 53 51 4c 00 00 00 00 00 00 00
> |...FAMSQL.......|
> 00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> |................|
> 00d0 00 06 00 03 77 73 31 00 00 00 00 00 00 00 00 00
> |....ws1.........|
> 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 43 54 2d 4c 69 62 72 61 72 79
> |......CT-Library|
> 01e0 0a 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-02-27 13:00:49
> 0000 02 01 00 5d 00 00 00 00 00 00 00 00 00 00 0a 00
> |...]............|
> 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 12 00 01 07 03 6d 7f
> |..............m.|
> 0050 ff ff ff fe 02 07 00 00 0a 68 00 00 00
> |.........h...|
>
>
> 2003-02-27 13:00:49 inside tds_process_login_tokens()
> Received packet @ 2003-02-27 13:00:49
> 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 06 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
> database not f|
> 0060 6f 75 6e 64 00 00 00 00 fd 02 00 00 00 00 00 00
> |ound............|
> 0070 00 |.|
>
>
> 2003-02-27 13:00:49 inside tds_process_default_tokens() marker is e5
> 2003-02-27 13:00:49 inside tds_process_default_tokens() marker is fd
> 2003-02-27 13:00:49 leaving tds_process_login_tokens() returning 0
> 2003-02-27 13:00:49 leaving ct_connect() returning 0
> 2003-02-27 13:00:49 inside ct_con_props() action = CS_GET
> property = 26
> 2003-02-27 13:00:49 inside ct_con_drop()
> 2003-02-27 13:00:49 inside ct_exit()
>
>
>
> So, what can I do to get connected - I am desperate!
> Thanks for your help in advance,
> Greetings,
> Marco
>
>
> Marco Aschwanden
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above. If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.





Archive powered by MHonArc 2.6.24.

Top of Page