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: Brian Bruns <camber AT ais.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] ASA Error -83: Specified database not found
  • Date: Thu, 27 Feb 2003 07:44:45 -0500 (EST)

Do you have this problem if you try to run tsql? IIRC, sqsh 2.1 does a
'use master' somewhere and ASA has no master.

Brian

On Thu, 27 Feb 2003 m.aschwanden AT riskreturn.ch wrote:

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