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 20:20:45 -0400


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




Archive powered by MHonArc 2.6.24.

Top of Page