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

Chris McDaniel Chris.McDaniel at telus.com
Wed Jan 1 09:00:25 EST 2003


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


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





More information about the FreeTDS mailing list