FreeTDS Development Group

["Paul Schaap" <paul.schaap AT dingoblue.com.au>]

Hi Brian,

No result comes back. Log below.

[poorly@dingoblue:~] schaappa% /usr/local/bin/sqsh -U tim -S donna -D 
MAV_CIS_CustomerInvoicingSystem -C "SELECT COUNT ( * ) FROM 
CIS_CUSTMR_Customer"
sqsh-1.7 Copyright (C) 1995-1999 Scott C. Gray
This is free software with ABSOLUTELY NO WARRANTY
For more information type '\warranty'
Password: 
[poorly@dingoblue:~] schaappa% cat /tmp/freetds.log                           
  2001-07-12 09:43:16 Connecting addr 172.20.1.237 port 1433
Sending packet @ 2001-07-12 09:43:16
0000  02 00 02 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0010  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0020  00 00 00 00 00 00 00 74 69 6d 00 00 00 00 00 00   |.......tim......|
0030  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0040  00 00 00 00 00 password 00 00 00   |......password...|
0050  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0060  00 00 00 00 07 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 02 00 06 04 08 01 00 00 00 00 00 02   |................|
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 64 6f 6e 6e 61 00 00 00 00 00 00 00 00   |...donna........|
00c0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
00d0  00 password 00 00 00 00 00 00 00   |..password.......|
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 07 04 02 00 00 43 54 2d 4c 69 62 72 61 72 79   |......CT-Library|
01e0  0a 00 00 00 00 00 0c 10 00 00 00 00 00 00 00 00   |................|
01f0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|


Sending packet @ 2001-07-12 09:43:16
0000  02 01 00 4c 00 00 00 00 00 00 00 00 00 00 00 00   |...L............|
0010  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0020  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|
0030  00 00 00 00 00 00 00 00 00 00 00 00 01 30 00 00   |.............0..|
0040  00 00 00 01 00 00 00 00 00 00 00 00               |............|


2001-07-12 09:43:16 inside tds_process_login_tokens()
2001-07-12 09:43:16 inside tds_process_default_tokens() marker is e3
2001-07-12 09:43:16 inside tds_process_default_tokens() marker is ab
2001-07-12 09:43:16 Msg 5701, Level 0, State 2, Server DONNA, Line 0
Changed database context to 'MAV_CIS_CustomerInvoicingSystem'.
2001-07-12 09:43:16 inside tds_process_default_tokens() marker is e3
2001-07-12 09:43:16 inside tds_process_default_tokens() marker is e3
2001-07-12 09:43:16 inside tds_process_default_tokens() marker is fd
2001-07-12 09:43:16 leaving tds_process_login_tokens() returning 1
2001-07-12 09:43:16 leaving ct_connect() returning 1
2001-07-12 09:43:16 inside ct_cmd_alloc()
2001-07-12 09:43:16 inside ct_command()
2001-07-12 09:43:16 inside ct_send()
Sending packet @ 2001-07-12 09:43:16
0000  01 01 00 2b 00 00 00 00 75 73 65 20 4d 41 56 5f   |...+....use MAV_|
0010  43 49 53 5f 43 75 73 74 6f 6d 65 72 49 6e 76 6f   |CIS_CustomerInvo|
0020  69 63 69 6e 67 53 79 73 74 65 6d                  |icingSystem|


2001-07-12 09:43:16 inside ct_results()
2001-07-12 09:43:16 processing result tokens.  marker is  e3
2001-07-12 09:43:16 inside tds_process_default_tokens() marker is e3
2001-07-12 09:43:16 processing result tokens.  marker is  ab
2001-07-12 09:43:16 processing result tokens.  marker is  fd
2001-07-12 09:43:16 inside ct_cmd_drop()
2001-07-12 09:43:16 inside ct_cmd_alloc()
2001-07-12 09:43:16 inside ct_command()
2001-07-12 09:43:16 inside ct_cmd_props()
2001-07-12 09:43:16 inside ct_send()
Sending packet @ 2001-07-12 09:43:16
0000  01 01 00 09 00 00 00 00 0a                        |.........|


2001-07-12 09:43:16 inside ct_results()
2001-07-12 09:43:16 processing result tokens.  marker is  fd
2001-07-12 09:43:16 inside ct_cmd_drop()
2001-07-12 09:43:16 inside ct_con_props() action = 25 property = 26
2001-07-12 09:43:16 inside ct_close()
2001-07-12 09:43:16 inside ct_con_drop()
2001-07-12 09:43:16 inside ct_exit()

CHEERS
Poorly