Forwarded to dbi-users mailing list.
> Hello,
>
> Like I said in the subject, I really do hate to bother you
> directly with
> this, but I thought if anyone could help me with this, it
> would probably be
> you. I'm trying to use perl and DBD::ODBC to access stored
> procs in a
> remote database as part of a high-profile project within my
> company - I am
> sort of a 'lone ranger' type as there are not too many other
> perl and open
> source proponents at my level of responsibility at work so
> I'm starting to
> get a little twitchy about solving this particular problem.
> Anyway, I hope
> you'll forgive me, I know if everyone emailed the developer
> with there
> problems we'd probably be short on developers, but I have
> tried many other
> avenues and I'm still coming up short. My issue is that while I can
> execute stored procs, I can;t get any return values in my
> script, although
> some data shows up in the driver trace. Also, just so you
> knowm I did post
> this to the dbi-users list a couple days ago. I'll copy
> anything I learn
> back to the list. I'm just not sure how much help I'll get
> there as I
> commited yet another faux pas - I somehow posted my message 3
> times in a
> row - my bad again. I also posted it to the freetds list and haven't
> gotten anything on that front either.
>
> Sincerely,
>
> Chris McDaniel
>
> BTW I'm using DBD::ODBC (0.45), MS SQL, unixODBC, and FreeTDS
> (from CVS,
> about a week old now)
> I've also tried DBD::ODBC 0.43 and 1.01.
>
> Thanks
>
> 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 -
> sorry for the length - just wanted to get it all in.
> �
> 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
> |.......xxxxxx....|
> 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
> |......xxxxxx....|
> 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 COMPLETED
> 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 COMPLETED
> 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 COMPLETED
> 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
> 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 @ 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)
>
