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

Chris McDaniel Chris.McDaniel at telus.com
Sun Dec 29 08:33:58 EST 2002


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();

Here is my output:
   DBI 1.30-nothread dispatch trace level set to 2
   -> prepare for DBD::ODBC::db (DBI::db=HASH(0x1e8238)~0x1e8160 'use
BSRes2')
   <- prepare= DBI::st=HASH(0x1e8250) at test3.pl line 9
   -> execute for DBD::ODBC::st (DBI::st=HASH(0x1e8250)~0xf087c)
   <- execute= '0E0' at test3.pl line 10
   -> finish for DBD::ODBC::st (DBI::st=HASH(0x1e8250)~0xf087c)
   <- finish= 1 at test3.pl line 11
   -> prepare for DBD::ODBC::db (DBI::db=HASH(0x1e8238)~0x1e8160 '{?=call
ShowConference 17050}')
   <- prepare= DBI::st=HASH(0x1e834c) at test3.pl line 12
   -> bind_param_inout for DBD::ODBC::st (DBI::st=HASH(0x1e834c)~0x1884e0 1
SCALAR(0x1dc834) 10000)
   <- bind_param_inout= 1 at test3.pl line 13
   -> execute for DBD::ODBC::st (DBI::st=HASH(0x1e834c)~0x1884e0)
   <- execute= '0E0' at test3.pl line 14
bv
   -> finish for DBD::ODBC::st (DBI::st=HASH(0x1e834c)~0x1884e0)
   <- finish= 1 at test3.pl line 18
   -> disconnect for DBD::ODBC::db (DBI::db=HASH(0x1e8238)~0x1e8160)
   <- 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(0x1884e0)~INNER)
   <- DESTROY= undef
   -> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x1e8160)~INNER)
   <- DESTROY= undef
   -- DBI::END
   -> disconnect_all for DBD::ODBC::dr (DBI::dr=HASH(0x1a99e4)~0x1e8274)
   <- disconnect_all= '' at DBI.pm line 565
   -> DESTROY in DBD::_::common for DBD::ODBC::dr (DBI::dr=HASH(0x1e8274)
~INNER)
   <- DESTROY= undef during global destruction

and the driver trace below - shows that certain values are coming back - 

Can anyone tell me what I'm doing wrong?  Why don't I get the output?
 
Thanks,
Chris

Starting log file with debug level 99.
2002-12-27 17:30:04.500260 Connecting addr 142.178.18.4 port 1433 with TDS
version 4.2
Sending packet @ 2002-12-27 17:30:04.563402
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 70 65 63 74  65 6c 42 53 00 00 00 00   |...Spect elBS....|
00c0  00 00 00 00 00 00 00 00  00 00 00 00 00 00 00 00   |........ ........|
00d0  00 09 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 @ 2002-12-27 17:30:04.567747
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               |........ ....|
 
 
2002-12-27 17:30:04.568625 inside tds_process_login_tokens()
Received header @ 2002-12-27 17:30:04.830345
0000  04 01 00 8d 00 00 00 00                            |........|
 
 
Received packet @ 2002-12-27 17:30:04.830809
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                                     |.....|
 
 
2002-12-27 17:30:04.832150 inside tds_process_default_tokens() marker is e3
2002-12-27 17:30:04.832533 inside tds_process_default_tokens() marker is ab
2002-12-27 17:30:04.832958 inside tds_process_default_tokens() marker is e3
2002-12-27 17:30:04.833259 inside tds_process_default_tokens() marker is fd
2002-12-27 17:30:04.833580 inside tds_process_end() more_results = 0,
was_cancelled = 0
2002-12-27 17:30:04.833908 inside tds_process_default_tokens() setting state
to OMPLETED
Sending packet @ 2002-12-27 17:30:04.834336
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 @ 2002-12-27 17:30:04.894041
0000  04 01 00 22 00 00 00 00                            |..."....|
 
 
Received packet @ 2002-12-27 17:30:04.894426
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                     |........ ..|
 
 
2002-12-27 17:30:04.894904 processing result tokens.  marker is  a0
2002-12-27 17:30:04.895225 processing result tokens.  marker is  a1
2002-12-27 17:30:04.895546 processing result. type = 38(integer-null),
varint_size 1
2002-12-27 17:30:04.895870 processing row tokens.  marker is  d1
2002-12-27 17:30:04.896164 processing row.  column is 0 varint size = 1
2002-12-27 17:30:04.896469 processing row.  column size is 2
2002-12-27 17:30:04.896767 clearing column 0 NULL bit
2002-12-27 17:30:04.897073 processing row tokens.  marker is  fd
2002-12-27 17:30:04.897364 inside tds_process_end() more_results = 0,
was_cancelled = 0
2002-12-27 17:30:04.897708 inside tds_process_result_tokens() state is
COMPLETED
2002-12-27 17:30:04.897995 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 @ 2002-12-27 17:30:04.900950
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 @ 2002-12-27 17:30:04.961487
0000  04 01 00 11 00 00 00 00                            |........|
 
 
Received packet @ 2002-12-27 17:30:04.961863
0000  fd 00 00 00 ba 00 00 00  00                        |........ .|
 
 
2002-12-27 17:30:04.962199 inside tds_process_default_tokens() marker is fd
2002-12-27 17:30:04.962497 inside tds_process_end() more_results = 0,
was_cancelled = 0
2002-12-27 17:30:04.962798 inside tds_process_default_tokens() setting state
to OMPLETED
change_autocommit: executing set implicit_transactions off
Sending packet @ 2002-12-27 17:30:04.963561
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 @ 2002-12-27 17:30:05.023131
0000  04 01 00 11 00 00 00 00                            |........|
 
 
Received packet @ 2002-12-27 17:30:05.023513
0000  fd 00 00 00 ba 00 00 00  00                        |........ .|
 
 
2002-12-27 17:30:05.023864 inside tds_process_default_tokens() marker is fd
2002-12-27 17:30:05.024155 inside tds_process_end() more_results = 0,
was_cancelled = 0
2002-12-27 17:30:05.024473 inside tds_process_default_tokens() setting state
to OMPLETED
Sending packet @ 2002-12-27 17:30:05.026824
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 @ 2002-12-27 17:30:05.086473
0000  04 01 00 60 00 00 00 00                            |...`....|
 
 
Received packet @ 2002-12-27 17:30:05.086868
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                            |........|
 
 
2002-12-27 17:30:05.087812 processing result tokens.  marker is  e3
2002-12-27 17:30:05.088099 inside tds_process_default_tokens() marker is e3
2002-12-27 17:30:05.088399 processing result tokens.  marker is  ab
2002-12-27 17:30:05.088716 processing result tokens.  marker is  fd
2002-12-27 17:30:05.088999 inside tds_process_end() more_results = 0,
was_cancelled = 0
2002-12-27 17:30:05.089325 inside tds_process_result_tokens() state is
COMPLETED
2002-12-27 17:30:05.089736 inside tds_process_result_tokens() state is
COMPLETED
Sending packet @ 2002-12-27 17:30:05.097545
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 @ 2002-12-27 17:30:05.160475
0000  04 00 02 00 00 00 00 00                            |........|
 
 
Received packet @ 2002-12-27 17:30:05.160895
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.|
 
 
2002-12-27 17:30:05.164915 processing result tokens.  marker is  7c
2002-12-27 17:30:05.165211 inside tds_process_default_tokens() marker is 7c
2002-12-27 17:30:05.165507 processing result tokens.  marker is  a0
Received header @ 2002-12-27 17:30:05.165908
0000  04 00 02 00 00 00 00 00                            |........|
 
 
Received packet @ 2002-12-27 17:30:05.166305
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 @ 2002-12-27 17:30:05.170409
0000  04 00 02 00 00 00 00 00                            |........|
 
 
Received packet @ 2002-12-27 17:30:05.170803
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' |
 
 
2002-12-27 17:30:05.175594 processing result tokens.  marker is  a1
2002-12-27 17:30:05.175918 processing result. type = 56(int), varint_size 0
2002-12-27 17:30:05.176213 processing result. type = 56(int), varint_size 0
2002-12-27 17:30:05.176511 processing result. type = 56(int), varint_size 0
2002-12-27 17:30:05.176811 processing result. type = 48(tinyint),
varint_size 0
2002-12-27 17:30:05.177117 processing result. type = 61(datetime),
varint_size 0
2002-12-27 17:30:05.177407 processing result. type = 61(datetime),
varint_size 0
2002-12-27 17:30:05.177706 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.178011 processing result. type = 48(tinyint),
varint_size 0
2002-12-27 17:30:05.178310 processing result. type = 48(tinyint),
varint_size 0
2002-12-27 17:30:05.178606 processing result. type = 48(tinyint),
varint_size 0
2002-12-27 17:30:05.178910 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.179218 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.179522 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.179820 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.180273 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.180577 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.180887 processing result. type = 56(int), varint_size 0
2002-12-27 17:30:05.181185 processing result. type = 48(tinyint),
varint_size 0
2002-12-27 17:30:05.181488 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.181787 processing result. type = 48(tinyint),
varint_size 0
2002-12-27 17:30:05.182083 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.182382 processing result. type = 48(tinyint),
varint_size 0
2002-12-27 17:30:05.182678 processing result. type = 38(integer-null),
varint_size 1
2002-12-27 17:30:05.182971 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.183272 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.183570 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.183863 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.184158 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.184459 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.184754 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.185049 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.185344 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.185643 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.185949 processing result. type = 48(tinyint),
varint_size 0
2002-12-27 17:30:05.186241 processing result. type = 39(varchar),
varint_size 1
Received header @ 2002-12-27 17:30:05.186586
0000  04 00 02 00 00 00 00 00                            |........|
 
 
Received packet @ 2002-12-27 17:30:05.186960
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|
 
 
2002-12-27 17:30:05.190992 processing result. type = 48(tinyint),
varint_size 0
2002-12-27 17:30:05.191288 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.191597 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.191912 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.192208 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.192501 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.192797 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.193111 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.193407 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.193700 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.194056 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.194371 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.194672 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.194967 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.195276 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.195582 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.195892 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.196193 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.196495 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.196800 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.197109 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.197412 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.197722 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.198032 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.198339 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.198646 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.198959 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.199270 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.199576 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.199883 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.200287 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.200587 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.200890 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.201195 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.201498 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.201803 processing result. type = 56(int), varint_size 0
2002-12-27 17:30:05.202101 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.202402 processing result. type = 61(datetime),
varint_size 0
2002-12-27 17:30:05.202703 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.203005 processing result. type = 61(datetime),
varint_size 0
2002-12-27 17:30:05.203302 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.203608 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.203908 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.204209 processing result. type = 48(tinyint),
varint_size 0
2002-12-27 17:30:05.204511 processing result. type = 48(tinyint),
varint_size 0
2002-12-27 17:30:05.204813 processing result. type = 111(datetime-null),
varint_size 1
2002-12-27 17:30:05.205121 processing result. type = 39(varchar),
varint_size 1
2002-12-27 17:30:05.205428 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.205729 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.206036 processing result. type = 50(bit), varint_size 0
2002-12-27 17:30:05.206338 processing result. type = 52(smallint),
varint_size 0
2002-12-27 17:30:05.206652 processing result tokens.  marker is  ff
2002-12-27 17:30:05.206927 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
dbc: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
dbc: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 @ 2002-12-27 17:30:05.224267
0000  06 01 00 08 00 00 00 00                            |........|
 
 
2002-12-27 17:30:05.224735 inside tds_process_default_tokens() marker is 7c
2002-12-27 17:30:05.225045 inside tds_process_default_tokens() marker is a0
Received header @ 2002-12-27 17:30:05.228603
0000  04 00 02 00 00 00 00 00                            |........|
 
 
Received packet @ 2002-12-27 17:30:05.228990
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|
 
 
2002-12-27 17:30:05.233164 inside tds_process_default_tokens() marker is a1
Unknown marker: 161(a1)!!
SQLFreeHandle(2, 0x1f5758)
SQLFreeHandle(1, 0xf0750)
 
 
 
 




More information about the FreeTDS mailing list