FreeTDS Development Group

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

Brian,

I got the tdspooling running (under 4.2) but it either has problems or I
am not using it correctly. I sqsh'ed into it then submitted the same query
4 times with the following result :-

[root@tim pool]# ./tdspool 
waiting for a connect
accepting connection
waiting for a connect
block size 0
host 
user tim
pass password
app  sqsh
srvr tim
vers 4.2
lib  CT-Library
lang 
char 
bsiz 0
waiting for a connect
0000  01 01 00 31 00 00 00 00 53 45 4c 45 43 54 20 43   |...1....SELECT C|
0010  4f 55 4e 54 28 2a 29 20 46 52 4f 4d 20 43 49 53   |OUNT(*) FROM CIS|
0020  5f 43 55 53 54 4d 52 5f 43 75 73 74 6f 6d 65 72   |_CUSTMR_Customer|
0030  0a                                                |.|

waiting for a connect
read 36 bytes from member 0
waiting for a connect
0000  01 01 00 31 00 00 00 00 53 45 4c 45 43 54 20 43   |...1....SELECT C|
0010  4f 55 4e 54 28 2a 29 20 46 52 4f 4d 20 43 49 53   |OUNT(*) FROM CIS|
0020  5f 43 55 53 54 4d 52 5f 43 75 73 74 6f 6d 65 72   |_CUSTMR_Customer|
0030  0a                                                |.|

No open connections left, opening member number 1
waiting for a connect
read 36 bytes from member 1
waiting for a connect
0000  01 01 00 31 00 00 00 00 53 45 4c 45 43 54 20 43   |...1....SELECT C|
0010  4f 55 4e 54 28 2a 29 20 46 52 4f 4d 20 43 49 53   |OUNT(*) FROM CIS|
0020  5f 43 55 53 54 4d 52 5f 43 75 73 74 6f 6d 65 72   |_CUSTMR_Customer|
0030  0a                                                |.|

No open connections left, opening member number 2
waiting for a connect
read 36 bytes from member 2
waiting for a connect
0000  01 01 00 31 00 00 00 00 53 45 4c 45 43 54 20 43   |...1....SELECT C|
0010  4f 55 4e 54 28 2a 29 20 46 52 4f 4d 20 43 49 53   |OUNT(*) FROM CIS|
0020  5f 43 55 53 54 4d 52 5f 43 75 73 74 6f 6d 65 72   |_CUSTMR_Customer|
0030  0a                                                |.|

No idle members left, increase MAX_POOL_CONN
Not enough free members...placing user in WAIT
waiting for a connect


Also with TDS 7.0, Many Apologies, OSX has been leading me astray ! I
still don't understand apples compiler bugs and library loading enough to
CORRECTLY use it to test.

So I jumped back to tried and true LinuxPPC and found that it is not
fixed, the figure I should get is 85114 not  2051801344 (though my
Marketing department would prefer the new figure ;-) )



[root@virginia pool]# sqsh -S Donna -U tim -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
            
 -----------
  2051801344

(1 row affected)
1> quit
[root@virginia pool]# cat /tmp/freetds.log 
2001-07-13 02:27:07 Connecting addr 172.20.1.237 port 1433
Sending packet @ 2001-07-13 02:27:07
0000  10 01 00 c8 00 00 01 00 c0 00 00 00 00 00 00 70   |...............p|
0010  00 00 00 00 00 00 00 06 83 f2 f8 ff 00 00 00 00   |................|
0020  e0 03 00 00 88 ff ff ff 36 04 00 00 56 00 00 00   |........6...V...|
0030  56 00 03 00 5c 00 07 00 6a 00 04 00 72 00 05 00   |V...\...j...r...|
0040  00 00 00 00 7c 00 0a 00 90 00 00 00 90 00 00 00   |....|...........|
0050  00 40 33 9a 6b 50 90 00 30 00 c0 00 00 00 74 00   |.@3.kP..0.....t.|
0060  69 00 6d 00 b3 a5 d3 a5 63 a5 e6 a5 d3 a5 b3 a5   |i.m.....c.......|
0070  92 a5 73 00 71 00 73 00 68 00 44 00 6f 00 6e 00   |..s.q.s.h.D.o.n.|
0080  6e 00 61 00 43 00 54 00 2d 00 4c 00 69 00 62 00   |n.a.C.T.-.L.i.b.|
0090  72 00 61 00 72 00 79 00 4e 54 4c 4d 53 53 50 00   |r.a.r.y.NTLMSSP.|
00a0  01 00 00 00 06 82 00 00 00 00 00 00 00 00 00 00   |................|
00b0  00 00 00 00 00 00 00 00 00 00 00 00 30 00 00 00   |............0...|
00c0  00 00 00 00 30 00 00 00                           |....0...|


2001-07-13 02:27:07 inside tds_process_login_tokens()
Received packet @ 2001-07-13 02:27:07
0000  e3 4d 00 01 1f 4d 00 41 00 56 00 5f 00 43 00 49   |.M...M.A.V._.C.I|
0010  00 53 00 5f 00 43 00 75 00 73 00 74 00 6f 00 6d   |.S._.C.u.s.t.o.m|
0020  00 65 00 72 00 49 00 6e 00 76 00 6f 00 69 00 63   |.e.r.I.n.v.o.i.c|
0030  00 69 00 6e 00 67 00 53 00 79 00 73 00 74 00 65   |.i.n.g.S.y.s.t.e|
0040  00 6d 00 06 6d 00 61 00 73 00 74 00 65 00 72 00   |.m..m.a.s.t.e.r.|
0050  ab 92 00 45 16 00 00 02 00 3e 00 43 00 68 00 61   |...E.....>.C.h.a|
0060  00 6e 00 67 00 65 00 64 00 20 00 64 00 61 00 74   |.n.g.e.d. .d.a.t|
0070  00 61 00 62 00 61 00 73 00 65 00 20 00 63 00 6f   |.a.b.a.s.e. .c.o|
0080  00 6e 00 74 00 65 00 78 00 74 00 20 00 74 00 6f   |.n.t.e.x.t. .t.o|
0090  00 20 00 27 00 4d 00 41 00 56 00 5f 00 43 00 49   |. .'.M.A.V._.C.I|
00a0  00 53 00 5f 00 43 00 75 00 73 00 74 00 6f 00 6d   |.S._.C.u.s.t.o.m|
00b0  00 65 00 72 00 49 00 6e 00 76 00 6f 00 69 00 63   |.e.r.I.n.v.o.i.c|
00c0  00 69 00 6e 00 67 00 53 00 79 00 73 00 74 00 65   |.i.n.g.S.y.s.t.e|
00d0  00 6d 00 27 00 2e 00 05 44 00 4f 00 4e 00 4e 00   |.m.'....D.O.N.N.|
00e0  41 00 00 00 00 e3 17 00 02 0a 75 00 73 00 5f 00   |A.........u.s._.|
00f0  65 00 6e 00 67 00 6c 00 69 00 73 00 68 00 00 ab   |e.n.g.l.i.s.h...|
0100  64 00 47 16 00 00 01 00 27 00 43 00 68 00 61 00   |d.G.....'.C.h.a.|
0110  6e 00 67 00 65 00 64 00 20 00 6c 00 61 00 6e 00   |n.g.e.d. .l.a.n.|
0120  67 00 75 00 61 00 67 00 65 00 20 00 73 00 65 00   |g.u.a.g.e. .s.e.|
0130  74 00 74 00 69 00 6e 00 67 00 20 00 74 00 6f 00   |t.t.i.n.g. .t.o.|
0140  20 00 75 00 73 00 5f 00 65 00 6e 00 67 00 6c 00   | .u.s._.e.n.g.l.|
0150  69 00 73 00 68 00 2e 00 05 44 00 4f 00 4e 00 4e   |i.s.h....D.O.N.N|
0160  00 41 00 00 00 00 e3 0f 00 03 05 69 00 73 00 6f   |.A.........i.s.o|
0170  00 5f 00 31 00 01 00 00 e3 0b 00 05 04 31 00 30   |._.1.........1.0|
0180  00 33 00 33 00 00 e3 0f 00 06 06 31 00 39 00 36   |.3.3.......1.9.6|
0190  00 36 00 30 00 39 00 00 ad 36 00 01 07 00 00 00   |.6.0.9...6......|
01a0  16 4d 00 69 00 63 00 72 00 6f 00 73 00 6f 00 66   |.M.i.c.r.o.s.o.f|
01b0  00 74 00 20 00 53 00 51 00 4c 00 20 00 53 00 65   |.t. .S.Q.L. .S.e|
01c0  00 72 00 76 00 65 00 72 00 00 00 00 00 07 00 03   |.r.v.e.r........|
01d0  c1 e3 13 00 04 04 34 00 30 00 39 00 36 00 04 34   |......4.0.9.6..4|
01e0  00 30 00 39 00 36 00 fd 00 00 00 00 00 00 00 00   |.0.9.6..........|


2001-07-13 02:27:07 inside tds_process_default_tokens() marker is e3
2001-07-13 02:27:07 inside tds_process_default_tokens() marker is ab
2001-07-13 02:27:07 Msg 5701, Level 0, State 2, Server DONNA, Line 0
Changed database context to 'MAV_CIS_CustomerInvoicingSystem'.
2001-07-13 02:27:07 inside tds_process_default_tokens() marker is e3
2001-07-13 02:27:07 inside tds_process_default_tokens() marker is ab
2001-07-13 02:27:07 Msg 5703, Level 0, State 1, Server DONNA, Line 0
Changed language setting to us_english.
2001-07-13 02:27:07 inside tds_process_default_tokens() marker is e3
2001-07-13 02:27:07 inside tds_process_default_tokens() marker is e3
2001-07-13 02:27:07 inside tds_process_default_tokens() marker is e3
2001-07-13 02:27:07 inside tds_process_default_tokens() marker is e3
2001-07-13 02:27:07 increasing block size from 4096 to 4096
2001-07-13 02:27:07 inside tds_process_default_tokens() marker is fd
2001-07-13 02:27:07 leaving tds_process_login_tokens() returning 1
2001-07-13 02:27:07 leaving ct_connect() returning 1
2001-07-13 02:27:07 inside ct_cmd_alloc()
2001-07-13 02:27:07 inside ct_command()
2001-07-13 02:27:07 inside ct_send()
Sending packet @ 2001-07-13 02:27:07
0000  01 01 00 4e 00 00 01 00 75 00 73 00 65 00 20 00   |...N....u.s.e. .|
0010  4d 00 41 00 56 00 5f 00 43 00 49 00 53 00 5f 00   |M.A.V._.C.I.S._.|
0020  43 00 75 00 73 00 74 00 6f 00 6d 00 65 00 72 00   |C.u.s.t.o.m.e.r.|
0030  49 00 6e 00 76 00 6f 00 69 00 63 00 69 00 6e 00   |I.n.v.o.i.c.i.n.|
0040  67 00 53 00 79 00 73 00 74 00 65 00 6d 00         |g.S.y.s.t.e.m.|


2001-07-13 02:27:07 inside ct_results()
Received packet @ 2001-07-13 02:27:07
0000  e3 7f 00 01 1f 4d 00 41 00 56 00 5f 00 43 00 49   |.....M.A.V._.C.I|
0010  00 53 00 5f 00 43 00 75 00 73 00 74 00 6f 00 6d   |.S._.C.u.s.t.o.m|
0020  00 65 00 72 00 49 00 6e 00 76 00 6f 00 69 00 63   |.e.r.I.n.v.o.i.c|
0030  00 69 00 6e 00 67 00 53 00 79 00 73 00 74 00 65   |.i.n.g.S.y.s.t.e|
0040  00 6d 00 1f 4d 00 41 00 56 00 5f 00 43 00 49 00   |.m..M.A.V._.C.I.|
0050  53 00 5f 00 43 00 75 00 73 00 74 00 6f 00 6d 00   |S._.C.u.s.t.o.m.|
0060  65 00 72 00 49 00 6e 00 76 00 6f 00 69 00 63 00   |e.r.I.n.v.o.i.c.|
0070  69 00 6e 00 67 00 53 00 79 00 73 00 74 00 65 00   |i.n.g.S.y.s.t.e.|
0080  6d 00 ab 92 00 45 16 00 00 01 00 3e 00 43 00 68   |m....E.....>.C.h|
0090  00 61 00 6e 00 67 00 65 00 64 00 20 00 64 00 61   |.a.n.g.e.d. .d.a|
00a0  00 74 00 61 00 62 00 61 00 73 00 65 00 20 00 63   |.t.a.b.a.s.e. .c|
00b0  00 6f 00 6e 00 74 00 65 00 78 00 74 00 20 00 74   |.o.n.t.e.x.t. .t|
00c0  00 6f 00 20 00 27 00 4d 00 41 00 56 00 5f 00 43   |.o. .'.M.A.V._.C|
00d0  00 49 00 53 00 5f 00 43 00 75 00 73 00 74 00 6f   |.I.S._.C.u.s.t.o|
00e0  00 6d 00 65 00 72 00 49 00 6e 00 76 00 6f 00 69   |.m.e.r.I.n.v.o.i|
00f0  00 63 00 69 00 6e 00 67 00 53 00 79 00 73 00 74   |.c.i.n.g.S.y.s.t|
0100  00 65 00 6d 00 27 00 2e 00 05 44 00 4f 00 4e 00   |.e.m.'....D.O.N.|
0110  4e 00 41 00 00 01 00 fd 00 00 e2 00 00 00 00 00   |N.A.............|


2001-07-13 02:27:07 processing result tokens.  marker is  e3
2001-07-13 02:27:07 inside tds_process_default_tokens() marker is e3
2001-07-13 02:27:07 processing result tokens.  marker is  ab
2001-07-13 02:27:07 processing result tokens.  marker is  fd
2001-07-13 02:27:07 inside ct_cmd_drop()
2001-07-13 02:27:14 inside ct_cmd_alloc()
2001-07-13 02:27:14 inside ct_command()
2001-07-13 02:27:14 inside ct_cmd_props()
2001-07-13 02:27:14 inside ct_send()
Sending packet @ 2001-07-13 02:27:14
0000  01 01 00 5a 00 00 01 00 53 00 45 00 4c 00 45 00   |...Z....S.E.L.E.|
0010  43 00 54 00 20 00 43 00 4f 00 55 00 4e 00 54 00   |C.T. .C.O.U.N.T.|
0020  28 00 2a 00 29 00 20 00 46 00 52 00 4f 00 4d 00   |(.*.). .F.R.O.M.|
0030  20 00 43 00 49 00 53 00 5f 00 43 00 55 00 53 00   | .C.I.S._.C.U.S.|
0040  54 00 4d 00 52 00 5f 00 43 00 75 00 73 00 74 00   |T.M.R._.C.u.s.t.|
0050  6f 00 6d 00 65 00 72 00 0a 00                     |o.m.e.r...|


2001-07-13 02:27:14 inside ct_results()
Received packet @ 2001-07-13 02:27:14
0000  81 01 00 00 00 09 00 26 04 00 d1 04 7a 4c 01 00   |.......&....zL..|
0010  fd 10 00 c1 00 01 00 00 00                        |.........|


2001-07-13 02:27:14 processing result tokens.  marker is  81
2001-07-13 02:27:14 processing result tokens.  marker is  d1
2001-07-13 02:27:14 inside ct_res_info()
2001-07-13 02:27:14 inside ct_describe()
2001-07-13 02:27:14 inside _ct_get_client_type()
2001-07-13 02:27:14 inside ct_describe() datafmt->datatype = 2 server type
38
2001-07-13 02:27:14 inside ct_bind()
2001-07-13 02:27:14 inside ct_bind() item = 1 datafmt->datatype = 1
2001-07-13 02:27:14 inside ct_fetch()
2001-07-13 02:27:14 processing row tokens.  marker is  d1
2001-07-13 02:27:14 setting column 0 to NULL
2001-07-13 02:27:14 inside _ct_bind_data()
2001-07-13 02:27:14 inside _ct_get_server_type()
2001-07-13 02:27:14 inside _ct_bind_data() converting column 0 from type
38 to type 47
2001-07-13 02:27:14 inside _ct_bind_data() setting source length for 0 = 4
2001-07-13 02:27:14 converting string dlen = 12 dtype = 47 string =
2051801344
2001-07-13 02:27:14 inside _ct_bind_data() conversion done len = 10
bindfmt = 1
2001-07-13 02:27:14 inside ct_fetch()
2001-07-13 02:27:14 processing row tokens.  marker is  fd
2001-07-13 02:27:14 inside ct_results()
2001-07-13 02:27:14 inside ct_res_info()
2001-07-13 02:27:14 inside ct_results()
2001-07-13 02:27:14 inside ct_cmd_drop()
2001-07-13 02:27:17 inside ct_con_props() action = 25 property = 26
2001-07-13 02:27:17 inside ct_close()
2001-07-13 02:27:17 inside ct_con_drop()
2001-07-13 02:27:17 inside ct_exit()

CHEERS
Poorly




> 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

<snip>

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