Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: m.aschwanden AT riskreturn.ch
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] ASA Error -83: Specified database not found
  • Date: Thu, 27 Feb 2003 13:31:07 +0100

Hi

I have debian/stable installed.
Furthermore:

freetds0 0.53-7
sqsh 2.1-2

I want to connet to Sybase (Adaptive Server Anywhere 6.0.4.3758).

I configured freetds.conf as follows:

[global]
tds version = 4.2
initial block size = 512
swap brokem date = no
swap brkonen money = no
try server login = yes
try domain login = no
dump file = /tmp/freetds.log
debug level = 10

[FAMSQL]
host = FAMSQL
port = 2638
tds version = 5.0

These are all settings. The host FAMSQL is defined in the /etc/hosts file
of course.

Now, if I try to connect to the ASA-Server through sqsh - the database is
called FAMADMIN:

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




Archive powered by MHonArc 2.6.24.

Top of Page