Skip to Content.
Sympa Menu

freetds - RE: [freetds] DBD::ODBC (0.45), MS SQL, unixODBC, FreeTDS (CVS) , bind_param_ino ut

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Chris McDaniel" <Chris.McDaniel AT telus.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] DBD::ODBC (0.45), MS SQL, unixODBC, FreeTDS (CVS) , bind_param_ino ut
  • Date: Wed, 1 Jan 2003 09:00:25 -0700

Hello,

I got a fresh cvs checkout, recompiled and tried it again. Unfortunately I
cannot use tdsver 7.0 as it is an MS SQL 6.5 server and I get login failure
if I try higher tds versions (and a core dump). As before, I still get no
results back from the proc. Should I be trying to get them as in a normal
query? I tried that before, but no luck.

Same code, here is the DBI trace:

DBI 1.30-nothread dispatch trace level set to 2
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x1f3960)~0x1f3888 'use
BSRes2')
<- prepare= DBI::st=HASH(0x1f3978) at test3.pl line 9
-> execute for DBD::ODBC::st (DBI::st=HASH(0x1f3978)~0xf087c)
<- execute= '0E0' at test3.pl line 10
-> finish for DBD::ODBC::st (DBI::st=HASH(0x1f3978)~0xf087c)
<- finish= 1 at test3.pl line 11
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x1f3960)~0x1f3888 '{?=call
ShowConference 17050}')
<- prepare= DBI::st=HASH(0x1f3a74) at test3.pl line 12
-> bind_param_inout for DBD::ODBC::st (DBI::st=HASH(0x1f3a74)~0x1883f4 1
SCALAR(0x182a20) 10000)
<- bind_param_inout= 1 at test3.pl line 13
-> execute for DBD::ODBC::st (DBI::st=HASH(0x1f3a74)~0x1883f4)
<- execute= '0E0' at test3.pl line 14
bv
-> finish for DBD::ODBC::st (DBI::st=HASH(0x1f3a74)~0x1883f4)
<- finish= 1 at test3.pl line 18
-> disconnect for DBD::ODBC::db (DBI::db=HASH(0x1f3960)~0x1f3888)
<- disconnect= 1 at test3.pl line 20
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0xf087c)~INNER)
<- DESTROY= undef
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x1883f4)~INNER)
<- DESTROY= undef
-> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x1f3888)~INNER)
<- DESTROY= undef
-- DBI::END
-> disconnect_all for DBD::ODBC::dr (DBI::dr=HASH(0x1aa10c)~0x1f399c)
<- disconnect_all= '' at DBI.pm line 565
-> DESTROY in DBD::_::common for DBD::ODBC::dr
(DBI::dr=HASH(0x1f399c)~INNER)
<- DESTROY= undef during global destruction

Here is the freetds.log

Starting log file with debug level 99.
2003-01-01 10:46:58.029903 Connecting addr 142.178.18.4 port 1433 with TDS
version 4.2
Sending packet @ 2003-01-01 10:46:58.092702
0000 02 00 02 00 00 00 00 00 68 6f 73 74 69 6e 67 00 |........ hosting.|
0010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0020 00 00 00 00 00 00 07 77 65 62 65 78 00 00 00 00 |.......x xxxx....|
0030 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 05 33 36 32 31 31 38 00 00 00 00 |......xx xxxx....|
0050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 06 33 37 38 37 36 00 00 00 00 00 00 |.....378 76......|
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 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
00a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
00b0 00 00 00 53 59 42 41 53 45 00 00 00 00 00 00 00 |...SYBAS E.......|
00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
00d0 00 06 33 36 32 31 31 38 00 00 00 00 00 00 00 00 |..xxxxxx ........|
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 06 04 02 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
01e0 00 00 00 00 00 00 0c 10 75 73 5f 65 6e 67 6c 69 |........ us_engli|
01f0 73 68 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |sh...... ........|


Sending packet @ 2003-01-01 10:46:58.097188
0000 02 01 00 4c 00 00 00 00 00 00 00 00 00 00 0a 00 |...L.... ........|
0010 00 00 00 00 00 00 00 00 00 00 00 00 00 69 73 6f |........ .....iso|
0020 5f 31 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |_1...... ........|
0030 00 00 00 00 00 00 00 00 00 00 00 05 01 35 31 32 |........ .....512|
0040 00 00 00 03 00 00 00 00 00 00 00 00 |........ ....|


2003-01-01 10:46:58.098111 inside tds_process_login_tokens()
Received header @ 2003-01-01 10:46:58.405943
0000 04 01 00 8d 00 00 00 00 |........|


Received packet @ 2003-01-01 10:46:58.406347
0000 e3 00 0f 01 06 6d 61 73 74 65 72 06 6d 61 73 74 |.....mas ter.mast|
0010 65 72 ab 00 3a 00 00 16 45 02 00 00 25 43 68 61 |er..:... E...%Cha|
0020 6e 67 65 64 20 64 61 74 61 62 61 73 65 20 63 6f |nged dat abase co|
0030 6e 74 65 78 74 20 74 6f 20 27 6d 61 73 74 65 72 |ntext to 'master|
0040 27 2e 09 53 50 45 43 54 45 4c 42 53 00 00 00 ad |'..SPECT ELBS....|
0050 00 1e 01 04 02 00 00 14 4d 69 63 72 6f 73 6f 66 |........ Microsof|
0060 74 20 53 51 4c 20 53 65 72 76 65 72 5f 06 32 ff |t SQL Se rver_.2.|
0070 e3 00 09 04 03 35 31 32 03 35 31 32 fd 00 00 00 |.....512 .512....|
0080 00 00 00 00 00 |.....|


2003-01-01 10:46:58.407678 inside tds_process_default_tokens() marker is e3
2003-01-01 10:46:58.408053 inside tds_process_default_tokens() marker is ab
2003-01-01 10:46:58.408416 inside tds_process_default_tokens() marker is e3
2003-01-01 10:46:58.408734 inside tds_process_default_tokens() marker is fd
2003-01-01 10:46:58.409051 inside tds_process_end() more_results = 0,
was_cancelled = 0
2003-01-01 10:46:58.409365 inside tds_process_default_tokens() setting state
to COMPLETED
Sending packet @ 2003-01-01 10:46:58.409785
0000 01 01 00 15 00 00 00 00 73 65 6c 65 63 74 20 40 |........ select @|
0010 40 73 70 69 64 |@spid|


Received header @ 2003-01-01 10:46:58.469646
0000 04 01 00 22 00 00 00 00 |..."....|


Received packet @ 2003-01-01 10:46:58.470132
0000 a0 00 01 00 a1 00 06 00 00 00 06 26 02 d1 02 00 |........ ...&....|
0010 12 fd 00 10 00 c1 00 00 00 01 |........ ..|


2003-01-01 10:46:58.470613 processing result tokens. marker is a0
2003-01-01 10:46:58.470923 processing result tokens. marker is a1
2003-01-01 10:46:58.471250 processing result. type = 38(integer-null),
varint_size 1
2003-01-01 10:46:58.471586 processing row tokens. marker is d1
2003-01-01 10:46:58.471903 processing row. column is 0 varint size = 1
2003-01-01 10:46:58.472195 processing row. column size is 2
2003-01-01 10:46:58.472500 clearing column 0 NULL bit
2003-01-01 10:46:58.472788 processing row tokens. marker is fd
2003-01-01 10:46:58.473071 inside tds_process_end() more_results = 0,
was_cancelled = 0
2003-01-01 10:46:58.473385 inside tds_process_result_tokens() state is
COMPLETED
2003-01-01 10:46:58.473683 leaving tds_process_login_tokens() returning 1
SQLGetFunctions: fFunction is 999
SQLGetFunctions: fFunction is 1
SQLGetFunctions: fFunction is 2
SQLGetFunctions: fFunction is 1001
SQLGetFunctions: fFunction is 3
SQLGetFunctions: fFunction is 4
SQLGetFunctions: fFunction is 72
SQLGetFunctions: fFunction is 5
SQLGetFunctions: fFunction is 6
SQLGetFunctions: fFunction is 40
SQLGetFunctions: fFunction is 7
SQLGetFunctions: fFunction is 8
SQLGetFunctions: fFunction is 9
SQLGetFunctions: fFunction is 41
SQLGetFunctions: fFunction is 10
SQLGetFunctions: fFunction is 11
SQLGetFunctions: fFunction is 12
SQLGetFunctions: fFunction is 13
SQLGetFunctions: fFunction is 15
SQLGetFunctions: fFunction is 1006
SQLGetFunctions: fFunction is 16
SQLGetFunctions: fFunction is 14
SQLGetFunctions: fFunction is 42
SQLGetFunctions: fFunction is 43
SQLGetFunctions: fFunction is 44
SQLGetFunctions: fFunction is 45
SQLGetFunctions: fFunction is 1014
SQLGetFunctions: fFunction is 46
SQLGetFunctions: fFunction is 47
SQLGetFunctions: fFunction is 61
SQLGetFunctions: fFunction is 63
SQLGetFunctions: fFunction is 18
SQLGetFunctions: fFunction is 48
SQLGetFunctions: fFunction is 19
SQLGetFunctions: fFunction is 49
SQLGetFunctions: fFunction is 20
SQLGetFunctions: fFunction is 1016
SQLGetFunctions: fFunction is 50
SQLGetFunctions: fFunction is 51
SQLGetFunctions: fFunction is 54
SQLGetFunctions: fFunction is 23
change_autocommit: executing set implicit_transactions off
Sending packet @ 2003-01-01 10:46:58.476397
0000 01 01 00 25 00 00 00 00 73 65 74 20 69 6d 70 6c |...%.... set impl|
0010 69 63 69 74 5f 74 72 61 6e 73 61 63 74 69 6f 6e |icit_tra nsaction|
0020 73 20 6f 66 66 |s off|


Received header @ 2003-01-01 10:46:58.536629
0000 04 01 00 11 00 00 00 00 |........|


Received packet @ 2003-01-01 10:46:58.537029
0000 fd 00 00 00 ba 00 00 00 00 |........ .|


2003-01-01 10:46:58.537374 inside tds_process_default_tokens() marker is fd
2003-01-01 10:46:58.537681 inside tds_process_end() more_results = 0,
was_cancelled = 0
2003-01-01 10:46:58.537995 inside tds_process_default_tokens() setting state
to COMPLETED
change_autocommit: executing set implicit_transactions off
Sending packet @ 2003-01-01 10:46:58.538783
0000 01 01 00 25 00 00 00 00 73 65 74 20 69 6d 70 6c |...%.... set impl|
0010 69 63 69 74 5f 74 72 61 6e 73 61 63 74 69 6f 6e |icit_tra nsaction|
0020 73 20 6f 66 66 |s off|


Received header @ 2003-01-01 10:46:58.598727
0000 04 01 00 11 00 00 00 00 |........|


Received packet @ 2003-01-01 10:46:58.599116
0000 fd 00 00 00 ba 00 00 00 00 |........ .|


2003-01-01 10:46:58.599468 inside tds_process_default_tokens() marker is fd
2003-01-01 10:46:58.599776 inside tds_process_end() more_results = 0,
was_cancelled = 0
2003-01-01 10:46:58.600190 inside tds_process_default_tokens() setting state
to COMPLETED
Sending packet @ 2003-01-01 10:46:58.604164
0000 01 01 00 12 00 00 00 00 75 73 65 20 42 53 52 65 |........ use BSRe|
0010 73 32 |s2|


Received header @ 2003-01-01 10:46:58.664265
0000 04 01 00 60 00 00 00 00 |...`....|


Received packet @ 2003-01-01 10:46:58.664663
0000 e3 00 0f 01 06 42 53 52 65 73 32 06 6d 61 73 74 |.....BSR es2.mast|
0010 65 72 ab 00 3a 00 00 16 45 01 00 00 25 43 68 61 |er..:... E...%Cha|
0020 6e 67 65 64 20 64 61 74 61 62 61 73 65 20 63 6f |nged dat abase co|
0030 6e 74 65 78 74 20 74 6f 20 27 42 53 52 65 73 32 |ntext to 'BSRes2|
0040 27 2e 09 53 50 45 43 54 45 4c 42 53 00 00 01 fd |'..SPECT ELBS....|
0050 00 00 00 e2 00 00 00 00 |........|


2003-01-01 10:46:58.665637 processing result tokens. marker is e3
2003-01-01 10:46:58.665940 inside tds_process_default_tokens() marker is e3
2003-01-01 10:46:58.666244 processing result tokens. marker is ab
2003-01-01 10:46:58.666567 processing result tokens. marker is fd
2003-01-01 10:46:58.666874 inside tds_process_end() more_results = 0,
was_cancelled = 0
2003-01-01 10:46:58.667204 inside tds_process_result_tokens() state is
COMPLETED
2003-01-01 10:46:58.667608 inside tds_process_result_tokens() state is
COMPLETED
Sending packet @ 2003-01-01 10:46:58.675304
0000 01 01 00 21 00 00 00 00 65 78 65 63 20 53 68 6f |...!.... exec Sho|
0010 77 43 6f 6e 66 65 72 65 6e 63 65 20 31 37 30 35 |wConfere nce 1705|
0020 30 |0|


Received header @ 2003-01-01 10:46:58.737080
0000 04 00 02 00 00 00 00 00 |........|


Received packet @ 2003-01-01 10:46:58.737602
0000 7c 79 fd 19 be 00 00 00 00 a0 05 1f 0d 43 6f 6e ||y...... .....Con|
0010 66 65 72 65 6e 63 65 52 65 66 0e 52 65 73 65 72 |ferenceR ef.Reser|
0020 76 61 74 69 6f 6e 52 65 66 13 50 61 72 65 6e 74 |vationRe f.Parent|
0030 43 6f 6e 66 65 72 65 6e 63 65 52 65 66 14 43 6f |Conferen ceRef.Co|
0040 6e 66 65 72 65 6e 63 65 53 74 61 74 75 73 54 79 |nference StatusTy|
0050 70 65 17 43 6f 6e 66 65 72 65 6e 63 65 53 74 61 |pe.Confe renceSta|
0060 72 74 44 61 74 65 54 69 6d 65 15 43 6f 6e 66 65 |rtDateTi me.Confe|
0070 72 65 6e 63 65 45 6e 64 44 61 74 65 54 69 6d 65 |renceEnd DateTime|
0080 1a 43 6f 6e 66 65 72 65 6e 63 65 4f 72 69 67 69 |.Confere nceOrigi|
0090 6e 61 6c 44 75 72 61 74 69 6f 6e 0e 43 6f 6e 66 |nalDurat ion.Conf|
00a0 65 72 65 6e 63 65 54 79 70 65 16 43 6f 6e 66 65 |erenceTy pe.Confe|
00b0 72 65 6e 63 65 4c 61 6e 67 75 61 67 65 54 79 70 |renceLan guageTyp|
00c0 65 16 43 6f 6e 66 65 72 65 6e 63 65 50 72 69 6f |e.Confer encePrio|
00d0 72 69 74 79 54 79 70 65 0e 43 6f 6e 66 65 72 65 |rityType .Confere|
00e0 6e 63 65 4e 61 6d 65 12 43 6f 6e 66 65 72 65 6e |nceName. Conferen|
00f0 63 65 43 6f 6d 6d 65 6e 74 73 14 4e 75 6d 62 65 |ceCommen ts.Numbe|
0100 72 4f 66 53 75 62 43 6f 6e 66 65 72 65 65 73 14 |rOfSubCo nferees.|
0110 4e 75 6d 62 65 72 4f 66 50 61 72 74 69 63 69 70 |NumberOf Particip|
0120 61 6e 74 73 0c 4d 6f 64 65 72 61 74 6f 72 49 6e |ants.Mod eratorIn|
0130 64 09 44 65 6d 61 6e 64 49 6e 64 1a 43 61 6c 6c |d.Demand Ind.Call|
0140 43 68 61 69 72 6d 61 6e 50 61 72 74 69 63 69 70 |Chairman Particip|
0150 61 6e 74 52 65 66 0e 41 6c 6c 6f 63 61 74 69 6f |antRef.A llocatio|
0160 6e 54 79 70 65 09 52 65 63 65 70 74 69 6f 6e 0b |nType.Re ception.|
0170 50 61 79 6d 65 6e 74 54 79 70 65 0d 50 61 79 6d |PaymentT ype.Paym|
0180 65 6e 74 4e 75 6d 62 65 72 0c 42 69 6c 6c 44 69 |entNumbe r.BillDi|
0190 73 63 6f 75 6e 74 0b 4c 6f 63 61 6c 44 69 67 69 |scount.L ocalDigi|
01a0 74 73 0b 43 6f 6e 74 61 63 74 4e 61 6d 65 0c 43 |ts.Conta ctName.C|
01b0 6f 6e 74 61 63 74 50 68 6f 6e 65 0a 43 6f 6e 74 |ontactPh one.Cont|
01c0 61 63 74 46 61 78 0c 43 6f 6e 74 61 63 74 45 6d |actFax.C ontactEm|
01d0 61 69 6c 0c 52 65 63 6f 72 64 69 6e 67 49 6e 64 |ail.Reco rdingInd|
01e0 16 52 65 63 6f 72 64 69 6e 67 52 65 74 65 6e 74 |.Recordi ngRetent|
01f0 69 6f 6e 44 61 79 73 0c |ionDays.|


2003-01-01 10:46:58.741953 processing result tokens. marker is 7c
2003-01-01 10:46:58.742254 inside tds_process_default_tokens() marker is 7c
2003-01-01 10:46:58.742571 processing result tokens. marker is a0
Received header @ 2003-01-01 10:46:58.743079
0000 04 00 02 00 00 00 00 00 |........|


Received packet @ 2003-01-01 10:46:58.743494
0000 52 65 63 6f 72 64 69 6e 67 50 49 4e 11 52 65 63 |Recordin gPIN.Rec|
0010 6f 72 64 69 6e 67 43 6f 6d 6d 65 6e 74 73 0d 54 |ordingCo mments.T|
0020 72 61 6e 73 63 72 69 70 74 49 6e 64 07 54 61 70 |ranscrip tInd.Tap|
0030 65 49 6e 64 14 4d 61 69 6c 54 61 70 65 50 72 69 |eInd.Mai lTapePri|
0040 6f 72 69 74 79 54 79 70 65 0b 50 6c 61 79 62 61 |orityTyp e.Playba|
0050 63 6b 44 44 49 10 4e 6f 74 69 66 69 63 61 74 69 |ckDDI.No tificati|
0060 6f 6e 54 79 70 65 12 4e 74 66 43 6f 6e 66 69 72 |onType.N tfConfir|
0070 6d 61 74 69 6f 6e 49 6e 64 12 4e 74 66 43 61 6e |mationIn d.NtfCan|
0080 63 65 6c 6c 61 74 69 6f 6e 49 6e 64 0c 4e 74 66 |cellatio nInd.Ntf|
0090 43 68 61 6e 67 65 49 6e 64 0e 4e 74 66 52 65 6d |ChangeIn d.NtfRem|
00a0 69 6e 64 65 72 49 6e 64 0b 4e 74 66 43 6f 6d 6d |inderInd .NtfComm|
00b0 65 6e 74 73 07 44 61 74 61 49 6e 64 0c 44 61 74 |ents.Dat aInd.Dat|
00c0 61 55 73 65 72 6e 61 6d 65 0c 44 61 74 61 50 61 |aUsernam e.DataPa|
00d0 73 73 77 6f 72 64 08 44 61 74 61 43 6f 64 65 07 |ssword.D ataCode.|
00e0 44 61 74 61 55 52 4c 16 41 64 76 65 72 74 69 73 |DataURL. Advertis|
00f0 65 43 6f 6e 66 65 72 65 6e 63 65 49 6e 64 15 41 |eConfere nceInd.A|
0100 64 76 65 72 74 69 73 65 52 65 63 6f 72 64 69 6e |dvertise Recordin|
0110 67 49 6e 64 10 4e 74 66 41 74 74 65 6e 64 61 6e |gInd.Ntf Attendan|
0120 63 65 49 6e 64 0f 57 65 6c 63 6f 6d 65 46 69 72 |ceInd.We lcomeFir|
0130 73 74 4d 73 67 0a 57 65 6c 63 6f 6d 65 4d 73 67 |stMsg.We lcomeMsg|
0140 07 42 65 6c 6c 4d 73 67 0c 48 6f 6c 64 46 69 72 |.BellMsg .HoldFir|
0150 73 74 4d 73 67 07 48 6f 6c 64 4d 73 67 11 43 6f |stMsg.Ho ldMsg.Co|
0160 6e 66 65 72 65 6e 63 65 46 75 6c 6c 4d 73 67 0d |nference FullMsg.|
0170 53 74 61 72 74 4c 61 74 65 72 4d 73 67 0f 50 49 |StartLat erMsg.PI|
0180 4e 49 6e 63 6f 72 72 65 63 74 4d 73 67 15 50 6c |NIncorre ctMsg.Pl|
0190 61 63 65 64 49 6e 43 6f 6e 66 65 72 65 6e 63 65 |acedInCo nference|
01a0 4d 73 67 0b 45 6e 74 65 72 50 49 4e 4d 73 67 1c |Msg.Ente rPINMsg.|
01b0 43 6f 6e 66 65 72 65 6e 63 65 48 61 73 42 65 65 |Conferen ceHasBee|
01c0 6e 45 78 74 65 6e 64 65 64 4d 73 67 13 54 65 6e |nExtende dMsg.Ten|
01d0 4d 69 6e 75 74 65 57 61 72 6e 69 6e 67 4d 73 67 |MinuteWa rningMsg|
01e0 13 4f 6e 65 4d 69 6e 75 74 65 57 61 72 6e 69 6e |.OneMinu teWarnin|
01f0 67 4d 73 67 10 42 72 6f |gMsg.Bro|


Received header @ 2003-01-01 10:46:58.747594
0000 04 00 02 00 00 00 00 00 |........|


Received packet @ 2003-01-01 10:46:58.747984
0000 61 64 63 61 73 74 4d 6f 64 65 49 6e 64 0a 50 6f |adcastMo deInd.Po|
0010 6c 79 63 6f 6d 49 6e 64 0b 52 6f 6c 6c 43 61 6c |lycomInd .RollCal|
0020 6c 49 6e 64 0a 50 6f 6c 6c 69 6e 67 49 6e 64 08 |lInd.Pol lingInd.|
0030 51 61 6e 64 41 49 6e 64 0b 54 6f 6c 6c 46 72 65 |QandAInd .TollFre|
0040 65 49 6e 64 0c 45 6e 74 65 72 54 6f 6e 65 49 6e |eInd.Ent erToneIn|
0050 64 0e 4c 65 61 76 69 6e 67 54 6f 6e 65 49 6e 64 |d.Leavin gToneInd|
0060 06 41 63 70 63 49 64 11 4d 6f 64 69 66 69 63 61 |.AcpcId. Modifica|
0070 74 69 6f 6e 43 6f 75 6e 74 14 4d 6f 64 69 66 69 |tionCoun t.Modifi|
0080 63 61 74 69 6f 6e 44 61 74 65 54 69 6d 65 0c 43 |cationDa teTime.C|
0090 61 6e 63 65 6c 6c 65 64 49 6e 64 11 43 61 6e 63 |ancelled Ind.Canc|
00a0 65 6c 6c 65 64 44 61 74 65 54 69 6d 65 0a 41 75 |elledDat eTime.Au|
00b0 74 6f 50 49 4e 49 6e 64 08 55 73 65 73 43 50 49 |toPINInd .UsesCPI|
00c0 4e 08 55 73 65 73 4d 50 49 4e 0c 4f 70 65 72 61 |N.UsesMP IN.Opera|
00d0 74 6f 72 54 79 70 65 0c 54 69 6d 65 5a 6f 6e 65 |torType. TimeZone|
00e0 54 79 70 65 15 54 69 6d 65 5a 6f 6e 65 53 74 61 |Type.Tim eZoneSta|
00f0 72 74 44 61 74 65 54 69 6d 65 07 55 73 65 73 44 |rtDateTi me.UsesD|
0100 44 49 09 4c 6f 63 6b 65 64 49 6e 64 0d 53 74 72 |DI.Locke dInd.Str|
0110 65 61 6d 4c 69 76 65 49 6e 64 11 53 74 72 65 61 |eamLiveI nd.Strea|
0120 6d 50 6c 61 79 62 61 63 6b 49 6e 64 0e 45 78 74 |mPlaybac kInd.Ext|
0130 65 6e 73 69 6f 6e 43 6f 75 6e 74 a1 01 c2 00 00 |ensionCo unt.....|
0140 00 07 38 00 00 00 07 38 00 00 00 07 38 00 00 00 |..8....8 ....8...|
0150 73 30 00 00 00 69 3d 00 00 00 69 3d 00 00 00 06 |s0...i=. ..i=....|
0160 34 00 00 00 73 30 00 00 00 73 30 00 00 00 73 30 |4...s0.. .s0...s0|
0170 00 00 00 6f 27 32 00 00 00 68 27 ff 00 00 00 06 |...o'2.. .h'.....|
0180 34 00 00 00 06 34 00 00 00 10 32 00 00 00 10 32 |4....4.. ..2....2|
0190 00 00 00 07 38 00 00 00 73 30 00 00 00 06 34 00 |....8... s0....4.|
01a0 00 00 73 30 00 00 00 71 27 28 00 00 00 05 30 00 |..s0...q '(....0.|
01b0 00 00 05 26 01 00 00 00 6f 27 32 00 00 00 71 27 |...&.... o'2...q'|
01c0 28 00 00 00 71 27 28 00 00 00 6c 27 32 00 00 00 |(...q'(. ..l'2...|
01d0 10 32 00 00 00 06 34 00 00 00 72 27 0c 00 00 00 |.2....4. ..r'....|
01e0 68 27 ff 00 00 00 10 32 00 00 00 10 32 00 00 00 |h'.....2 ....2...|
01f0 73 30 00 00 00 6a 27 20 |s0...j' |


2003-01-01 10:46:58.752866 processing result tokens. marker is a1
2003-01-01 10:46:58.753211 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.753521 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.753829 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.754140 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.754459 processing result. type = 61(datetime),
varint_size 0
2003-01-01 10:46:58.754761 processing result. type = 61(datetime),
varint_size 0
2003-01-01 10:46:58.755080 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.755384 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.755698 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.755994 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.756309 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.756616 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.756933 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.757233 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.757554 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.757869 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.758189 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.758498 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.758823 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.759129 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.759450 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.759756 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.760184 processing result. type = 38(integer-null),
varint_size 1
2003-01-01 10:46:58.760492 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.760796 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.761109 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.761405 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.761722 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.762013 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.762323 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.762624 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.762935 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.763238 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.763543 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.763834 processing result. type = 39(varchar),
varint_size 1
Received header @ 2003-01-01 10:46:58.764199
0000 04 00 02 00 00 00 00 00 |........|


Received packet @ 2003-01-01 10:46:58.764587
0000 00 00 00 73 30 00 00 00 10 32 00 00 00 10 32 00 |...s0... .2....2.|
0010 00 00 10 32 00 00 00 10 32 00 00 00 68 27 ff 00 |...2.... 2...h'..|
0020 00 00 10 32 00 00 00 6f 27 32 00 00 00 70 27 08 |...2...o '2...p'.|
0030 00 00 00 70 27 08 00 00 00 68 27 ff 00 00 00 10 |...p'... .h'.....|
0040 32 00 00 00 10 32 00 00 00 10 32 00 00 00 06 34 |2....2.. ..2....4|
0050 00 00 00 06 34 00 00 00 06 34 00 00 00 06 34 00 |....4... .4....4.|
0060 00 00 06 34 00 00 00 06 34 00 00 00 06 34 00 00 |...4.... 4....4..|
0070 00 06 34 00 00 00 06 34 00 00 00 06 34 00 00 00 |..4....4 ....4...|
0080 06 34 00 00 00 06 34 00 00 00 06 34 00 00 00 10 |.4....4. ...4....|
0090 32 00 00 00 10 32 00 00 00 10 32 00 00 00 10 32 |2....2.. ..2....2|
00a0 00 00 00 10 32 00 00 00 10 32 00 00 00 10 32 00 |....2... .2....2.|
00b0 00 00 10 32 00 00 00 07 38 00 00 00 06 34 00 00 |...2.... 8....4..|
00c0 00 69 3d 00 00 00 10 32 00 00 00 69 3d 00 00 00 |.i=....2 ...i=...|
00d0 10 32 00 00 00 72 27 0c 00 00 00 72 27 0c 00 00 |.2...r'. ...r'...|
00e0 00 73 30 00 00 00 73 30 00 00 00 69 6f 08 00 00 |.s0...s0 ...io...|
00f0 00 6a 27 20 00 00 00 10 32 00 00 00 10 32 00 00 |.j' .... 2....2..|
0100 00 10 32 00 00 00 06 34 ff 00 51 00 c1 00 00 00 |..2....4 ..Q.....|
0110 00 7c 79 fd 19 be 00 00 00 00 a0 02 15 0d 43 6f |.|y..... ......Co|
0120 6e 66 65 72 65 6e 63 65 52 65 66 0e 50 61 72 74 |nference Ref.Part|
0130 69 63 69 70 61 6e 74 52 65 66 12 41 63 74 75 61 |icipantR ef.Actua|
0140 6c 43 6f 6e 74 61 63 74 50 68 6f 6e 65 10 41 63 |lContact Phone.Ac|
0150 74 75 61 6c 43 6f 6e 74 61 63 74 46 61 78 12 41 |tualCont actFax.A|
0160 63 74 75 61 6c 43 6f 6e 74 61 63 74 45 4d 61 69 |ctualCon tactEMai|
0170 6c 16 41 63 74 75 61 6c 43 68 61 72 67 65 54 72 |l.Actual ChargeTr|
0180 61 66 66 69 63 49 6e 64 0d 41 63 74 75 61 6c 44 |afficInd .ActualD|
0190 69 61 6c 4f 75 74 0b 41 73 73 69 67 6e 65 64 44 |ialOut.A ssignedD|
01a0 44 49 0b 41 73 73 69 67 6e 65 64 50 49 4e 10 43 |DI.Assig nedPIN.C|
01b0 6f 6e 73 6f 6c 65 4c 6f 63 6b 56 61 6c 75 65 11 |onsoleLo ckValue.|
01c0 4c 6f 63 6b 65 64 42 79 43 6f 6e 73 6f 6c 65 49 |LockedBy ConsoleI|
01d0 64 15 4c 6f 63 6b 65 64 42 79 43 68 61 6e 6e 65 |d.Locked ByChanne|
01e0 6c 4e 75 6d 62 65 72 13 43 6f 6e 73 6f 6c 65 44 |lNumber. ConsoleD|
01f0 69 61 6c 41 74 74 65 6d |ialAttem|


2003-01-01 10:46:58.768679 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.768985 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.769282 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.769584 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.769887 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.770292 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.770597 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.770897 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.771216 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.771520 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.771911 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.772209 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.772528 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.772840 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.773152 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.773456 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.773769 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.774076 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.774391 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.774701 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.775017 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.775318 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.775633 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.775947 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.776260 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.776573 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.776884 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.777186 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.777487 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.777799 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.778100 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.778408 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.778708 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.779022 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.779325 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.779633 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.779931 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.780328 processing result. type = 61(datetime),
varint_size 0
2003-01-01 10:46:58.780650 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.780961 processing result. type = 61(datetime),
varint_size 0
2003-01-01 10:46:58.781273 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.781578 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.781890 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.782200 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.782504 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.782815 processing result. type = 111(datetime-null),
varint_size 1
2003-01-01 10:46:58.783119 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.783420 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.783727 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.784024 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.784337 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.784656 processing result tokens. marker is ff
2003-01-01 10:46:58.784953 inside tds_process_end() more_results = 1,
was_cancelled = 0
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(15,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(16,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(28,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(32,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(33,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(37,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(38,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(39,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(40,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(42,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(47,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(48,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(49,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(63,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(64,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(65,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(66,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(67,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(68,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(69,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(70,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(74,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(76,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(83,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(84,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
SQLColAttributes(85,SQL_COLUMN_DISPLAY_SIZE): unknown client type -7
odbc:SQLColAttributes: fDescType is 3
odbc:SQLColAttributes: fDescType is 6
odbc:SQLColAttributes: fDescType is 3
Sending packet @ 2003-01-01 10:46:58.802523
0000 06 01 00 08 00 00 00 00 |........|


2003-01-01 10:46:58.802980 inside tds_process_default_tokens() marker is 7c
2003-01-01 10:46:58.803302 inside tds_process_default_tokens() marker is a0
Received header @ 2003-01-01 10:46:58.805553
0000 04 00 02 00 00 00 00 00 |........|


Received packet @ 2003-01-01 10:46:58.805942
0000 70 74 73 07 43 6f 6d 6d 65 6e 74 0a 44 65 6c 65 |pts.Comm ent.Dele|
0010 74 65 64 49 6e 64 0e 50 61 72 74 69 63 69 70 61 |tedInd.P articipa|
0020 6e 74 52 65 66 09 43 6c 69 65 6e 74 52 65 66 0f |ntRef.Cl ientRef.|
0030 50 61 72 74 69 63 69 70 61 6e 74 4e 61 6d 65 1a |Particip antName.|
0040 50 61 72 74 69 63 69 70 61 6e 74 44 65 66 43 6f |Particip antDefCo|
0050 6e 74 61 63 74 50 68 6f 6e 65 18 50 61 72 74 69 |ntactPho ne.Parti|
0060 63 69 70 61 6e 74 44 65 66 43 6f 6e 74 61 63 74 |cipantDe fContact|
0070 46 61 78 1a 50 61 72 74 69 63 69 70 61 6e 74 44 |Fax.Part icipantD|
0080 65 66 43 6f 6e 74 61 63 74 45 4d 61 69 6c 1b 50 |efContac tEMail.P|
0090 61 72 74 69 63 69 70 61 6e 74 44 65 66 44 69 61 |articipa ntDefDia|
00a0 6c 4f 75 74 4e 75 6d 62 65 72 1e 50 61 72 74 69 |lOutNumb er.Parti|
00b0 63 69 70 61 6e 74 44 65 66 43 68 61 72 67 65 54 |cipantDe fChargeT|
00c0 72 61 66 66 69 63 49 6e 64 13 50 61 72 74 69 63 |rafficIn d.Partic|
00d0 69 70 61 6e 74 41 64 48 6f 63 49 6e 64 15 50 61 |ipantAdH ocInd.Pa|
00e0 72 74 69 63 69 70 61 6e 74 41 64 48 6f 63 4f 72 |rticipan tAdHocOr|
00f0 64 65 72 16 50 61 72 74 69 63 69 70 61 6e 74 44 |der.Part icipantD|
0100 65 73 63 72 69 70 74 69 6f 6e 15 50 61 72 74 69 |escripti on.Parti|
0110 63 69 70 61 6e 74 45 78 74 65 72 6e 61 6c 49 44 |cipantEx ternalID|
0120 0a 44 65 6c 65 74 65 64 49 6e 64 0e 50 61 72 74 |.Deleted Ind.Part|
0130 69 63 69 70 61 6e 74 50 49 4e a1 00 a0 00 00 00 |icipantP IN......|
0140 07 38 00 00 00 07 38 00 00 00 71 27 28 00 00 00 |.8....8. ..q'(...|
0150 71 27 28 00 00 00 6c 27 32 00 00 00 10 32 00 00 |q'(...l' 2....2..|
0160 00 71 27 28 00 00 00 6a 27 20 00 00 00 72 27 0c |.q'(...j ' ...r'.|
0170 00 00 00 07 38 00 00 00 07 38 00 00 00 07 38 00 |....8... .8....8.|
0180 00 00 07 38 00 00 00 68 27 ff 00 00 00 10 32 00 |...8...h '.....2.|
0190 00 00 07 38 00 00 00 07 38 00 00 00 6f 27 32 00 |...8.... 8...o'2.|
01a0 00 00 71 27 28 00 00 00 71 27 28 00 00 00 6c 27 |..q'(... q'(...l'|
01b0 32 00 00 00 71 27 28 00 00 00 10 32 00 00 00 10 |2...q'(. ...2....|
01c0 32 00 00 00 06 34 00 00 00 6b 27 ff 00 00 00 07 |2....4.. .k'.....|
01d0 26 04 00 00 00 10 32 00 00 00 72 27 0c ff 00 51 |&.....2. ..r'...Q|
01e0 00 c1 00 00 00 00 7c 79 fd 19 be 00 00 00 00 a0 |......|y ........|
01f0 00 75 0d 43 6f 6e 66 65 |.u.Confe|


2003-01-01 10:46:58.810238 inside tds_process_default_tokens() marker is a1
2003-01-01 10:46:58.810557 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.810864 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.811182 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.811486 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.811796 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.812098 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.812407 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.812707 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.813013 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.813313 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.813622 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.813918 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.814230 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.814523 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.814837 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.815132 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.815445 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.815738 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.816052 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.816345 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.816651 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.816957 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.817321 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.817639 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.817956 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.818271 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.818580 processing result. type = 38(integer-null),
varint_size 1
2003-01-01 10:46:58.818896 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.819203 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.819528 inside tds_process_default_tokens() marker is ff
2003-01-01 10:46:58.819825 inside tds_process_end() more_results = 1,
was_cancelled = 0
2003-01-01 10:46:58.820438 inside tds_process_default_tokens() marker is 7c
2003-01-01 10:46:58.820745 inside tds_process_default_tokens() marker is a0
Received header @ 2003-01-01 10:46:58.821090
0000 04 00 02 00 00 00 00 00 |........|


Received packet @ 2003-01-01 10:46:58.821490
0000 72 65 6e 63 65 52 65 66 0b 52 65 73 6f 75 72 63 |renceRef .Resourc|
0010 65 52 65 66 0c 52 65 73 6f 75 72 63 65 54 79 70 |eRef.Res ourceTyp|
0020 65 10 55 73 65 64 42 6f 6f 6b 61 62 6c 65 50 6f |e.UsedBo okablePo|
0030 6f 6c 11 55 73 65 64 45 78 74 65 6e 73 69 6f 6e |ol.UsedE xtension|
0040 50 6f 6f 6c 10 55 73 65 64 4f 70 65 72 61 74 6f |Pool.Use dOperato|
0050 72 50 6f 6f 6c 07 55 73 65 73 44 44 49 08 55 73 |rPool.Us esDDI.Us|
0060 65 73 43 50 49 4e 08 55 73 65 73 4d 50 49 4e a1 |esCPIN.U sesMPIN.|
0070 00 30 00 00 00 07 38 00 00 00 07 38 00 00 00 73 |.0....8. ...8...s|
0080 30 00 00 00 07 38 00 00 00 07 38 00 00 00 07 38 |0....8.. ..8....8|
0090 00 00 00 6a 27 20 00 00 00 72 27 0c 00 00 00 72 |...j' .. .r'....r|
00a0 27 0c ff 00 51 00 c1 00 00 00 00 7c 79 fd 19 be |'...Q... ...|y...|
00b0 00 00 00 00 a0 00 95 0d 43 6f 6e 66 65 72 65 6e |........ Conferen|
00c0 63 65 52 65 66 11 45 78 74 65 6e 64 65 64 42 79 |ceRef.Ex tendedBy|
00d0 55 73 65 72 52 65 66 10 45 78 74 65 6e 64 65 64 |UserRef. Extended|
00e0 44 61 74 65 54 69 6d 65 0e 4f 6c 64 45 6e 64 44 |DateTime .OldEndD|
00f0 61 74 65 54 69 6d 65 0e 4e 65 77 45 6e 64 44 61 |ateTime. NewEndDa|
0100 74 65 54 69 6d 65 17 4f 6c 64 4e 75 6d 62 65 72 |teTime.O ldNumber|
0110 4f 66 50 61 72 74 69 63 69 70 61 6e 74 73 17 4e |OfPartic ipants.N|
0120 65 77 4e 75 6d 62 65 72 4f 66 50 61 72 74 69 63 |ewNumber OfPartic|
0130 69 70 61 6e 74 73 15 41 75 74 6f 6d 61 74 69 63 |ipants.A utomatic|
0140 45 78 74 65 6e 73 69 6f 6e 49 6e 64 a1 00 28 00 |Extensio nInd..(.|
0150 00 00 07 38 00 00 00 07 38 00 00 00 69 3d 00 00 |...8.... 8...i=..|
0160 00 69 3d 00 00 00 69 3d 00 00 00 06 34 00 00 00 |.i=...i= ....4...|
0170 06 34 00 00 00 10 32 ff 00 51 00 c1 00 00 00 00 |.4....2. .Q......|
0180 7c 79 fd 19 be 00 00 00 00 a0 00 6b 0d 43 6f 6e ||y...... ...k.Con|
0190 66 65 72 65 6e 63 65 52 65 66 07 55 73 65 72 52 |ferenceR ef.UserR|
01a0 65 66 14 43 61 6e 63 65 6c 6c 61 74 69 6f 6e 44 |ef.Cance llationD|
01b0 61 74 65 54 69 6d 65 16 43 61 6e 63 65 6c 6c 61 |ateTime. Cancella|
01c0 74 69 6f 6e 52 65 61 73 6f 6e 54 79 70 65 13 43 |tionReas onType.C|
01d0 61 6e 63 65 6c 6c 61 74 69 6f 6e 43 6f 6d 6d 65 |ancellat ionComme|
01e0 6e 74 14 43 61 6e 63 65 6c 6c 61 74 69 6f 6e 44 |nt.Cance llationD|
01f0 69 73 63 6f 75 6e 74 a1 |iscount.|


2003-01-01 10:46:58.825641 inside tds_process_default_tokens() marker is a1
2003-01-01 10:46:58.825951 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.826276 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.826577 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.826894 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.827201 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.827521 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.827827 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.828137 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.828443 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.828755 inside tds_process_default_tokens() marker is ff
2003-01-01 10:46:58.829062 inside tds_process_end() more_results = 1,
was_cancelled = 0
2003-01-01 10:46:58.829409 inside tds_process_default_tokens() marker is 7c
2003-01-01 10:46:58.829704 inside tds_process_default_tokens() marker is a0
2003-01-01 10:46:58.830143 inside tds_process_default_tokens() marker is a1
2003-01-01 10:46:58.830460 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.830761 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.831079 processing result. type = 61(datetime),
varint_size 0
2003-01-01 10:46:58.831380 processing result. type = 61(datetime),
varint_size 0
2003-01-01 10:46:58.831699 processing result. type = 61(datetime),
varint_size 0
2003-01-01 10:46:58.832003 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.832322 processing result. type = 52(smallint),
varint_size 0
2003-01-01 10:46:58.832624 processing result. type = 50(bit), varint_size 0
2003-01-01 10:46:58.832942 inside tds_process_default_tokens() marker is ff
2003-01-01 10:46:58.833248 inside tds_process_end() more_results = 1,
was_cancelled = 0
2003-01-01 10:46:58.833576 inside tds_process_default_tokens() marker is 7c
2003-01-01 10:46:58.833856 inside tds_process_default_tokens() marker is a0
2003-01-01 10:46:58.834180 inside tds_process_default_tokens() marker is a1
Received header @ 2003-01-01 10:46:58.834513
0000 04 01 00 40 00 00 00 00 |...@....|


Received packet @ 2003-01-01 10:46:58.834905
0000 00 1f 00 00 00 07 38 00 00 00 07 38 00 00 00 69 |......8. ...8...i|
0010 3d 00 00 00 73 30 00 00 00 68 27 ff 00 00 00 05 |=...s0.. .h'.....|
0020 30 ff 00 51 00 c1 00 00 00 00 79 00 00 00 00 fe |0..Q.... ..y.....|
0030 00 08 00 e0 00 00 00 00 |........|


2003-01-01 10:46:58.835619 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.835936 processing result. type = 56(int), varint_size 0
2003-01-01 10:46:58.836238 processing result. type = 61(datetime),
varint_size 0
2003-01-01 10:46:58.836543 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.836855 processing result. type = 39(varchar),
varint_size 1
2003-01-01 10:46:58.837161 processing result. type = 48(tinyint),
varint_size 0
2003-01-01 10:46:58.837458 inside tds_process_default_tokens() marker is ff
2003-01-01 10:46:58.837770 inside tds_process_end() more_results = 1,
was_cancelled = 0
2003-01-01 10:46:58.838097 inside tds_process_default_tokens() marker is 79
2003-01-01 10:46:58.838404 inside tds_process_default_tokens() marker is fe
2003-01-01 10:46:58.838702 inside tds_process_end() more_results = 0,
was_cancelled = 0
2003-01-01 10:46:58.839027 inside tds_process_default_tokens() setting state
to COMPLETED
Received header @ 2003-01-01 10:46:58.959090
0000 04 01 00 11 00 00 00 00 |........|


Received packet @ 2003-01-01 10:46:58.959487
0000 fd 00 20 00 00 00 00 00 00 |.. ..... .|


2003-01-01 10:46:58.959855 inside tds_process_end() more_results = 0,
was_cancelled = 1
SQLFreeHandle(2, 0x1e8560)
SQLFreeHandle(1, 0xf0740)

-----Original Message-----
From: Frediano Ziglio [mailto:freddyz77 AT tin.it]
Sent: December 31, 2002 6:15 AM
To: FreeTDS
Subject: Re: [freetds] DBD::ODBC (0.45), MS SQL, unixODBC, FreeTDS
(CVS), bind_param_ino ut


Il dom, 2002-12-29 alle 16:33, Chris McDaniel ha scritto:
> Hello,
>
> I was hoping that someone could help me out with my stored procedure
> problems...
> Here is my code:
>
> #!/usr/bin/perl -w
> use DBI();
> #connect to DB
> my $dbh = DBI->connect("DBI:ODBC:SBS",
> "xxxxxx", "xxxxxx",
> {'RaiseError' => 1});
> DBI->trace(2);
> my ( $bind_value );
> my $sth0 = $dbh->prepare('use BSRes2');
> $sth0->execute();
> $sth0->finish();
> my $sth = $dbh->prepare('{?=call ShowConference 17050}');
> $sth->bind_param_inout(1, \$bind_value, 10000);
> $sth->execute();
>
> print "bv ",$bind_value,"\n";
> $sth->finish();
>
> # close DB connection
> $dbh->disconnect();
>

... omissis ...

Should be fixed in CVS.

freddy77


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page