FreeTDS Development Group

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

D'OH

It does work ! Idiot me playing with 'sqsh -C' ...
I tested multiple datatypes and they all worked ! Thankyou Brian !!!!

Log :-

[poorly@dingoblue:~] schaappa% /usr/local/bin/sqsh -U tim -S donna -D
MAV_CIS_CustomerInvoicingSystem
sqsh-1.7 Copyright (C) 1995-1999 Scott C. Gray
This is free software with ABSOLUTELY NO WARRANTY
For more information type '\warranty'
Password: 
1> SELECT COUNT ( * ) FROM CIS_CUSTMR_Customer
2> go
            
 -----------
       85114

(1 row affected)
1> quit 
[poorly@dingoblue:~] schaappa% cat /tmp/freetds.log                       
     2001-07-12 09:48:50 Connecting addr 172.20.1.237 port 1433
Sending packet @ 2001-07-12 09:48:50
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:48:50
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:48:50 inside tds_process_login_tokens()
2001-07-12 09:48:50 inside tds_process_default_tokens() marker is e3
2001-07-12 09:48:50 inside tds_process_default_tokens() marker is ab
2001-07-12 09:48:50 Msg 5701, Level 0, State 2, Server DONNA, Line 0
Changed database context to 'MAV_CIS_CustomerInvoicingSystem'.
2001-07-12 09:48:50 inside tds_process_default_tokens() marker is e3
2001-07-12 09:48:50 inside tds_process_default_tokens() marker is e3
2001-07-12 09:48:50 inside tds_process_default_tokens() marker is fd
2001-07-12 09:48:50 leaving tds_process_login_tokens() returning 1
2001-07-12 09:48:50 leaving ct_connect() returning 1
2001-07-12 09:48:50 inside ct_cmd_alloc()
2001-07-12 09:48:50 inside ct_command()
2001-07-12 09:48:50 inside ct_send()
Sending packet @ 2001-07-12 09:48:50
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:48:50 inside ct_results()
2001-07-12 09:48:50 processing result tokens.  marker is  e3
2001-07-12 09:48:50 inside tds_process_default_tokens() marker is e3
2001-07-12 09:48:50 processing result tokens.  marker is  ab
2001-07-12 09:48:50 processing result tokens.  marker is  fd
2001-07-12 09:48:50 inside ct_cmd_drop()
2001-07-12 09:49:01 inside ct_cmd_alloc()
2001-07-12 09:49:01 inside ct_command()
2001-07-12 09:49:01 inside ct_cmd_props()
2001-07-12 09:49:01 inside ct_send()
Sending packet @ 2001-07-12 09:49:01
0000  01 01 00 34 00 00 00 00 53 45 4c 45 43 54 20 43   |...4....SELECT C|
0010  4f 55 4e 54 20 28 20 2a 20 29 20 46 52 4f 4d 20   |OUNT ( * ) FROM |
0020  43 49 53 5f 43 55 53 54 4d 52 5f 43 75 73 74 6f   |CIS_CUSTMR_Custo|
0030  6d 65 72 0a                                       |mer.|


2001-07-12 09:49:01 inside ct_results()
2001-07-12 09:49:01 processing result tokens.  marker is  a0
2001-07-12 09:49:01 processing result tokens.  marker is  a1
2001-07-12 09:49:01 inside tds_process_default_tokens() marker is a1
2001-07-12 09:49:01 processing result tokens.  marker is  d1
2001-07-12 09:49:01 inside ct_res_info()
2001-07-12 09:49:01 inside ct_describe()
2001-07-12 09:49:01 inside _ct_get_client_type()
2001-07-12 09:49:01 inside ct_describe() datafmt->datatype = 2 server type
38
2001-07-12 09:49:01 inside ct_bind()
2001-07-12 09:49:01 inside ct_bind() item = 1 datafmt->datatype = 1
2001-07-12 09:49:01 inside ct_fetch()
2001-07-12 09:49:01 processing row tokens.  marker is  d1
2001-07-12 09:49:01 setting column 0 to NULL
2001-07-12 09:49:01 inside _ct_bind_data()
2001-07-12 09:49:01 inside _ct_get_server_type()
2001-07-12 09:49:01 inside _ct_bind_data() converting column 0 from type
38 to type 47
2001-07-12 09:49:01 inside _ct_bind_data() setting source length for 0 = 4
2001-07-12 09:49:01 converting string dlen = 12 dtype = 47 string = 85114
2001-07-12 09:49:01 inside _ct_bind_data() conversion done len = 5 bindfmt
= 1
2001-07-12 09:49:01 inside ct_fetch()
2001-07-12 09:49:01 processing row tokens.  marker is  fd
2001-07-12 09:49:01 inside ct_results()
2001-07-12 09:49:01 inside ct_res_info()
2001-07-12 09:49:01 inside ct_results()
2001-07-12 09:49:01 inside ct_cmd_drop()
2001-07-12 09:49:15 inside ct_con_props() action = 25 property = 26
2001-07-12 09:49:15 inside ct_close()
2001-07-12 09:49:15 inside ct_con_drop()
2001-07-12 09:49:15 inside ct_exit()

> 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

<snip>

> 
> CHEERS
> Poorly