FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> 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.