FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

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
>