Skip to Content.
Sympa Menu

freetds - Re: BIGENDIAN & TDS 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Paul Schaap" <paul.schaap AT dingoblue.com.au>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: BIGENDIAN & TDS 7.0
  • Date: Wed, 11 Jul 2001 21:31:35 -0400


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




Archive powered by MHonArc 2.6.24.

Top of Page