Subversion Repository Public Repository

ConnectionOdbcSdk

Diff Revisions 25 vs 28 for /trunk/DevGuide/ConnectionOdbcDotNetSdk.htm

Diff revisions: vs.
  @@ -16,18 +16,18 @@
16 16 <o:Author>Jeff Lindborg</o:Author>
17 17 <o:Template>AppsHelp.dot</o:Template>
18 18 <o:LastAuthor>jlindborg</o:LastAuthor>
19 - <o:Revision>7</o:Revision>
20 - <o:TotalTime>8571</o:TotalTime>
21 - <o:LastPrinted>2014-01-10T20:48:00Z</o:LastPrinted>
19 + <o:Revision>10</o:Revision>
20 + <o:TotalTime>8657</o:TotalTime>
21 + <o:LastPrinted>2014-03-18T16:19:00Z</o:LastPrinted>
22 22 <o:Created>2014-01-09T00:58:00Z</o:Created>
23 - <o:LastSaved>2014-01-10T20:48:00Z</o:LastSaved>
24 - <o:Pages>14</o:Pages>
25 - <o:Words>8131</o:Words>
26 - <o:Characters>46350</o:Characters>
23 + <o:LastSaved>2014-03-18T16:19:00Z</o:LastSaved>
24 + <o:Pages>15</o:Pages>
25 + <o:Words>8491</o:Words>
26 + <o:Characters>48402</o:Characters>
27 27 <o:Company>Cisco Systems, Inc.</o:Company>
28 - <o:Lines>386</o:Lines>
29 - <o:Paragraphs>108</o:Paragraphs>
30 - <o:CharactersWithSpaces>54373</o:CharactersWithSpaces>
28 + <o:Lines>403</o:Lines>
29 + <o:Paragraphs>113</o:Paragraphs>
30 + <o:CharactersWithSpaces>56780</o:CharactersWithSpaces>
31 31 <o:Version>14.00</o:Version>
32 32 </o:DocumentProperties>
33 33 <o:OfficeDocumentSettings>
  @@ -867,9 +867,9 @@
867 867 {page:WordSection1;}
868 868 /* List Definitions */
869 869 @list l0
870 - {mso-list-id:962342186;
870 + {mso-list-id:811362191;
871 871 mso-list-type:hybrid;
872 - mso-list-template-ids:-1549364378 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
872 + mso-list-template-ids:914281300 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
873 873 @list l0:level1
874 874 {mso-level-number-format:bullet;
875 875 mso-level-text:\F0B7;
  @@ -934,9 +934,9 @@
934 934 text-indent:-.25in;
935 935 font-family:Wingdings;}
936 936 @list l1
937 - {mso-list-id:1105461771;
937 + {mso-list-id:962342186;
938 938 mso-list-type:hybrid;
939 - mso-list-template-ids:179323962 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
939 + mso-list-template-ids:-1549364378 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
940 940 @list l1:level1
941 941 {mso-level-number-format:bullet;
942 942 mso-level-text:\F0B7;
  @@ -945,144 +945,211 @@
945 945 text-indent:-.25in;
946 946 font-family:Symbol;}
947 947 @list l1:level2
948 + {mso-level-number-format:bullet;
949 + mso-level-text:o;
950 + mso-level-tab-stop:none;
951 + mso-level-number-position:left;
952 + text-indent:-.25in;
953 + font-family:"Courier New";}
954 + @list l1:level3
955 + {mso-level-number-format:bullet;
956 + mso-level-text:\F0A7;
957 + mso-level-tab-stop:none;
958 + mso-level-number-position:left;
959 + text-indent:-.25in;
960 + font-family:Wingdings;}
961 + @list l1:level4
962 + {mso-level-number-format:bullet;
963 + mso-level-text:\F0B7;
964 + mso-level-tab-stop:none;
965 + mso-level-number-position:left;
966 + text-indent:-.25in;
967 + font-family:Symbol;}
968 + @list l1:level5
969 + {mso-level-number-format:bullet;
970 + mso-level-text:o;
971 + mso-level-tab-stop:none;
972 + mso-level-number-position:left;
973 + text-indent:-.25in;
974 + font-family:"Courier New";}
975 + @list l1:level6
976 + {mso-level-number-format:bullet;
977 + mso-level-text:\F0A7;
978 + mso-level-tab-stop:none;
979 + mso-level-number-position:left;
980 + text-indent:-.25in;
981 + font-family:Wingdings;}
982 + @list l1:level7
983 + {mso-level-number-format:bullet;
984 + mso-level-text:\F0B7;
985 + mso-level-tab-stop:none;
986 + mso-level-number-position:left;
987 + text-indent:-.25in;
988 + font-family:Symbol;}
989 + @list l1:level8
990 + {mso-level-number-format:bullet;
991 + mso-level-text:o;
992 + mso-level-tab-stop:none;
993 + mso-level-number-position:left;
994 + text-indent:-.25in;
995 + font-family:"Courier New";}
996 + @list l1:level9
997 + {mso-level-number-format:bullet;
998 + mso-level-text:\F0A7;
999 + mso-level-tab-stop:none;
1000 + mso-level-number-position:left;
1001 + text-indent:-.25in;
1002 + font-family:Wingdings;}
1003 + @list l2
1004 + {mso-list-id:1105461771;
1005 + mso-list-type:hybrid;
1006 + mso-list-template-ids:179323962 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
1007 + @list l2:level1
1008 + {mso-level-number-format:bullet;
1009 + mso-level-text:\F0B7;
1010 + mso-level-tab-stop:none;
1011 + mso-level-number-position:left;
1012 + text-indent:-.25in;
1013 + font-family:Symbol;}
1014 + @list l2:level2
948 1015 {mso-level-tab-stop:1.0in;
949 1016 mso-level-number-position:left;
950 1017 text-indent:-.25in;}
951 - @list l1:level3
1018 + @list l2:level3
952 1019 {mso-level-tab-stop:1.5in;
953 1020 mso-level-number-position:left;
954 1021 text-indent:-.25in;}
955 - @list l1:level4
1022 + @list l2:level4
956 1023 {mso-level-tab-stop:2.0in;
957 1024 mso-level-number-position:left;
958 1025 text-indent:-.25in;}
959 - @list l1:level5
1026 + @list l2:level5
960 1027 {mso-level-tab-stop:2.5in;
961 1028 mso-level-number-position:left;
962 1029 text-indent:-.25in;}
963 - @list l1:level6
1030 + @list l2:level6
964 1031 {mso-level-tab-stop:3.0in;
965 1032 mso-level-number-position:left;
966 1033 text-indent:-.25in;}
967 - @list l1:level7
1034 + @list l2:level7
968 1035 {mso-level-tab-stop:3.5in;
969 1036 mso-level-number-position:left;
970 1037 text-indent:-.25in;}
971 - @list l1:level8
1038 + @list l2:level8
972 1039 {mso-level-tab-stop:4.0in;
973 1040 mso-level-number-position:left;
974 1041 text-indent:-.25in;}
975 - @list l1:level9
1042 + @list l2:level9
976 1043 {mso-level-tab-stop:4.5in;
977 1044 mso-level-number-position:left;
978 1045 text-indent:-.25in;}
979 - @list l2
1046 + @list l3
980 1047 {mso-list-id:1839030946;
981 1048 mso-list-type:hybrid;
982 1049 mso-list-template-ids:1666982938 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
983 - @list l2:level1
1050 + @list l3:level1
984 1051 {mso-level-tab-stop:none;
985 1052 mso-level-number-position:left;
986 1053 text-indent:-.25in;}
987 - @list l2:level2
1054 + @list l3:level2
988 1055 {mso-level-number-format:alpha-lower;
989 1056 mso-level-tab-stop:none;
990 1057 mso-level-number-position:left;
991 1058 text-indent:-.25in;}
992 - @list l2:level3
1059 + @list l3:level3
993 1060 {mso-level-number-format:roman-lower;
994 1061 mso-level-tab-stop:none;
995 1062 mso-level-number-position:right;
996 1063 text-indent:-9.0pt;}
997 - @list l2:level4
1064 + @list l3:level4
998 1065 {mso-level-tab-stop:none;
999 1066 mso-level-number-position:left;
1000 1067 text-indent:-.25in;}
1001 - @list l2:level5
1068 + @list l3:level5
1002 1069 {mso-level-number-format:alpha-lower;
1003 1070 mso-level-tab-stop:none;
1004 1071 mso-level-number-position:left;
1005 1072 text-indent:-.25in;}
1006 - @list l2:level6
1073 + @list l3:level6
1007 1074 {mso-level-number-format:roman-lower;
1008 1075 mso-level-tab-stop:none;
1009 1076 mso-level-number-position:right;
1010 1077 text-indent:-9.0pt;}
1011 - @list l2:level7
1078 + @list l3:level7
1012 1079 {mso-level-tab-stop:none;
1013 1080 mso-level-number-position:left;
1014 1081 text-indent:-.25in;}
1015 - @list l2:level8
1082 + @list l3:level8
1016 1083 {mso-level-number-format:alpha-lower;
1017 1084 mso-level-tab-stop:none;
1018 1085 mso-level-number-position:left;
1019 1086 text-indent:-.25in;}
1020 - @list l2:level9
1087 + @list l3:level9
1021 1088 {mso-level-number-format:roman-lower;
1022 1089 mso-level-tab-stop:none;
1023 1090 mso-level-number-position:right;
1024 1091 text-indent:-9.0pt;}
1025 - @list l3
1092 + @list l4
1026 1093 {mso-list-id:1913545367;
1027 1094 mso-list-type:hybrid;
1028 1095 mso-list-template-ids:198224980 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
1029 - @list l3:level1
1096 + @list l4:level1
1030 1097 {mso-level-number-format:bullet;
1031 1098 mso-level-text:\F0B7;
1032 1099 mso-level-tab-stop:none;
1033 1100 mso-level-number-position:left;
1034 1101 text-indent:-.25in;
1035 1102 font-family:Symbol;}
1036 - @list l3:level2
1103 + @list l4:level2
1037 1104 {mso-level-number-format:bullet;
1038 1105 mso-level-text:o;
1039 1106 mso-level-tab-stop:none;
1040 1107 mso-level-number-position:left;
1041 1108 text-indent:-.25in;
1042 1109 font-family:"Courier New";}
1043 - @list l3:level3
1110 + @list l4:level3
1044 1111 {mso-level-number-format:bullet;
1045 1112 mso-level-text:\F0A7;
1046 1113 mso-level-tab-stop:none;
1047 1114 mso-level-number-position:left;
1048 1115 text-indent:-.25in;
1049 1116 font-family:Wingdings;}
1050 - @list l3:level4
1117 + @list l4:level4
1051 1118 {mso-level-number-format:bullet;
1052 1119 mso-level-text:\F0B7;
1053 1120 mso-level-tab-stop:none;
1054 1121 mso-level-number-position:left;
1055 1122 text-indent:-.25in;
1056 1123 font-family:Symbol;}
1057 - @list l3:level5
1124 + @list l4:level5
1058 1125 {mso-level-number-format:bullet;
1059 1126 mso-level-text:o;
1060 1127 mso-level-tab-stop:none;
1061 1128 mso-level-number-position:left;
1062 1129 text-indent:-.25in;
1063 1130 font-family:"Courier New";}
1064 - @list l3:level6
1131 + @list l4:level6
1065 1132 {mso-level-number-format:bullet;
1066 1133 mso-level-text:\F0A7;
1067 1134 mso-level-tab-stop:none;
1068 1135 mso-level-number-position:left;
1069 1136 text-indent:-.25in;
1070 1137 font-family:Wingdings;}
1071 - @list l3:level7
1138 + @list l4:level7
1072 1139 {mso-level-number-format:bullet;
1073 1140 mso-level-text:\F0B7;
1074 1141 mso-level-tab-stop:none;
1075 1142 mso-level-number-position:left;
1076 1143 text-indent:-.25in;
1077 1144 font-family:Symbol;}
1078 - @list l3:level8
1145 + @list l4:level8
1079 1146 {mso-level-number-format:bullet;
1080 1147 mso-level-text:o;
1081 1148 mso-level-tab-stop:none;
1082 1149 mso-level-number-position:left;
1083 1150 text-indent:-.25in;
1084 1151 font-family:"Courier New";}
1085 - @list l3:level9
1152 + @list l4:level9
1086 1153 {mso-level-number-format:bullet;
1087 1154 mso-level-text:\F0A7;
1088 1155 mso-level-tab-stop:none;
  @@ -1137,15 +1204,19 @@
1137 1204 style='mso-element:field-begin'></span><span
1138 1205 style='mso-spacerun:yes'>&nbsp;</span>TOC \o &quot;2-9&quot; \h \z \t
1139 1206 &quot;Heading 1,1&quot; <span style='mso-element:field-separator'></span><![endif]--><span
1140 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966587">Overview<span
1207 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897685">Overview<span
1141 1208 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1142 1209 text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1143 1210 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1144 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1145 - _Toc376966587 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1211 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1146 1212 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1147 - text-underline:none'>1<!--[if gte mso 9]><xml>
1148 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003500380037000000</w:data>
1213 + text-underline:none'> PAGEREF _Toc382897685 \h </span><span style='color:windowtext;
1214 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1215 + style='mso-element:field-separator'></span></span><![endif]--><span
1216 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1217 + text-underline:none'>2</span><span style='color:windowtext;display:none;
1218 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1219 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600380035000000</w:data>
1149 1220 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1150 1221 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1151 1222 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1155,15 +1226,19 @@
1155 1226 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1156 1227
1157 1228 <p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span
1158 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966588">Requirements/Special
1229 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897686">Requirements/Special
1159 1230 Notes<span style='color:windowtext;display:none;mso-hide:screen;text-decoration:
1160 1231 none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1161 1232 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1162 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1163 - _Toc376966588 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1233 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1234 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1235 + text-underline:none'> PAGEREF _Toc382897686 \h </span><span style='color:windowtext;
1236 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1237 + style='mso-element:field-separator'></span></span><![endif]--><span
1164 1238 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1165 - text-underline:none'>2<!--[if gte mso 9]><xml>
1166 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003500380038000000</w:data>
1239 + text-underline:none'>2</span><span style='color:windowtext;display:none;
1240 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1241 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600380036000000</w:data>
1167 1242 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1168 1243 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1169 1244 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1173,16 +1248,20 @@
1173 1248 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1174 1249
1175 1250 <p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span
1176 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966589">Why
1251 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897687">Why
1177 1252 ODBC, Isn&#8217;t That Going Away?<span style='color:windowtext;display:none;
1178 1253 mso-hide:screen;text-decoration:none;text-underline:none'><span
1179 1254 style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1180 1255 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1181 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1182 - _Toc376966589 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1256 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1183 1257 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1184 - text-underline:none'>2<!--[if gte mso 9]><xml>
1185 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003500380039000000</w:data>
1258 + text-underline:none'> PAGEREF _Toc382897687 \h </span><span style='color:windowtext;
1259 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1260 + style='mso-element:field-separator'></span></span><![endif]--><span
1261 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1262 + text-underline:none'>2</span><span style='color:windowtext;display:none;
1263 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1264 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600380037000000</w:data>
1186 1265 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1187 1266 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1188 1267 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1192,16 +1271,20 @@
1192 1271 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1193 1272
1194 1273 <p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span
1195 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966590">Won&#8217;t
1274 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897688">Won&#8217;t
1196 1275 ODBC Projects Break With Every New Release?<span style='color:windowtext;
1197 1276 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1198 1277 style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1199 1278 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1200 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1201 - _Toc376966590 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1279 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1280 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1281 + text-underline:none'> PAGEREF _Toc382897688 \h </span><span style='color:windowtext;
1282 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1283 + style='mso-element:field-separator'></span></span><![endif]--><span
1202 1284 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1203 - text-underline:none'>3<!--[if gte mso 9]><xml>
1204 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003500390030000000</w:data>
1285 + text-underline:none'>3</span><span style='color:windowtext;display:none;
1286 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1287 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600380038000000</w:data>
1205 1288 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1206 1289 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1207 1290 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1211,16 +1294,20 @@
1211 1294 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1212 1295
1213 1296 <p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span
1214 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966591">Installing
1297 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897689">Installing
1215 1298 and Using the Library in Your Project<span style='color:windowtext;display:
1216 1299 none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1217 1300 style='mso-tab-count:1 dotted'> </span></span><!--[if supportFields]><span
1218 1301 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1219 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1220 - _Toc376966591 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1302 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1221 1303 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1222 - text-underline:none'>3<!--[if gte mso 9]><xml>
1223 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003500390031000000</w:data>
1304 + text-underline:none'> PAGEREF _Toc382897689 \h </span><span style='color:windowtext;
1305 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1306 + style='mso-element:field-separator'></span></span><![endif]--><span
1307 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1308 + text-underline:none'>3</span><span style='color:windowtext;display:none;
1309 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1310 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600380039000000</w:data>
1224 1311 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1225 1312 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1226 1313 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1230,15 +1317,19 @@
1230 1317 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1231 1318
1232 1319 <p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span
1233 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966592">Using
1320 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897690">Using
1234 1321 the .NET ODBC SDK<span style='color:windowtext;display:none;mso-hide:screen;
1235 1322 text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1236 1323 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1237 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1238 - _Toc376966592 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1324 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1325 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1326 + text-underline:none'> PAGEREF _Toc382897690 \h </span><span style='color:windowtext;
1327 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1328 + style='mso-element:field-separator'></span></span><![endif]--><span
1239 1329 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1240 - text-underline:none'>3<!--[if gte mso 9]><xml>
1241 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003500390032000000</w:data>
1330 + text-underline:none'>4</span><span style='color:windowtext;display:none;
1331 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1332 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600390030000000</w:data>
1242 1333 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1243 1334 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1244 1335 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1248,15 +1339,19 @@
1248 1339 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1249 1340
1250 1341 <p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span
1251 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966593">Getting
1342 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897691">Getting
1252 1343 Started<span style='color:windowtext;display:none;mso-hide:screen;text-decoration:
1253 1344 none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1254 1345 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1255 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1256 - _Toc376966593 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1346 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1257 1347 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1258 - text-underline:none'>4<!--[if gte mso 9]><xml>
1259 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003500390033000000</w:data>
1348 + text-underline:none'> PAGEREF _Toc382897691 \h </span><span style='color:windowtext;
1349 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1350 + style='mso-element:field-separator'></span></span><![endif]--><span
1351 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1352 + text-underline:none'>4</span><span style='color:windowtext;display:none;
1353 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1354 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600390031000000</w:data>
1260 1355 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1261 1356 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1262 1357 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1266,16 +1361,20 @@
1266 1361 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1267 1362
1268 1363 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1269 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966594"><span
1364 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897692"><span
1270 1365 style='mso-bidi-font-style:italic'>Task 1: Install the IBM Informix Client SDK.</span><span
1271 1366 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1272 1367 text-underline:none'><span style='mso-tab-count:1 dotted'> </span></span><!--[if supportFields]><span
1273 1368 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1274 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1275 - _Toc376966594 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1369 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1276 1370 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1277 - text-underline:none'>4<!--[if gte mso 9]><xml>
1278 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003500390034000000</w:data>
1371 + text-underline:none'> PAGEREF _Toc382897692 \h </span><span style='color:windowtext;
1372 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1373 + style='mso-element:field-separator'></span></span><![endif]--><span
1374 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1375 + text-underline:none'>4</span><span style='color:windowtext;display:none;
1376 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1377 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600390032000000</w:data>
1279 1378 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1280 1379 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1281 1380 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1285,17 +1384,21 @@
1285 1384 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1286 1385
1287 1386 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1288 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966595"><span
1387 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897693"><span
1289 1388 style='mso-bidi-font-style:italic'>Task 2: Configure a User with the Remote
1290 1389 Administrator and System Administrator roles</span><span style='color:windowtext;
1291 1390 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1292 1391 style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1293 1392 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1294 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1295 - _Toc376966595 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1393 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1394 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1395 + text-underline:none'> PAGEREF _Toc382897693 \h </span><span style='color:windowtext;
1396 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1397 + style='mso-element:field-separator'></span></span><![endif]--><span
1296 1398 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1297 - text-underline:none'>4<!--[if gte mso 9]><xml>
1298 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003500390035000000</w:data>
1399 + text-underline:none'>4</span><span style='color:windowtext;display:none;
1400 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1401 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600390033000000</w:data>
1299 1402 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1300 1403 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1301 1404 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1305,16 +1408,20 @@
1305 1408 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1306 1409
1307 1410 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1308 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966596"><span
1411 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897694"><span
1309 1412 style='mso-bidi-font-style:italic'>Task 3: Set the Database Proxy Service
1310 1413 Shutdown Time</span><span style='color:windowtext;display:none;mso-hide:screen;
1311 1414 text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1312 1415 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1313 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1314 - _Toc376966596 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1416 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1417 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1418 + text-underline:none'> PAGEREF _Toc382897694 \h </span><span style='color:windowtext;
1419 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1420 + style='mso-element:field-separator'></span></span><![endif]--><span
1315 1421 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1316 - text-underline:none'>4<!--[if gte mso 9]><xml>
1317 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003500390036000000</w:data>
1422 + text-underline:none'>4</span><span style='color:windowtext;display:none;
1423 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1424 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600390034000000</w:data>
1318 1425 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1319 1426 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1320 1427 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1324,16 +1431,20 @@
1324 1431 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1325 1432
1326 1433 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1327 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966597"><span
1434 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897695"><span
1328 1435 style='mso-bidi-font-style:italic'>Task 4: Activate the Remote Database Proxy
1329 1436 Service</span><span style='color:windowtext;display:none;mso-hide:screen;
1330 1437 text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1331 1438 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1332 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1333 - _Toc376966597 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1439 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1440 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1441 + text-underline:none'> PAGEREF _Toc382897695 \h </span><span style='color:windowtext;
1442 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1443 + style='mso-element:field-separator'></span></span><![endif]--><span
1334 1444 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1335 - text-underline:none'>4<!--[if gte mso 9]><xml>
1336 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003500390037000000</w:data>
1445 + text-underline:none'>4</span><span style='color:windowtext;display:none;
1446 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1447 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600390035000000</w:data>
1337 1448 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1338 1449 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1339 1450 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1343,15 +1454,42 @@
1343 1454 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1344 1455
1345 1456 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1346 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966598">Logging
1347 - into Connection<span style='color:windowtext;display:none;mso-hide:screen;
1348 - text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1457 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897696">Logging
1458 + into Connection Blocking<span style='color:windowtext;display:none;mso-hide:
1459 + screen;text-decoration:none;text-underline:none'><span style='mso-tab-count:
1460 + 1 dotted'>. </span></span><!--[if supportFields]><span style='color:windowtext;
1461 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1462 + style='mso-element:field-begin'></span></span><span style='color:windowtext;
1463 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'> PAGEREF
1464 + _Toc382897696 \h </span><span style='color:windowtext;display:none;mso-hide:
1465 + screen;text-decoration:none;text-underline:none'><span style='mso-element:field-separator'></span></span><![endif]--><span
1466 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1467 + text-underline:none'>5</span><span style='color:windowtext;display:none;
1468 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1469 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600390036000000</w:data>
1470 + </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1471 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1472 + style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
1473 + style='font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-theme-font:
1474 + minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:
1475 + minor-fareast;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";
1476 + mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1477 +
1478 + <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1479 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897697">Logging
1480 + Into Connection Background<span style='color:windowtext;display:none;
1481 + mso-hide:screen;text-decoration:none;text-underline:none'><span
1482 + style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1483 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1484 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1349 1485 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1350 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1351 - _Toc376966598 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1486 + text-underline:none'> PAGEREF _Toc382897697 \h </span><span style='color:windowtext;
1487 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1488 + style='mso-element:field-separator'></span></span><![endif]--><span
1352 1489 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1353 - text-underline:none'>5<!--[if gte mso 9]><xml>
1354 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003500390038000000</w:data>
1490 + text-underline:none'>5</span><span style='color:windowtext;display:none;
1491 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1492 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600390037000000</w:data>
1355 1493 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1356 1494 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1357 1495 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1361,15 +1499,19 @@
1361 1499 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1362 1500
1363 1501 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1364 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966599">The
1502 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897698">The
1365 1503 DbFetchResult Class<span style='color:windowtext;display:none;mso-hide:screen;
1366 1504 text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1367 1505 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1368 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1369 - _Toc376966599 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1506 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1507 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1508 + text-underline:none'> PAGEREF _Toc382897698 \h </span><span style='color:windowtext;
1509 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1510 + style='mso-element:field-separator'></span></span><![endif]--><span
1370 1511 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1371 - text-underline:none'>5<!--[if gte mso 9]><xml>
1372 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003500390039000000</w:data>
1512 + text-underline:none'>6</span><span style='color:windowtext;display:none;
1513 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1514 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600390038000000</w:data>
1373 1515 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1374 1516 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1375 1517 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1379,16 +1521,20 @@
1379 1521 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1380 1522
1381 1523 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1382 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966600">Logging
1524 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897699">Logging
1383 1525 and Debugging with the SDK<span style='color:windowtext;display:none;
1384 1526 mso-hide:screen;text-decoration:none;text-underline:none'><span
1385 1527 style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1386 1528 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1387 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1388 - _Toc376966600 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1529 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1530 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1531 + text-underline:none'> PAGEREF _Toc382897699 \h </span><span style='color:windowtext;
1532 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1533 + style='mso-element:field-separator'></span></span><![endif]--><span
1389 1534 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1390 - text-underline:none'>6<!--[if gte mso 9]><xml>
1391 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600300030000000</w:data>
1535 + text-underline:none'>6</span><span style='color:windowtext;display:none;
1536 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1537 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003600390039000000</w:data>
1392 1538 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1393 1539 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1394 1540 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1398,15 +1544,19 @@
1398 1544 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1399 1545
1400 1546 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1401 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966601">CUDLI
1547 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897700">CUDLI
1402 1548 Is Your Friend<span style='color:windowtext;display:none;mso-hide:screen;
1403 1549 text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1404 1550 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1405 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1406 - _Toc376966601 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1551 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1407 1552 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1408 - text-underline:none'>7<!--[if gte mso 9]><xml>
1409 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600300031000000</w:data>
1553 + text-underline:none'> PAGEREF _Toc382897700 \h </span><span style='color:windowtext;
1554 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1555 + style='mso-element:field-separator'></span></span><![endif]--><span
1556 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1557 + text-underline:none'>7</span><span style='color:windowtext;display:none;
1558 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1559 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700300030000000</w:data>
1410 1560 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1411 1561 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1412 1562 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1416,15 +1566,19 @@
1416 1566 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1417 1567
1418 1568 <p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span
1419 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966602">Fetching
1569 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897701">Fetching
1420 1570 Data<span style='color:windowtext;display:none;mso-hide:screen;text-decoration:
1421 1571 none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1422 1572 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1423 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1424 - _Toc376966602 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1573 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1574 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1575 + text-underline:none'> PAGEREF _Toc382897701 \h </span><span style='color:windowtext;
1576 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1577 + style='mso-element:field-separator'></span></span><![endif]--><span
1425 1578 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1426 - text-underline:none'>7<!--[if gte mso 9]><xml>
1427 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600300032000000</w:data>
1579 + text-underline:none'>7</span><span style='color:windowtext;display:none;
1580 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1581 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700300031000000</w:data>
1428 1582 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1429 1583 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1430 1584 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1434,16 +1588,19 @@
1434 1588 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1435 1589
1436 1590 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1437 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966603">Data
1591 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897702">Data
1438 1592 Tables and Data Readers<span style='color:windowtext;display:none;mso-hide:
1439 1593 screen;text-decoration:none;text-underline:none'><span style='mso-tab-count:
1440 1594 1 dotted'>. </span></span><!--[if supportFields]><span style='color:windowtext;
1441 1595 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1442 - style='mso-element:field-begin'></span> PAGEREF _Toc376966603 \h <span
1443 - style='mso-element:field-separator'></span></span><![endif]--><span
1444 - style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1445 - text-underline:none'>7<!--[if gte mso 9]><xml>
1446 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600300033000000</w:data>
1596 + style='mso-element:field-begin'></span></span><span style='color:windowtext;
1597 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'> PAGEREF
1598 + _Toc382897702 \h </span><span style='color:windowtext;display:none;mso-hide:
1599 + screen;text-decoration:none;text-underline:none'><span style='mso-element:field-separator'></span></span><![endif]--><span
1600 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1601 + text-underline:none'>7</span><span style='color:windowtext;display:none;
1602 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1603 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700300032000000</w:data>
1447 1604 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1448 1605 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1449 1606 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1453,15 +1610,19 @@
1453 1610 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1454 1611
1455 1612 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1456 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966604">Filling
1613 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897703">Filling
1457 1614 a Data Table<span style='color:windowtext;display:none;mso-hide:screen;
1458 1615 text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1459 1616 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1460 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1461 - _Toc376966604 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1617 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1462 1618 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1463 - text-underline:none'>8<!--[if gte mso 9]><xml>
1464 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600300034000000</w:data>
1619 + text-underline:none'> PAGEREF _Toc382897703 \h </span><span style='color:windowtext;
1620 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1621 + style='mso-element:field-separator'></span></span><![endif]--><span
1622 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1623 + text-underline:none'>8</span><span style='color:windowtext;display:none;
1624 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1625 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700300033000000</w:data>
1465 1626 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1466 1627 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1467 1628 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1471,15 +1632,19 @@
1471 1632 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1472 1633
1473 1634 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1474 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966605">Getting
1635 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897704">Getting
1475 1636 a Count<span style='color:windowtext;display:none;mso-hide:screen;text-decoration:
1476 1637 none;text-underline:none'><span style='mso-tab-count:1 dotted'> </span></span><!--[if supportFields]><span
1477 1638 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1478 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1479 - _Toc376966605 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1639 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1480 1640 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1481 - text-underline:none'>8<!--[if gte mso 9]><xml>
1482 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600300035000000</w:data>
1641 + text-underline:none'> PAGEREF _Toc382897704 \h </span><span style='color:windowtext;
1642 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1643 + style='mso-element:field-separator'></span></span><![endif]--><span
1644 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1645 + text-underline:none'>8</span><span style='color:windowtext;display:none;
1646 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1647 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700300034000000</w:data>
1483 1648 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1484 1649 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1485 1650 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1489,15 +1654,19 @@
1489 1654 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1490 1655
1491 1656 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1492 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966606">Getting
1657 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897705">Getting
1493 1658 a Single Value<span style='color:windowtext;display:none;mso-hide:screen;
1494 1659 text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1495 1660 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1496 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1497 - _Toc376966606 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1661 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1662 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1663 + text-underline:none'> PAGEREF _Toc382897705 \h </span><span style='color:windowtext;
1664 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1665 + style='mso-element:field-separator'></span></span><![endif]--><span
1498 1666 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1499 - text-underline:none'>9<!--[if gte mso 9]><xml>
1500 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600300036000000</w:data>
1667 + text-underline:none'>9</span><span style='color:windowtext;display:none;
1668 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1669 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700300035000000</w:data>
1501 1670 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1502 1671 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1503 1672 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1507,15 +1676,19 @@
1507 1676 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1508 1677
1509 1678 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1510 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966607">Filling
1679 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897706">Filling
1511 1680 a Data Reader<span style='color:windowtext;display:none;mso-hide:screen;
1512 1681 text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'> </span></span><!--[if supportFields]><span
1513 1682 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1514 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1515 - _Toc376966607 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1683 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1684 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1685 + text-underline:none'> PAGEREF _Toc382897706 \h </span><span style='color:windowtext;
1686 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1687 + style='mso-element:field-separator'></span></span><![endif]--><span
1516 1688 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1517 - text-underline:none'>9<!--[if gte mso 9]><xml>
1518 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600300037000000</w:data>
1689 + text-underline:none'>9</span><span style='color:windowtext;display:none;
1690 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1691 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700300036000000</w:data>
1519 1692 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1520 1693 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1521 1694 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1525,15 +1698,19 @@
1525 1698 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1526 1699
1527 1700 <p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span
1528 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966608">Stored
1701 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897707">Stored
1529 1702 Procedure Overview<span style='color:windowtext;display:none;mso-hide:screen;
1530 1703 text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1531 1704 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1532 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1533 - _Toc376966608 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1705 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1706 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1707 + text-underline:none'> PAGEREF _Toc382897707 \h </span><span style='color:windowtext;
1708 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1709 + style='mso-element:field-separator'></span></span><![endif]--><span
1534 1710 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1535 - text-underline:none'>10<!--[if gte mso 9]><xml>
1536 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600300038000000</w:data>
1711 + text-underline:none'>10</span><span style='color:windowtext;display:none;
1712 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1713 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700300037000000</w:data>
1537 1714 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1538 1715 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1539 1716 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1543,16 +1720,19 @@
1543 1720 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1544 1721
1545 1722 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1546 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966609">Stored
1723 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897708">Stored
1547 1724 Procedure Naming Strategy<span style='color:windowtext;display:none;mso-hide:
1548 1725 screen;text-decoration:none;text-underline:none'><span style='mso-tab-count:
1549 1726 1 dotted'>. </span></span><!--[if supportFields]><span style='color:windowtext;
1550 1727 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1551 - style='mso-element:field-begin'></span> PAGEREF _Toc376966609 \h <span
1552 - style='mso-element:field-separator'></span></span><![endif]--><span
1553 - style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1554 - text-underline:none'>10<!--[if gte mso 9]><xml>
1555 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600300039000000</w:data>
1728 + style='mso-element:field-begin'></span></span><span style='color:windowtext;
1729 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'> PAGEREF
1730 + _Toc382897708 \h </span><span style='color:windowtext;display:none;mso-hide:
1731 + screen;text-decoration:none;text-underline:none'><span style='mso-element:field-separator'></span></span><![endif]--><span
1732 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1733 + text-underline:none'>10</span><span style='color:windowtext;display:none;
1734 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1735 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700300038000000</w:data>
1556 1736 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1557 1737 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1558 1738 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1562,16 +1742,20 @@
1562 1742 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1563 1743
1564 1744 <p class=MsoToc3 style='tab-stops:right dotted 431.5pt'><span
1565 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966610">Return
1745 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897709">Return
1566 1746 Values from Stored Procedures<span style='color:windowtext;display:none;
1567 1747 mso-hide:screen;text-decoration:none;text-underline:none'><span
1568 1748 style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1569 1749 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1570 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1571 - _Toc376966610 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1750 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1751 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1752 + text-underline:none'> PAGEREF _Toc382897709 \h </span><span style='color:windowtext;
1753 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1754 + style='mso-element:field-separator'></span></span><![endif]--><span
1572 1755 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1573 - text-underline:none'>11<!--[if gte mso 9]><xml>
1574 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600310030000000</w:data>
1756 + text-underline:none'>11</span><span style='color:windowtext;display:none;
1757 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1758 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700300039000000</w:data>
1575 1759 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1576 1760 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1577 1761 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1581,15 +1765,19 @@
1581 1765 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1582 1766
1583 1767 <p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span
1584 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966611">Changing
1768 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897710">Changing
1585 1769 Database Focus<span style='color:windowtext;display:none;mso-hide:screen;
1586 1770 text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1587 1771 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1588 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1589 - _Toc376966611 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1772 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1773 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1774 + text-underline:none'> PAGEREF _Toc382897710 \h </span><span style='color:windowtext;
1775 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1776 + style='mso-element:field-separator'></span></span><![endif]--><span
1590 1777 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1591 - text-underline:none'>12<!--[if gte mso 9]><xml>
1592 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600310031000000</w:data>
1778 + text-underline:none'>12</span><span style='color:windowtext;display:none;
1779 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1780 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700310030000000</w:data>
1593 1781 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1594 1782 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1595 1783 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1599,15 +1787,19 @@
1599 1787 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1600 1788
1601 1789 <p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span
1602 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966612">Checking
1790 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897711">Checking
1603 1791 Connection Version<span style='color:windowtext;display:none;mso-hide:screen;
1604 1792 text-decoration:none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1605 1793 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1606 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1607 - _Toc376966612 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1794 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1795 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1796 + text-underline:none'> PAGEREF _Toc382897711 \h </span><span style='color:windowtext;
1797 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1798 + style='mso-element:field-separator'></span></span><![endif]--><span
1608 1799 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1609 - text-underline:none'>13<!--[if gte mso 9]><xml>
1610 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600310032000000</w:data>
1800 + text-underline:none'>13</span><span style='color:windowtext;display:none;
1801 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1802 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700310031000000</w:data>
1611 1803 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1612 1804 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1613 1805 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1617,16 +1809,19 @@
1617 1809 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1618 1810
1619 1811 <p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span
1620 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966613">Checking
1812 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897712">Checking
1621 1813 for Extension Conflicts<span style='color:windowtext;display:none;mso-hide:
1622 1814 screen;text-decoration:none;text-underline:none'><span style='mso-tab-count:
1623 1815 1 dotted'>. </span></span><!--[if supportFields]><span style='color:windowtext;
1624 1816 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1625 - style='mso-element:field-begin'></span> PAGEREF _Toc376966613 \h <span
1626 - style='mso-element:field-separator'></span></span><![endif]--><span
1627 - style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1628 - text-underline:none'>13<!--[if gte mso 9]><xml>
1629 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600310033000000</w:data>
1817 + style='mso-element:field-begin'></span></span><span style='color:windowtext;
1818 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'> PAGEREF
1819 + _Toc382897712 \h </span><span style='color:windowtext;display:none;mso-hide:
1820 + screen;text-decoration:none;text-underline:none'><span style='mso-element:field-separator'></span></span><![endif]--><span
1821 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1822 + text-underline:none'>13</span><span style='color:windowtext;display:none;
1823 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1824 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700310032000000</w:data>
1630 1825 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1631 1826 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1632 1827 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1636,16 +1831,42 @@
1636 1831 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1637 1832
1638 1833 <p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span
1639 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966614">Finding
1834 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897713">Finding
1640 1835 Objects by Name, Extension and/or Alias<span style='color:windowtext;
1641 1836 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1642 1837 style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1643 1838 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1644 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1645 - _Toc376966614 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1839 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1646 1840 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1647 - text-underline:none'>13<!--[if gte mso 9]><xml>
1648 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600310034000000</w:data>
1841 + text-underline:none'> PAGEREF _Toc382897713 \h </span><span style='color:windowtext;
1842 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1843 + style='mso-element:field-separator'></span></span><![endif]--><span
1844 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1845 + text-underline:none'>13</span><span style='color:windowtext;display:none;
1846 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1847 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700310033000000</w:data>
1848 + </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1849 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1850 + style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
1851 + style='font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-theme-font:
1852 + minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:
1853 + minor-fareast;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";
1854 + mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1855 +
1856 + <p class=MsoToc2 style='tab-stops:right dotted 431.5pt'><span
1857 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897714">Using
1858 + the ComboBox Helper Class<span style='color:windowtext;display:none;mso-hide:
1859 + screen;text-decoration:none;text-underline:none'><span style='mso-tab-count:
1860 + 1 dotted'>. </span></span><!--[if supportFields]><span style='color:windowtext;
1861 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1862 + style='mso-element:field-begin'></span></span><span style='color:windowtext;
1863 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'> PAGEREF
1864 + _Toc382897714 \h </span><span style='color:windowtext;display:none;mso-hide:
1865 + screen;text-decoration:none;text-underline:none'><span style='mso-element:field-separator'></span></span><![endif]--><span
1866 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1867 + text-underline:none'>14</span><span style='color:windowtext;display:none;
1868 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1869 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700310034000000</w:data>
1649 1870 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1650 1871 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1651 1872 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1655,15 +1876,19 @@
1655 1876 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1656 1877
1657 1878 <p class=MsoToc1 style='tab-stops:right dotted 431.5pt'><span
1658 - class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc376966615">Revision
1879 + class=MsoHyperlink><span style='mso-no-proof:yes'><a href="#_Toc382897715">Revision
1659 1880 History<span style='color:windowtext;display:none;mso-hide:screen;text-decoration:
1660 1881 none;text-underline:none'><span style='mso-tab-count:1 dotted'>. </span></span><!--[if supportFields]><span
1661 1882 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1662 - text-underline:none'><span style='mso-element:field-begin'></span> PAGEREF
1663 - _Toc376966615 \h <span style='mso-element:field-separator'></span></span><![endif]--><span
1883 + text-underline:none'><span style='mso-element:field-begin'></span></span><span
1884 + style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1885 + text-underline:none'> PAGEREF _Toc382897715 \h </span><span style='color:windowtext;
1886 + display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1887 + style='mso-element:field-separator'></span></span><![endif]--><span
1664 1888 style='color:windowtext;display:none;mso-hide:screen;text-decoration:none;
1665 - text-underline:none'>14<!--[if gte mso 9]><xml>
1666 - <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300370036003900360036003600310035000000</w:data>
1889 + text-underline:none'>15</span><span style='color:windowtext;display:none;
1890 + mso-hide:screen;text-decoration:none;text-underline:none'><!--[if gte mso 9]><xml>
1891 + <w:data>08D0C9EA79F9BACE118C8200AA004BA90B02000000080000000E0000005F0054006F0063003300380032003800390037003700310035000000</w:data>
1667 1892 </xml><![endif]--></span><!--[if supportFields]><span style='color:windowtext;
1668 1893 display:none;mso-hide:screen;text-decoration:none;text-underline:none'><span
1669 1894 style='mso-element:field-end'></span></span><![endif]--></a></span></span><span
  @@ -1673,8 +1898,8 @@
1673 1898 mso-bidi-theme-font:minor-bidi;mso-no-proof:yes'><o:p></o:p></span></p>
1674 1899
1675 1900 <h1><!--[if supportFields]><span style='mso-element:field-end'></span><![endif]--><a
1676 - name="_Toc376966587"></a><a name="_Toc534430892"><span style='mso-bookmark:
1677 - _Toc376966587'>Overvie</span></a><span style='mso-bookmark:_Toc376966587'>w</span></h1>
1901 + name="_Toc382897685"></a><a name="_Toc534430892"><span style='mso-bookmark:
1902 + _Toc382897685'>Overvie</span></a><span style='mso-bookmark:_Toc382897685'>w</span></h1>
1678 1903
1679 1904 <p class=MsoNormal><span style='font-size:8.0pt'>The .NET SDK library for the
1680 1905 Unity Connection ODBC interfaces is a set of library code intended to make
  @@ -1696,9 +1921,9 @@
1696 1921 toolset for just about any application type you wish to create against
1697 1922 Connection.<o:p></o:p></span></p>
1698 1923
1699 - <h1><a name="_Toc534430893"></a><a name="_Toc6476430"></a><a name="_Toc24010850"></a><a
1700 - name="_Toc376966588"><span style='mso-bookmark:_Toc24010850'><span
1701 - style='mso-bookmark:_Toc6476430'><span style='mso-bookmark:_Toc534430893'>Requirements/Special
1924 + <h1><a name="_Toc382897686"></a><a name="_Toc24010850"></a><a name="_Toc6476430"></a><a
1925 + name="_Toc534430893"><span style='mso-bookmark:_Toc6476430'><span
1926 + style='mso-bookmark:_Toc24010850'><span style='mso-bookmark:_Toc382897686'>Requirements/Special
1702 1927 Notes</span></span></span></a></h1>
1703 1928
1704 1929 <p class=MsoNormal><span style='font-size:8.0pt'>The .NET ODBC SDK is written
  @@ -1729,7 +1954,7 @@
1729 1954 &#8211; which may happen if there&#8217;s demand, currently testing is limited
1730 1955 to Windows platforms only.<o:p></o:p></span></p>
1731 1956
1732 - <h1><a name="_Toc376966589">Why ODBC, Isn&#8217;t That Going Away?</a></h1>
1957 + <h1><a name="_Toc382897687">Why ODBC, Isn&#8217;t That Going Away?</a></h1>
1733 1958
1734 1959 <p class=MsoNormal><span style='font-size:8.0pt'>I get this one all the time so
1735 1960 let me just address it here. There are a number of very good reasons for doing
  @@ -1845,7 +2070,7 @@
1845 2070 style='mso-spacerun:yes'>&nbsp; </span>But when you need to move a lot of data
1846 2071 fast, it simply cannot be beat.<o:p></o:p></span></p>
1847 2072
1848 - <h1><a name="_Toc376966590">Won&#8217;t ODBC Projects Break With Every New
2073 + <h1><a name="_Toc382897688">Won&#8217;t ODBC Projects Break With Every New
1849 2074 Release?</a></h1>
1850 2075
1851 2076 <p class=MsoNormal><span style='font-size:8.0pt'>This is the 2<sup>nd</sup>
  @@ -1860,9 +2085,9 @@
1860 2085 style='font-size:8.0pt'>Longer answer</span></b><span style='font-size:8.0pt'>:
1861 2086 If you use views (instead of tables) when fetching data and always (always!)
1862 2087 update/create/delete via stored procedures you will never have a problem
1863 - here.<span style='mso-spacerun:yes'>&nbsp; </span>I&#8217;ve been writing ODBC based
1864 - tools for Unity and Unity Connection for 15+ years now and have never once
1865 - gotten burned by a data model change between versions.<span
2088 + here.<span style='mso-spacerun:yes'>&nbsp; </span>I&#8217;ve been writing ODBC
2089 + based tools for Unity and Unity Connection for 15+ years now and have never
2090 + once gotten burned by a data model change between versions.<span
1866 2091 style='mso-spacerun:yes'>&nbsp; </span>Not once. <o:p></o:p></span></p>
1867 2092
1868 2093 <p class=MsoNormal><span style='font-size:8.0pt'>We always make sure views and
  @@ -1873,7 +2098,7 @@
1873 2098 perhaps 2 instances) the item is always just deprecated in the data dictionary,
1874 2099 it&#8217;s not actually removed from the table definition itself.<o:p></o:p></span></p>
1875 2100
1876 - <h1><a name="_Toc376966591">Installing and Using the Library in Your Project</a></h1>
2101 + <h1><a name="_Toc382897689">Installing and Using the Library in Your Project</a></h1>
1877 2102
1878 2103 <p class=Default><b><span style='font-size:11.5pt'>The Easy Way </span></b><span
1879 2104 style='font-size:11.5pt'><o:p></o:p></span></p>
  @@ -1947,8 +2172,8 @@
1947 2172 Framework 4&#8221; setting. Be sure your project is configured for this or
1948 2173 you&#8217;ll get build errors.</span></p>
1949 2174
1950 - <h1><a name="_Toc376966592"></a><a name="_Watching_the_traffic"></a><span
1951 - style='mso-bookmark:_Toc376966592'>Using the .NET ODBC SDK</span></h1>
2175 + <h1><a name="_Toc382897690"></a><a name="_Watching_the_traffic"></a><span
2176 + style='mso-bookmark:_Toc382897690'>Using the .NET ODBC SDK</span></h1>
1952 2177
1953 2178 <p class=MsoNormal><span style='font-size:8.0pt'>This document uses a
1954 2179 &#8220;task based&#8221; approach to demonstrating the use of the library
  @@ -1961,30 +2186,30 @@
1961 2186 with a simple &#8220;show me&#8221; approach so that&#8217;s what I endeavor to
1962 2187 do here.<o:p></o:p></span></p>
1963 2188
1964 - <h2 style='tab-stops:110.8pt'><a name="_Toc376966593">Getting Started</a></h2>
2189 + <h2 style='tab-stops:110.8pt'><a name="_Toc382897691">Getting Started</a></h2>
1965 2190
1966 2191 <p class=MsoNormal><span style='font-size:8.0pt'>To attach to Unity Connection
1967 2192 from you Windows client you need to make sure you have:<o:p></o:p></span></p>
1968 2193
1969 - <p class=MsoListParagraphCxSpFirst style='text-indent:-.25in;mso-list:l2 level1 lfo2'><![if !supportLists]><span
2194 + <p class=MsoListParagraphCxSpFirst style='text-indent:-.25in;mso-list:l3 level1 lfo2'><![if !supportLists]><span
1970 2195 style='font-size:8.0pt;mso-fareast-font-family:Arial;mso-bidi-font-family:Arial'><span
1971 2196 style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;
1972 2197 </span></span></span><![endif]><span style='font-size:8.0pt'>The IBM Client SDK
1973 2198 needs to be installed (at least the ADO .NET driver at a minimum)<o:p></o:p></span></p>
1974 2199
1975 - <p class=MsoListParagraphCxSpMiddle style='text-indent:-.25in;mso-list:l2 level1 lfo2'><![if !supportLists]><span
2200 + <p class=MsoListParagraphCxSpMiddle style='text-indent:-.25in;mso-list:l3 level1 lfo2'><![if !supportLists]><span
1976 2201 style='font-size:8.0pt;mso-fareast-font-family:Arial;mso-bidi-font-family:Arial'><span
1977 2202 style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;
1978 2203 </span></span></span><![endif]><span style='font-size:8.0pt'>The database proxy
1979 2204 service turned on<o:p></o:p></span></p>
1980 2205
1981 - <p class=MsoListParagraphCxSpMiddle style='text-indent:-.25in;mso-list:l2 level1 lfo2'><![if !supportLists]><span
2206 + <p class=MsoListParagraphCxSpMiddle style='text-indent:-.25in;mso-list:l3 level1 lfo2'><![if !supportLists]><span
1982 2207 style='font-size:8.0pt;mso-fareast-font-family:Arial;mso-bidi-font-family:Arial'><span
1983 2208 style='mso-list:Ignore'>3.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;
1984 2209 </span></span></span><![endif]><span style='font-size:8.0pt'>An account
1985 2210 configured with the remote administrator role<o:p></o:p></span></p>
1986 2211
1987 - <p class=MsoListParagraphCxSpLast style='text-indent:-.25in;mso-list:l2 level1 lfo2'><![if !supportLists]><span
2212 + <p class=MsoListParagraphCxSpLast style='text-indent:-.25in;mso-list:l3 level1 lfo2'><![if !supportLists]><span
1988 2213 style='font-size:8.0pt;mso-fareast-font-family:Arial;mso-bidi-font-family:Arial'><span
1989 2214 style='mso-list:Ignore'>4.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;
1990 2215 </span></span></span><![endif]><span style='font-size:8.0pt'>Port 20532 needs
  @@ -1996,7 +2221,7 @@
1996 2221 <p class=MsoNormal><span style='font-size:8.0pt'>The following 4 tasks need to
1997 2222 be done.<o:p></o:p></span></p>
1998 2223
1999 - <h3><a name="_Toc359835382"></a><a name="_Toc376966594"><span style='mso-bookmark:
2224 + <h3><a name="_Toc359835382"></a><a name="_Toc382897692"><span style='mso-bookmark:
2000 2225 _Toc359835382'><span style='font-size:8.0pt;color:black;font-style:normal;
2001 2226 mso-bidi-font-style:italic'>Task 1: Install the IBM Informix Client SDK.</span></span></a><span
2002 2227 style='mso-bookmark:_Toc359835382'><span style='font-size:8.0pt;color:black;
  @@ -2022,17 +2247,17 @@
2022 2247 style='font-size:8.0pt'>http://CiscoUnityTools.com</span></span><span
2023 2248 style='mso-bookmark:_Toc359835382'></span></a><span style='mso-bookmark:_Toc359835382'><span
2024 2249 style='font-size:8.0pt'> for Unity Connection are strictly 32 bit to keep
2025 - install and testing simple &#8211; however you can download and install the 32 or
2026 - 64 bit drivers as you prefer.<span style='mso-spacerun:yes'>&nbsp; </span>The
2027 - SDK is compiled to work with either version.<span
2250 + install and testing simple &#8211; however you can download and install the 32
2251 + or 64 bit drivers as you prefer.<span style='mso-spacerun:yes'>&nbsp;
2252 + </span>The SDK is compiled to work with either version.<span
2028 2253 style='mso-spacerun:yes'>&nbsp; </span>The need for 64 bit drivers is dubious,
2029 2254 you will not experience any increase in speed or really any other advantage
2030 2255 which is one of the reasons we keep our tools simple with 32 bit only.<o:p></o:p></span></span></p>
2031 2256
2032 - <h3><span style='mso-bookmark:_Toc359835382'><a name="_Toc376966595"><span
2257 + <h3><span style='mso-bookmark:_Toc359835382'><a name="_Toc382897693"><span
2033 2258 style='font-size:8.0pt;color:black;font-style:normal;mso-bidi-font-style:italic'>Task
2034 2259 2: Configure a User with the Remote Administrator and System Administrator
2035 - roles</span></a></span><span style='mso-bookmark:_Toc376966595'></span><span
2260 + roles</span></a></span><span style='mso-bookmark:_Toc382897693'></span><span
2036 2261 style='mso-bookmark:_Toc359835382'></span><span style='font-size:8.0pt;
2037 2262 color:black;mso-bidi-font-style:italic'><o:p></o:p></span></h3>
2038 2263
  @@ -2080,12 +2305,12 @@
2080 2305 updates to users those two are necessary.<o:p></o:p></span></p>
2081 2306
2082 2307 <h3 style='orphans: auto;text-align:start;widows: auto;-webkit-text-stroke-width: 0px;
2083 - word-spacing:0px'><a name="_Toc376966596"></a><a name="_Toc359835383"></a><a
2084 - name="_Toc239124999"></a><span style='mso-bookmark:_Toc376966596'><span
2308 + word-spacing:0px'><a name="_Toc382897694"></a><a name="_Toc359835383"></a><a
2309 + name="_Toc239124999"></a><span style='mso-bookmark:_Toc382897694'><span
2085 2310 style='mso-bookmark:_Toc359835383'><span style='font-size:8.0pt;color:black;
2086 2311 font-style:normal;mso-bidi-font-style:italic'>Task 3: Set the Database Proxy
2087 2312 Service Shutdown Time</span></span></span><span style='mso-bookmark:_Toc359835383'></span><span
2088 - style='mso-bookmark:_Toc376966596'></span><span style='font-size:8.0pt;
2313 + style='mso-bookmark:_Toc382897694'></span><span style='font-size:8.0pt;
2089 2314 color:black;mso-bidi-font-style:italic'><o:p></o:p></span></h3>
2090 2315
2091 2316 <p class=MsoNormal style='margin-left:.5in;orphans: auto;text-align:start;
  @@ -2108,12 +2333,12 @@
2108 2333 number of days configured here the remote database proxy service will shut
2109 2334 down.&nbsp;<span class=apple-converted-space>&nbsp;</span><o:p></o:p></span></p>
2110 2335
2111 - <h3><a name="_Toc376966597"></a><a name="_Toc359835384"></a><a
2112 - name="_Toc239125000"></a><span style='mso-bookmark:_Toc376966597'><span
2336 + <h3><a name="_Toc382897695"></a><a name="_Toc359835384"></a><a
2337 + name="_Toc239125000"></a><span style='mso-bookmark:_Toc382897695'><span
2113 2338 style='mso-bookmark:_Toc359835384'><span style='font-size:8.0pt;color:black;
2114 2339 font-style:normal;mso-bidi-font-style:italic'>Task 4: Activate the Remote
2115 2340 Database Proxy Service</span></span></span><span style='mso-bookmark:_Toc359835384'></span><span
2116 - style='mso-bookmark:_Toc376966597'></span><span style='font-size:8.0pt;
2341 + style='mso-bookmark:_Toc382897695'></span><span style='font-size:8.0pt;
2117 2342 color:black;mso-bidi-font-style:italic'><o:p></o:p></span></h3>
2118 2343
2119 2344 <p class=MsoNormal style='margin-left:.75in;text-indent:-.25in;orphans: auto;
  @@ -2160,14 +2385,12 @@
2160 2385 above or if you restart the server unless you&#8217;re running Unity Connection
2161 2386 10.0 or later in which case there is no timer.<o:p></o:p></span></p>
2162 2387
2163 - <h3><a name="_Toc376966598"><span class=Heading3Char><span style='font-family:
2388 + <h3><a name="_Toc382897696"><span class=Heading3Char><span style='font-family:
2164 2389 "Arial","sans-serif";mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:
2165 2390 minor-fareast;color:black;mso-themecolor:text1;mso-bidi-font-weight:normal'>Logging
2166 - into Connection</span></span></a><span class=Heading3Char><span
2167 - style='font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman";
2168 - mso-fareast-theme-font:minor-fareast;color:black;mso-themecolor:text1;
2169 - mso-bidi-font-weight:normal'> Blocking</span></span><span style='color:black;
2170 - mso-themecolor:text1;font-weight:normal;mso-bidi-font-weight:bold'><o:p></o:p></span></h3>
2391 + into Connection Blocking</span></span></a><span style='mso-bookmark:_Toc382897696'></span><span
2392 + style='color:black;mso-themecolor:text1;font-weight:normal;mso-bidi-font-weight:
2393 + bold'><o:p></o:p></span></h3>
2171 2394
2172 2395 <p class=MsoNormal><span style='font-size:8.0pt'>The SDK is designed to support
2173 2396 multiply threaded applications that may be attached to more than one Connection
  @@ -2278,302 +2501,264 @@
2278 2501 style='mso-spacerun:yes'>&nbsp; </span>We&#8217;ll look at what&#8217;s
2279 2502 returned by that method (and most methods in the SDK) in the next section.<o:p></o:p></span></p>
2280 2503
2281 - <h3><a name="_Toc376966599"></a><a name="_The_WebCallResult_Class"></a><span
2282 - style='mso-bookmark:_Toc376966599'>Logging <span class=GramE>Into</span>
2504 + <h3><a name="_Toc382897697"></a><a name="_The_WebCallResult_Class"></a><span
2505 + style='mso-bookmark:_Toc382897697'>Logging <span class=GramE>Into</span>
2283 2506 Connection Background</span></h3>
2284 2507
2285 - <p class=MsoNormal><span style='mso-bookmark:_Toc376966599'><span
2286 - style='font-size:8.0pt'>You can also have the <span class=SpellE><b
2287 - style='mso-bidi-font-weight:normal'>UnityConnectionServerOdbcSdk</b></span>
2508 + <p class=MsoNormal><span style='font-size:8.0pt'>You can also have the <span
2509 + class=SpellE><b style='mso-bidi-font-weight:normal'>UnityConnectionServerOdbcSdk</b></span>
2288 2510 class login on a background thread and raise server connection status changes
2289 - to you.<span style='mso-spacerun:yes'>&nbsp; </span>This can be handy if you&#8217;re
2290 - connecting to several Unity Connection servers and you want to provide a nice
2291 - grid of servers and their current login status (pending, logging in, login
2292 - successful or login failed).<span style='mso-spacerun:yes'>&nbsp; </span>Here&#8217;s
2293 - a simple example of how to do that.<o:p></o:p></span></span></p>
2511 + to you.<span style='mso-spacerun:yes'>&nbsp; </span>This can be handy if
2512 + you&#8217;re connecting to several Unity Connection servers and you want to
2513 + provide a nice grid of servers and their current login status (pending, logging
2514 + in, login successful or login failed).<span style='mso-spacerun:yes'>&nbsp;
2515 + </span>Here&#8217;s a simple example of how to do that.<o:p></o:p></span></p>
2294 2516
2295 - <p class=MsoNormal><span style='mso-bookmark:_Toc376966599'><span
2296 - style='font-size:8.0pt'><o:p>&nbsp;</o:p></span></span></p>
2517 + <p class=MsoNormal><span style='font-size:8.0pt'><o:p>&nbsp;</o:p></span></p>
2297 2518
2298 2519 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2299 2520 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2300 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2301 - font-family:Consolas;color:black;background:white;mso-highlight:white'>_server
2302 - = </span></span><span style='mso-bookmark:_Toc376966599'><span
2303 - style='font-size:8.5pt;font-family:Consolas;color:blue;background:white;
2304 - mso-highlight:white'>new</span></span><span style='mso-bookmark:_Toc376966599'><span
2521 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2522 + white;mso-highlight:white'>_server = </span><span style='font-size:8.5pt;
2523 + font-family:Consolas;color:blue;background:white;mso-highlight:white'>new</span><span
2305 2524 style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2306 - mso-highlight:white'> </span></span><span style='mso-bookmark:_Toc376966599'><span
2307 - class=SpellE><span class=GramE><span style='font-size:8.5pt;font-family:Consolas;
2308 - color:#2B91AF;background:white;mso-highlight:white'>UnityConnectionServerOdbcSdk</span></span></span></span><span
2309 - style='mso-bookmark:_Toc376966599'><span class=GramE><span style='font-size:
2310 - 8.5pt;font-family:Consolas;color:black;background:white;mso-highlight:white'>(</span></span></span><span
2311 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2312 - Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;<span
2313 - class=SpellE>TestAppName</span>&quot;</span></span><span style='mso-bookmark:
2314 - _Toc376966599'><span style='font-size:8.5pt;font-family:Consolas;color:black;
2315 - background:white;mso-highlight:white'>);<o:p></o:p></span></span></p>
2525 + mso-highlight:white'> </span><span class=SpellE><span class=GramE><span
2526 + style='font-size:8.5pt;font-family:Consolas;color:#2B91AF;background:white;
2527 + mso-highlight:white'>UnityConnectionServerOdbcSdk</span></span></span><span
2528 + class=GramE><span style='font-size:8.5pt;font-family:Consolas;color:black;
2529 + background:white;mso-highlight:white'>(</span></span><span style='font-size:
2530 + 8.5pt;font-family:Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;<span
2531 + class=SpellE>TestAppName</span>&quot;</span><span style='font-size:8.5pt;
2532 + font-family:Consolas;color:black;background:white;mso-highlight:white'>);<o:p></o:p></span></p>
2316 2533
2317 2534 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2318 2535 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2319 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2320 - font-family:Consolas;color:black;background:white;mso-highlight:white'><o:p>&nbsp;</o:p></span></span></p>
2536 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2537 + white;mso-highlight:white'><o:p>&nbsp;</o:p></span></p>
2321 2538
2322 2539 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2323 2540 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2324 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2325 - font-family:Consolas;color:black;background:white;mso-highlight:white'>_<span
2326 - class=SpellE>server.ConnectionStatusChangeEvent</span> += <span class=SpellE>ServerOnConnectionStatusChange</span>;<o:p></o:p></span></span></p>
2541 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2542 + white;mso-highlight:white'>_<span class=SpellE>server.ConnectionStatusChangeEvent</span>
2543 + += <span class=SpellE>ServerOnConnectionStatusChange</span>;<o:p></o:p></span></p>
2327 2544
2328 2545 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2329 2546 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2330 - none'><span style='mso-bookmark:_Toc376966599'><span class=SpellE><span
2331 - class=GramE><span style='font-size:8.5pt;font-family:Consolas;color:blue;
2332 - background:white;mso-highlight:white'>bool</span></span></span></span><span
2333 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2334 - Consolas;color:black;background:white;mso-highlight:white'> res = _<span
2335 - class=SpellE>server.LoginDatabaseBackground</span>(</span></span><span
2336 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2337 - Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;192.168.0.195&quot;</span></span><span
2338 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2339 - Consolas;color:black;background:white;mso-highlight:white'>,</span></span><span
2340 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2341 - Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;dbdude&quot;</span></span><span
2342 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2343 - Consolas;color:black;background:white;mso-highlight:white'>, </span></span><span
2344 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2345 - Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;<span
2346 - class=SpellE>ecsbulab</span>&quot;</span></span><span style='mso-bookmark:_Toc376966599'><span
2547 + none'><span class=SpellE><span class=GramE><span style='font-size:8.5pt;
2548 + font-family:Consolas;color:blue;background:white;mso-highlight:white'>bool</span></span></span><span
2549 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2550 + mso-highlight:white'> res = _<span class=SpellE>server.LoginDatabaseBackground</span>(</span><span
2551 + style='font-size:8.5pt;font-family:Consolas;color:#A31515;background:white;
2552 + mso-highlight:white'>&quot;192.168.0.195&quot;</span><span style='font-size:
2553 + 8.5pt;font-family:Consolas;color:black;background:white;mso-highlight:white'>,</span><span
2554 + style='font-size:8.5pt;font-family:Consolas;color:#A31515;background:white;
2555 + mso-highlight:white'>&quot;dbdude&quot;</span><span style='font-size:8.5pt;
2556 + font-family:Consolas;color:black;background:white;mso-highlight:white'>, </span><span
2557 + style='font-size:8.5pt;font-family:Consolas;color:#A31515;background:white;
2558 + mso-highlight:white'>&quot;<span class=SpellE>ecsbulab</span>&quot;</span><span
2347 2559 style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2348 - mso-highlight:white'> );<o:p></o:p></span></span></p>
2560 + mso-highlight:white'> );<o:p></o:p></span></p>
2349 2561
2350 2562 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2351 2563 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2352 - none'><span style='mso-bookmark:_Toc376966599'><span class=GramE><span
2353 - style='font-size:8.5pt;font-family:Consolas;color:blue;background:white;
2354 - mso-highlight:white'>if</span></span></span><span style='mso-bookmark:_Toc376966599'><span
2564 + none'><span class=GramE><span style='font-size:8.5pt;font-family:Consolas;
2565 + color:blue;background:white;mso-highlight:white'>if</span></span><span
2355 2566 style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2356 - mso-highlight:white'> (res == </span></span><span style='mso-bookmark:_Toc376966599'><span
2357 - style='font-size:8.5pt;font-family:Consolas;color:blue;background:white;
2358 - mso-highlight:white'>false</span></span><span style='mso-bookmark:_Toc376966599'><span
2567 + mso-highlight:white'> (res == </span><span style='font-size:8.5pt;font-family:
2568 + Consolas;color:blue;background:white;mso-highlight:white'>false</span><span
2359 2569 style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2360 - mso-highlight:white'>)<o:p></o:p></span></span></p>
2570 + mso-highlight:white'>)<o:p></o:p></span></p>
2361 2571
2362 2572 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2363 2573 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2364 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2365 - font-family:Consolas;color:black;background:white;mso-highlight:white'>{<o:p></o:p></span></span></p>
2574 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2575 + white;mso-highlight:white'>{<o:p></o:p></span></p>
2366 2576
2367 2577 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2368 2578 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2369 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2370 - font-family:Consolas;color:black;background:white;mso-highlight:white'><span
2371 - style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span></span></span><span
2372 - style='mso-bookmark:_Toc376966599'><span class=SpellE><span class=GramE><span
2373 - style='font-size:8.5pt;font-family:Consolas;color:#2B91AF;background:white;
2374 - mso-highlight:white'>Console</span><span style='font-size:8.5pt;font-family:
2375 - Consolas;color:black;background:white;mso-highlight:white'>.WriteLine</span></span></span></span><span
2376 - style='mso-bookmark:_Toc376966599'><span class=GramE><span style='font-size:
2377 - 8.5pt;font-family:Consolas;color:black;background:white;mso-highlight:white'>(</span></span></span><span
2378 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2379 - Consolas;color:black;background:white;mso-highlight:white'>_<span class=SpellE>server.DatabaseLastError</span>);<o:p></o:p></span></span></p>
2579 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2580 + white;mso-highlight:white'><span style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;
2581 + </span></span><span class=SpellE><span class=GramE><span style='font-size:8.5pt;
2582 + font-family:Consolas;color:#2B91AF;background:white;mso-highlight:white'>Console</span><span
2583 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2584 + mso-highlight:white'>.WriteLine</span></span></span><span class=GramE><span
2585 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2586 + mso-highlight:white'>(</span></span><span style='font-size:8.5pt;font-family:
2587 + Consolas;color:black;background:white;mso-highlight:white'>_<span class=SpellE>server.DatabaseLastError</span>);<o:p></o:p></span></p>
2380 2588
2381 2589 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2382 2590 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2383 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2384 - font-family:Consolas;color:black;background:white;mso-highlight:white'><span
2385 - style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span></span></span><span
2386 - style='mso-bookmark:_Toc376966599'><span class=GramE><span style='font-size:
2387 - 8.5pt;font-family:Consolas;color:blue;background:white;mso-highlight:white'>return</span></span></span><span
2388 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2389 - Consolas;color:black;background:white;mso-highlight:white'>;<o:p></o:p></span></span></p>
2390 -
2391 - <p class=MsoNormal style='margin-left:.5in'><span style='mso-bookmark:_Toc376966599'><span
2591 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2592 + white;mso-highlight:white'><span style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;
2593 + </span></span><span class=GramE><span style='font-size:8.5pt;font-family:Consolas;
2594 + color:blue;background:white;mso-highlight:white'>return</span></span><span
2392 2595 style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2393 - mso-highlight:white'>}</span></span><span style='mso-bookmark:_Toc376966599'><span
2394 - style='font-size:8.5pt'><o:p></o:p></span></span></p>
2596 + mso-highlight:white'>;<o:p></o:p></span></p>
2597 +
2598 + <p class=MsoNormal style='margin-left:.5in'><span style='font-size:8.5pt;
2599 + font-family:Consolas;color:black;background:white;mso-highlight:white'>}</span><span
2600 + style='font-size:8.5pt'><o:p></o:p></span></p>
2395 2601
2396 - <p class=MsoNormal><span style='mso-bookmark:_Toc376966599'><span
2397 - style='font-size:8.0pt'><o:p>&nbsp;</o:p></span></span></p>
2602 + <p class=MsoNormal><span style='font-size:8.0pt'><o:p>&nbsp;</o:p></span></p>
2398 2603
2399 2604 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2400 2605 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2401 - none'><span style='mso-bookmark:_Toc376966599'><span class=GramE><span
2402 - style='font-size:8.5pt;font-family:Consolas;color:blue;background:white;
2403 - mso-highlight:white'>private</span></span></span><span style='mso-bookmark:
2404 - _Toc376966599'><span style='font-size:8.5pt;font-family:Consolas;color:black;
2405 - background:white;mso-highlight:white'> </span></span><span style='mso-bookmark:
2406 - _Toc376966599'><span style='font-size:8.5pt;font-family:Consolas;color:blue;
2407 - background:white;mso-highlight:white'>static</span></span><span
2408 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2409 - Consolas;color:black;background:white;mso-highlight:white'> </span></span><span
2410 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2411 - Consolas;color:blue;background:white;mso-highlight:white'>void</span></span><span
2412 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2413 - Consolas;color:black;background:white;mso-highlight:white'> <span class=SpellE>ServerOnConnectionStatusChange</span>(</span></span><span
2414 - style='mso-bookmark:_Toc376966599'><span class=SpellE><span style='font-size:
2415 - 8.5pt;font-family:Consolas;color:#2B91AF;background:white;mso-highlight:white'>UnityConnectionServerOdbcSdk</span></span></span><span
2416 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2417 - Consolas;color:black;background:white;mso-highlight:white'> <o:p></o:p></span></span></p>
2606 + none'><span class=GramE><span style='font-size:8.5pt;font-family:Consolas;
2607 + color:blue;background:white;mso-highlight:white'>private</span></span><span
2608 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2609 + mso-highlight:white'> </span><span style='font-size:8.5pt;font-family:Consolas;
2610 + color:blue;background:white;mso-highlight:white'>static</span><span
2611 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2612 + mso-highlight:white'> </span><span style='font-size:8.5pt;font-family:Consolas;
2613 + color:blue;background:white;mso-highlight:white'>void</span><span
2614 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2615 + mso-highlight:white'> <span class=SpellE>ServerOnConnectionStatusChange</span>(</span><span
2616 + class=SpellE><span style='font-size:8.5pt;font-family:Consolas;color:#2B91AF;
2617 + background:white;mso-highlight:white'>UnityConnectionServerOdbcSdk</span></span><span
2618 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2619 + mso-highlight:white'> <o:p></o:p></span></p>
2418 2620
2419 2621 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2420 2622 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2421 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2422 - font-family:Consolas;color:blue;background:white;mso-highlight:white'><span
2423 - style='mso-tab-count:1'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><span
2424 - style='mso-bookmark:_Toc376966599'><span class=SpellE><span class=GramE><span
2623 + none'><span style='font-size:8.5pt;font-family:Consolas;color:blue;background:
2624 + white;mso-highlight:white'><span style='mso-tab-count:1'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><span
2625 + class=SpellE><span class=GramE><span style='font-size:8.5pt;font-family:Consolas;
2626 + color:black;background:white;mso-highlight:white'>oConnectionServer</span></span></span><span
2425 2627 style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2426 - mso-highlight:white'>oConnectionServer</span></span></span></span><span
2427 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2428 - Consolas;color:black;background:white;mso-highlight:white'>)<o:p></o:p></span></span></p>
2628 + mso-highlight:white'>)<o:p></o:p></span></p>
2429 2629
2430 2630 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2431 2631 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2432 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2433 - font-family:Consolas;color:black;background:white;mso-highlight:white'>{<o:p></o:p></span></span></p>
2632 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2633 + white;mso-highlight:white'>{<o:p></o:p></span></p>
2434 2634
2435 2635 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2436 2636 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2437 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2438 - font-family:Consolas;color:black;background:white;mso-highlight:white'><span
2439 - style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span></span></span><span
2440 - style='mso-bookmark:_Toc376966599'><span class=SpellE><span class=GramE><span
2441 - style='font-size:8.5pt;font-family:Consolas;color:#2B91AF;background:white;
2442 - mso-highlight:white'>Console</span><span style='font-size:8.5pt;font-family:
2443 - Consolas;color:black;background:white;mso-highlight:white'>.WriteLine</span></span></span></span><span
2444 - style='mso-bookmark:_Toc376966599'><span class=GramE><span style='font-size:
2445 - 8.5pt;font-family:Consolas;color:black;background:white;mso-highlight:white'>(</span></span></span><span
2446 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2447 - Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;New
2448 - Status=&quot;</span></span><span style='mso-bookmark:_Toc376966599'><span
2637 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2638 + white;mso-highlight:white'><span style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;
2639 + </span></span><span class=SpellE><span class=GramE><span style='font-size:8.5pt;
2640 + font-family:Consolas;color:#2B91AF;background:white;mso-highlight:white'>Console</span><span
2641 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2642 + mso-highlight:white'>.WriteLine</span></span></span><span class=GramE><span
2449 2643 style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2450 - mso-highlight:white'>+ <span class=SpellE>oConnectionServer.ServerConnectionStatus</span>);<o:p></o:p></span></span></p>
2644 + mso-highlight:white'>(</span></span><span style='font-size:8.5pt;font-family:
2645 + Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;New
2646 + Status=&quot;</span><span style='font-size:8.5pt;font-family:Consolas;
2647 + color:black;background:white;mso-highlight:white'>+ <span class=SpellE>oConnectionServer.ServerConnectionStatus</span>);<o:p></o:p></span></p>
2451 2648
2452 2649 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2453 2650 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2454 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2455 - font-family:Consolas;color:black;background:white;mso-highlight:white'><span
2456 - style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span></span></span><span
2457 - style='mso-bookmark:_Toc376966599'><span class=GramE><span style='font-size:
2458 - 8.5pt;font-family:Consolas;color:blue;background:white;mso-highlight:white'>if</span></span></span><span
2459 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2460 - Consolas;color:black;background:white;mso-highlight:white'> (<span
2461 - class=SpellE>oConnectionServer.ServerConnectionStatus</span> == </span></span><span
2462 - style='mso-bookmark:_Toc376966599'><span class=SpellE><span style='font-size:
2463 - 8.5pt;font-family:Consolas;color:#2B91AF;background:white;mso-highlight:white'>ConnectionStatus</span><span
2651 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2652 + white;mso-highlight:white'><span style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;
2653 + </span></span><span class=GramE><span style='font-size:8.5pt;font-family:Consolas;
2654 + color:blue;background:white;mso-highlight:white'>if</span></span><span
2464 2655 style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2465 - mso-highlight:white'>.Connected</span></span></span><span style='mso-bookmark:
2466 - _Toc376966599'><span style='font-size:8.5pt;font-family:Consolas;color:black;
2467 - background:white;mso-highlight:white'>)<o:p></o:p></span></span></p>
2656 + mso-highlight:white'> (<span class=SpellE>oConnectionServer.ServerConnectionStatus</span>
2657 + == </span><span class=SpellE><span style='font-size:8.5pt;font-family:Consolas;
2658 + color:#2B91AF;background:white;mso-highlight:white'>ConnectionStatus</span><span
2659 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2660 + mso-highlight:white'>.Connected</span></span><span style='font-size:8.5pt;
2661 + font-family:Consolas;color:black;background:white;mso-highlight:white'>)<o:p></o:p></span></p>
2468 2662
2469 2663 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2470 2664 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2471 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2472 - font-family:Consolas;color:black;background:white;mso-highlight:white'><span
2473 - style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span>{<o:p></o:p></span></span></p>
2665 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2666 + white;mso-highlight:white'><span style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;
2667 + </span>{<o:p></o:p></span></p>
2474 2668
2475 2669 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2476 2670 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2477 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2478 - font-family:Consolas;color:black;background:white;mso-highlight:white'><span
2479 - style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><span
2480 - style='mso-bookmark:_Toc376966599'><span class=SpellE><span class=GramE><span
2481 - style='font-size:8.5pt;font-family:Consolas;color:#2B91AF;background:white;
2482 - mso-highlight:white'>Console</span><span style='font-size:8.5pt;font-family:
2483 - Consolas;color:black;background:white;mso-highlight:white'>.WriteLine</span></span></span></span><span
2484 - style='mso-bookmark:_Toc376966599'><span class=GramE><span style='font-size:
2485 - 8.5pt;font-family:Consolas;color:black;background:white;mso-highlight:white'>(</span></span></span><span
2486 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2487 - Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;Attached
2488 - to:&quot;</span></span><span style='mso-bookmark:_Toc376966599'><span
2671 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2672 + white;mso-highlight:white'><span
2673 + style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><span
2674 + class=SpellE><span class=GramE><span style='font-size:8.5pt;font-family:Consolas;
2675 + color:#2B91AF;background:white;mso-highlight:white'>Console</span><span
2489 2676 style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2490 - mso-highlight:white'>+_server);<o:p></o:p></span></span></p>
2677 + mso-highlight:white'>.WriteLine</span></span></span><span class=GramE><span
2678 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2679 + mso-highlight:white'>(</span></span><span style='font-size:8.5pt;font-family:
2680 + Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;Attached
2681 + to:&quot;</span><span style='font-size:8.5pt;font-family:Consolas;color:black;
2682 + background:white;mso-highlight:white'>+_server);<o:p></o:p></span></p>
2491 2683
2492 2684 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2493 2685 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2494 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2495 - font-family:Consolas;color:black;background:white;mso-highlight:white'><span
2496 - style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span>}<o:p></o:p></span></span></p>
2686 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2687 + white;mso-highlight:white'><span style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;
2688 + </span>}<o:p></o:p></span></p>
2497 2689
2498 2690 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2499 2691 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2500 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2501 - font-family:Consolas;color:black;background:white;mso-highlight:white'><span
2502 - style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span></span></span><span
2503 - style='mso-bookmark:_Toc376966599'><span class=GramE><span style='font-size:
2504 - 8.5pt;font-family:Consolas;color:blue;background:white;mso-highlight:white'>else</span></span></span><span
2505 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2506 - Consolas;color:black;background:white;mso-highlight:white'> </span></span><span
2507 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2508 - Consolas;color:blue;background:white;mso-highlight:white'>if</span></span><span
2509 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2510 - Consolas;color:black;background:white;mso-highlight:white'> (<span
2511 - class=SpellE>oConnectionServer.ServerConnectionStatus</span> == </span></span><span
2512 - style='mso-bookmark:_Toc376966599'><span class=SpellE><span style='font-size:
2513 - 8.5pt;font-family:Consolas;color:#2B91AF;background:white;mso-highlight:white'>ConnectionStatus</span><span
2692 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2693 + white;mso-highlight:white'><span style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;
2694 + </span></span><span class=GramE><span style='font-size:8.5pt;font-family:Consolas;
2695 + color:blue;background:white;mso-highlight:white'>else</span></span><span
2696 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2697 + mso-highlight:white'> </span><span style='font-size:8.5pt;font-family:Consolas;
2698 + color:blue;background:white;mso-highlight:white'>if</span><span
2514 2699 style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2515 - mso-highlight:white'>.LoginFailed</span></span></span><span style='mso-bookmark:
2516 - _Toc376966599'><span style='font-size:8.5pt;font-family:Consolas;color:black;
2517 - background:white;mso-highlight:white'>)<o:p></o:p></span></span></p>
2700 + mso-highlight:white'> (<span class=SpellE>oConnectionServer.ServerConnectionStatus</span>
2701 + == </span><span class=SpellE><span style='font-size:8.5pt;font-family:Consolas;
2702 + color:#2B91AF;background:white;mso-highlight:white'>ConnectionStatus</span><span
2703 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2704 + mso-highlight:white'>.LoginFailed</span></span><span style='font-size:8.5pt;
2705 + font-family:Consolas;color:black;background:white;mso-highlight:white'>)<o:p></o:p></span></p>
2518 2706
2519 2707 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2520 2708 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2521 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2522 - font-family:Consolas;color:black;background:white;mso-highlight:white'><span
2523 - style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span>{<o:p></o:p></span></span></p>
2709 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2710 + white;mso-highlight:white'><span style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;
2711 + </span>{<o:p></o:p></span></p>
2524 2712
2525 2713 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2526 2714 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2527 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2528 - font-family:Consolas;color:black;background:white;mso-highlight:white'><span
2529 - style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><span
2530 - style='mso-bookmark:_Toc376966599'><span class=SpellE><span class=GramE><span
2531 - style='font-size:8.5pt;font-family:Consolas;color:#2B91AF;background:white;
2532 - mso-highlight:white'>Console</span><span style='font-size:8.5pt;font-family:
2533 - Consolas;color:black;background:white;mso-highlight:white'>.WriteLine</span></span></span></span><span
2534 - style='mso-bookmark:_Toc376966599'><span class=GramE><span style='font-size:
2535 - 8.5pt;font-family:Consolas;color:black;background:white;mso-highlight:white'>(</span></span></span><span
2536 - style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;font-family:
2537 - Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;Login
2538 - failed:&quot;</span></span><span style='mso-bookmark:_Toc376966599'><span
2715 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2716 + white;mso-highlight:white'><span
2717 + style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span><span
2718 + class=SpellE><span class=GramE><span style='font-size:8.5pt;font-family:Consolas;
2719 + color:#2B91AF;background:white;mso-highlight:white'>Console</span><span
2539 2720 style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2540 - mso-highlight:white'>+<span class=SpellE>oConnectionServer.DatabaseLastError</span>);<o:p></o:p></span></span></p>
2721 + mso-highlight:white'>.WriteLine</span></span></span><span class=GramE><span
2722 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
2723 + mso-highlight:white'>(</span></span><span style='font-size:8.5pt;font-family:
2724 + Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;Login
2725 + failed:&quot;</span><span style='font-size:8.5pt;font-family:Consolas;
2726 + color:black;background:white;mso-highlight:white'>+<span class=SpellE>oConnectionServer.DatabaseLastError</span>);<o:p></o:p></span></p>
2541 2727
2542 2728 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2543 2729 margin-left:1.0in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2544 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2545 - font-family:Consolas;color:black;background:white;mso-highlight:white'>}<o:p></o:p></span></span></p>
2730 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2731 + white;mso-highlight:white'>}<o:p></o:p></span></p>
2546 2732
2547 2733 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
2548 2734 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
2549 - none'><span style='mso-bookmark:_Toc376966599'><span style='font-size:8.5pt;
2550 - font-family:Consolas;color:black;background:white;mso-highlight:white'>}<o:p></o:p></span></span></p>
2735 + none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
2736 + white;mso-highlight:white'>}<o:p></o:p></span></p>
2551 2737
2552 - <p class=MsoNormal><span style='mso-bookmark:_Toc376966599'><span
2553 - style='font-size:8.0pt'><o:p>&nbsp;</o:p></span></span></p>
2554 -
2555 - <p class=MsoNormal><span style='mso-bookmark:_Toc376966599'><span
2556 - style='font-size:8.0pt'>The primary difference here is of course wiring up the <span
2557 - class=SpellE>ConnectionStatusChangeEvent</span> handle.<span
2558 - style='mso-spacerun:yes'>&nbsp; </span>This is fired each time the connection
2559 - status changes.<span style='mso-spacerun:yes'>&nbsp; </span>It starts at &#8220;idle&#8221;
2560 - and when you initiate the login it&#8217;ll fire and change to &#8220;<span
2561 - class=SpellE>LoginPending</span>&#8221;.<span style='mso-spacerun:yes'>&nbsp;
2562 - </span>Then if the login succeeds it&#8217;ll fire again with &#8220;Connected&#8221;
2563 - or if it fails it&#8217;ll be &#8220;<span class=SpellE>LoginFailed</span>&#8221;.<span
2564 - style='mso-spacerun:yes'>&nbsp; </span>In the case of a failed login the error
2565 - event will fire if you have it wired up or you can use the <span class=SpellE>DatabaseLastError</span>
2566 - property as in the example above.<o:p></o:p></span></span></p>
2567 -
2568 - <p class=MsoNormal><span style='mso-bookmark:_Toc376966599'><span
2569 - style='font-size:8.0pt'>Notice that a handle to an instance of the <span
2570 - class=SpellE>UnityConnectionServerOdbcSdk</span> is passed back in the status change
2571 - event &#8211; this makes it simple to know which server you&#8217;re dealing
2572 - with when you have a number of them logging in and you&#8217;re handling them
2573 - all in a single event<o:p></o:p></span></span></p>
2738 + <p class=MsoNormal><span style='font-size:8.0pt'><o:p>&nbsp;</o:p></span></p>
2574 2739
2575 - <h3><span style='mso-bookmark:_Toc376966599'>The <span class=SpellE>DbFetchResult</span>
2576 - Class</span><span style='mso-bookmark:_Toc376966599'></span><span
2740 + <p class=MsoNormal><span style='font-size:8.0pt'>The primary difference here is
2741 + of course wiring up the <span class=SpellE>ConnectionStatusChangeEvent</span>
2742 + handle.<span style='mso-spacerun:yes'>&nbsp; </span>This is fired each time the
2743 + connection status changes.<span style='mso-spacerun:yes'>&nbsp; </span>It
2744 + starts at &#8220;idle&#8221; and when you initiate the login it&#8217;ll fire
2745 + and change to &#8220;<span class=SpellE>LoginPending</span>&#8221;.<span
2746 + style='mso-spacerun:yes'>&nbsp; </span>Then if the login succeeds it&#8217;ll
2747 + fire again with &#8220;Connected&#8221; or if it fails it&#8217;ll be &#8220;<span
2748 + class=SpellE>LoginFailed</span>&#8221;.<span style='mso-spacerun:yes'>&nbsp;
2749 + </span>In the case of a failed login the error event will fire if you have it
2750 + wired up or you can use the <span class=SpellE>DatabaseLastError</span>
2751 + property as in the example above.<o:p></o:p></span></p>
2752 +
2753 + <p class=MsoNormal><span style='font-size:8.0pt'>Notice that a handle to an
2754 + instance of the <span class=SpellE>UnityConnectionServerOdbcSdk</span> is
2755 + passed back in the status change event &#8211; this makes it simple to know
2756 + which server you&#8217;re dealing with when you have a number of them logging
2757 + in and you&#8217;re handling them all in a single event<o:p></o:p></span></p>
2758 +
2759 + <h3><a name="_Toc382897698">The </a><span class=SpellE><span style='mso-bookmark:
2760 + _Toc382897698'>DbFetchResult</span></span><span style='mso-bookmark:_Toc382897698'>
2761 + Class</span><span style='mso-bookmark:_Toc382897698'></span><span
2577 2762 style='font-size:12.0pt;mso-bidi-font-size:14.0pt'><o:p></o:p></span></h3>
2578 2763
2579 2764 <p class=MsoNormal><span style='font-size:8.0pt'>Throughout the library you
  @@ -2601,8 +2786,8 @@
2601 2786 everything you need for running down the problem.<span style='color:black;
2602 2787 mso-themecolor:text1'><o:p></o:p></span></span></p>
2603 2788
2604 - <h3><a name="_Toc376966600">Logging and Debugging with the SDK</a><span
2605 - style='mso-bookmark:_Toc376966600'></span><span style='font-size:12.0pt;
2789 + <h3><a name="_Toc382897699">Logging and Debugging with the SDK</a><span
2790 + style='mso-bookmark:_Toc382897699'></span><span style='font-size:12.0pt;
2606 2791 mso-bidi-font-size:14.0pt'><o:p></o:p></span></h3>
2607 2792
2608 2793 <p class=MsoNormal><span style='font-size:8.0pt'>Since I&#8217;ve been asked a
  @@ -2779,11 +2964,11 @@
2779 2964
2780 2965 <p class=MsoNormal><span style='font-size:8.0pt'>Not too tricky.<span
2781 2966 style='mso-spacerun:yes'>&nbsp; </span>Again, though, I highly encourage folks
2782 - to wire up and alert/log on error events but leave the debug events out of the
2783 - picture unless you have a driving need for them in a particular scenario.<o:p></o:p></span></p>
2967 + to wire up and alert/log on error events but leave the debug events out of the picture
2968 + unless you have a driving need for them in a particular scenario.<o:p></o:p></span></p>
2784 2969
2785 - <h3><a name="_Toc376966601"></a><a name="_Users"></a><span style='mso-bookmark:
2786 - _Toc376966601'>CUDLI Is Your Friend</span></h3>
2970 + <h3><a name="_Toc382897700"></a><a name="_Users"></a><span style='mso-bookmark:
2971 + _Toc382897700'>CUDLI Is Your Friend</span></h3>
2787 2972
2788 2973 <p class=MsoNormal><span style='font-size:8.0pt'>If you&#8217;re going to be
2789 2974 doing anything with SQL queries into Unity Connection your first stop needs to
  @@ -2794,22 +2979,22 @@
2794 2979 to run, what parameters it takes, what values are legal for them etc&#8230;
2795 2980 etc&#8230; it will save you much time and make you considerably more effective
2796 2981 developing applications.<span style='mso-spacerun:yes'>&nbsp; </span>It&#8217;s
2797 - on every desktop I develop on without exception and its up and running most of the
2798 - time.<span style='mso-spacerun:yes'>&nbsp; </span>Get your copy here:<o:p></o:p></span></p>
2982 + on every desktop I develop on without exception and its up and running most of
2983 + the time.<span style='mso-spacerun:yes'>&nbsp; </span>Get your copy here:<o:p></o:p></span></p>
2799 2984
2800 2985 <p class=MsoNormal><a
2801 2986 href="http://www.ciscounitytools.com/Applications/CxN/CUDLI/CUDLI.html">http://www.ciscounitytools.com/Applications/CxN/CUDLI/CUDLI.html</a></p>
2802 2987
2803 - <h2 style='tab-stops:110.8pt'><a name="_Toc376966602">Fetching Data</a></h2>
2988 + <h2 style='tab-stops:110.8pt'><a name="_Toc382897701">Fetching Data</a></h2>
2804 2989
2805 - <h3><a name="_Toc376966603">Data Tables and Data Readers</a></h3>
2990 + <h3><a name="_Toc382897702">Data Tables and Data Readers</a></h3>
2806 2991
2807 2992 <p class=MsoNormal><span style='font-size:8.0pt'>Before we get started
2808 2993 I&#8217;d like to briefly cover the mechanics of getting data off a server and
2809 2994 to a client via ODBC.<span style='mso-spacerun:yes'>&nbsp; </span>Naturally you
2810 2995 can fetch individual properties or a scalar value (number) that&#8217;s just a
2811 - single item &#8211; however in most cases you&#8217;re doing a fetch of more
2812 - than one row of data consisting of more than one column.<span
2996 + single item &#8211; however in most cases you&#8217;re doing a fetch of more than
2997 + one row of data consisting of more than one column.<span
2813 2998 style='mso-spacerun:yes'>&nbsp; </span>There are two approaches to doing this:
2814 2999 fill a dataset which is essentially a two dimensional array with information
2815 3000 from the query or establish a data reader for reading through all the rows.<o:p></o:p></span></p>
  @@ -2837,8 +3022,8 @@
2837 3022 style='mso-spacerun:yes'>&nbsp; </span>It&#8217;s a forward only, read only
2838 3023 data reader that maintains a connection to the server until you destroy the
2839 3024 reader.<span style='mso-spacerun:yes'>&nbsp; </span>It&#8217;s got all kinds of
2840 - intelligence built into it to <span class=SpellE>prefetch</span> rows of data
2841 - as you iterate over the result set.<span style='mso-spacerun:yes'>&nbsp;
3025 + intelligence built into it to <span class=SpellE>prefetch</span> rows of data as
3026 + you iterate over the result set.<span style='mso-spacerun:yes'>&nbsp;
2842 3027 </span>It&#8217;s quick, it&#8217;s easy and it can handle iterating over an
2843 3028 enormous return set (think hundreds of thousands of rows) reasonably
2844 3029 efficiently.<span style='mso-spacerun:yes'>&nbsp; </span><o:p></o:p></span></p>
  @@ -2858,9 +3043,9 @@
2858 3043 style='mso-spacerun:yes'>&nbsp; </span>One notable exception is the User Data
2859 3044 Dump &#8211; it uses one data reader to iterate over all users in the system
2860 3045 and then does supplemental data fetches for additional information via data
2861 - tables.<span style='mso-spacerun:yes'>&nbsp; </span>Given the large amount of data
2862 - associated with a user and the large numbers of users (20,000) possible, it
2863 - made sense to employ the efficiency of a data reader for this purpose.<span
3046 + tables.<span style='mso-spacerun:yes'>&nbsp; </span>Given the large amount of
3047 + data associated with a user and the large numbers of users (20,000) possible,
3048 + it made sense to employ the efficiency of a data reader for this purpose.<span
2864 3049 style='mso-spacerun:yes'>&nbsp; </span>To be clear, then, User Data Dump
2865 3050 actually uses two ODBC connections to the server for the duration of its run.<o:p></o:p></span></p>
2866 3051
  @@ -2872,7 +3057,7 @@
2872 3057 significantly impacting performance or memory in a typical application and is a
2873 3058 much better design choice on the whole.<o:p></o:p></span></p>
2874 3059
2875 - <h3><a name="_Toc376966604">Filling a Data Table</a></h3>
3060 + <h3><a name="_Toc382897703">Filling a Data Table</a></h3>
2876 3061
2877 3062 <p class=MsoNormal><span style='font-size:8.0pt'>Let&#8217;s start by looking
2878 3063 at one of the most common tasks you&#8217;ll want to do with the SDK and
  @@ -2998,9 +3183,9 @@
2998 3183 items in here to point out in this example.<o:p></o:p></span></p>
2999 3184
3000 3185 <p class=MsoNormal><span style='font-size:8.0pt'>First, the use parameterized
3001 - query structure.<span style='mso-spacerun:yes'>&nbsp; </span>Those &#8220;?&#8221;
3002 - in the query serve as placeholders that get replaced with values in the <span
3003 - class=SpellE>FillDataTableBlocking</span> method.<span
3186 + query structure.<span style='mso-spacerun:yes'>&nbsp; </span>Those
3187 + &#8220;?&#8221; in the query serve as placeholders that get replaced with
3188 + values in the <span class=SpellE>FillDataTableBlocking</span> method.<span
3004 3189 style='mso-spacerun:yes'>&nbsp; </span>In this case the string &#8220;<span
3005 3190 class=SpellE>seattle</span>&#8221; and &#8220;true&#8221; Boolean value.<span
3006 3191 style='mso-spacerun:yes'>&nbsp; </span>It&#8217;s important that you always use
  @@ -3043,7 +3228,7 @@
3043 3228 </span>If you pass this as true a query you&#8217;re expecting to have at least
3044 3229 one match would return a failure if the data table returned was empty.<o:p></o:p></span></p>
3045 3230
3046 - <h3><a name="_Toc376966605">Getting a Count</a></h3>
3231 + <h3><a name="_Toc382897704">Getting a Count</a></h3>
3047 3232
3048 3233 <p class=MsoNormal><span style='font-size:8.0pt'>Executing a &#8220;scalar
3049 3234 query&#8221; is simply getting a count using a SQL query &#8211; these are
  @@ -3110,7 +3295,7 @@
3110 3295 table as an out parameter which is a little more code but may be more appealing
3111 3296 to you depending on the application.<o:p></o:p></span></p>
3112 3297
3113 - <h3><a name="_Toc376966606">Getting a Single Value</a></h3>
3298 + <h3><a name="_Toc382897705">Getting a Single Value</a></h3>
3114 3299
3115 3300 <p class=MsoNormal><span style='font-size:8.0pt'>Another shortcut method
3116 3301 provided for convenience is the ability to fetch a single string value from a
  @@ -3170,7 +3355,7 @@
3170 3355 is provided merely as a shorthand time saver for very common needs such as
3171 3356 pulling values based on unique identifiers or the like.<o:p></o:p></span></p>
3172 3357
3173 - <h3><a name="_Toc376966607">Filling a Data Reader</a></h3>
3358 + <h3><a name="_Toc382897706">Filling a Data Reader</a></h3>
3174 3359
3175 3360 <p class=MsoNormal><span style='font-size:8.0pt'>If you intend on using a data
3176 3361 reader in your application you need to add the <span class=SpellE>IBM.Data.Informix</span>
  @@ -3210,8 +3395,8 @@
3210 3395 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
3211 3396 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
3212 3397 none'><span style='font-size:8.5pt;font-family:Consolas'><span
3213 - style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span
3214 - style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><o:p></o:p></span></p>
3398 + style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
3399 + </span><o:p></o:p></span></p>
3215 3400
3216 3401 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
3217 3402 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
  @@ -3315,7 +3500,7 @@
3315 3500 accidents.<span style='mso-spacerun:yes'>&nbsp; </span>Remember, it maintains
3316 3501 its own separate connection to the database via ODBC until it&#8217;s destroyed.<o:p></o:p></span></p>
3317 3502
3318 - <h2><a name="_Toc376966608">Stored Procedure Overview</a></h2>
3503 + <h2><a name="_Toc382897707">Stored Procedure Overview</a></h2>
3319 3504
3320 3505 <p class=MsoNormal><span style='font-size:8.0pt'>Stored procedures are your
3321 3506 friend.<span style='mso-spacerun:yes'>&nbsp; </span>I know many folks
  @@ -3453,8 +3638,9 @@
3453 3638 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
3454 3639 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
3455 3640 none'><span style='font-size:8.5pt;font-family:Consolas'><span
3456 - style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp; </span><span class=GramE><span
3457 - style='color:blue'>return</span></span>;<o:p></o:p></span></p>
3641 + style='mso-spacerun:yes'>&nbsp;&nbsp; </span><span
3642 + style='mso-spacerun:yes'>&nbsp;</span><span class=GramE><span style='color:
3643 + blue'>return</span></span>;<o:p></o:p></span></p>
3458 3644
3459 3645 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
3460 3646 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
  @@ -3496,7 +3682,7 @@
3496 3682 you be a good Unity Connection citizen by logging those details in the audit
3497 3683 log on Connection for later troubleshooting purposes.<o:p></o:p></span></p>
3498 3684
3499 - <h3><a name="_Toc376966609">Stored Procedure Naming Strategy</a></h3>
3685 + <h3><a name="_Toc382897708">Stored Procedure Naming Strategy</a></h3>
3500 3686
3501 3687 <p class=MsoNormal><span style='font-size:8.0pt'>All stored procedures added by
3502 3688 Unity Connection start with &#8220;<span class=SpellE>csp</span>_&#8221;
  @@ -3512,8 +3698,8 @@
3512 3698 </span>However, not to worry &#8211; a good chunk of them can be ignored and
3513 3699 the rest are easily understood based on a simple naming convention.<o:p></o:p></span></p>
3514 3700
3515 - <p class=MsoNormal><span style='font-size:8.0pt'>First, any procedure that
3516 - contains the sub string &#8220;<b style='mso-bidi-font-weight:normal'>_gen_</b>&#8221;
3701 + <p class=MsoNormal><span style='font-size:8.0pt'>First, any procedure that contains
3702 + the sub string &#8220;<b style='mso-bidi-font-weight:normal'>_gen_</b>&#8221;
3517 3703 in it can be ignored.<span style='mso-spacerun:yes'>&nbsp; </span>So for
3518 3704 instanced &#8220;<span class=SpellE><b style='mso-bidi-font-weight:normal'>csp_timezone_gen_tr_insert</b></span>&#8221;
3519 3705 or &#8220;<span class=SpellE><b style='mso-bidi-font-weight:normal'>csp_user_gen_tr_update</b></span>&#8221;
  @@ -3524,14 +3710,13 @@
3524 3710 you&#8217;re curious but you shouldn&#8217;t be worrying about these for use in
3525 3711 your applications.<o:p></o:p></span></p>
3526 3712
3527 - <p class=MsoNormal><span style='font-size:8.0pt'>The remaining stored
3528 - procedures in the list come in sets of 3 for create, modify, delete methods and
3529 - the stored procedure name always starts with the name of the object
3530 - you&#8217;re working with.<span style='mso-spacerun:yes'>&nbsp;
3531 - </span>There&#8217;s a few special functions in addition to the basic 3 here
3532 - and there (for instance <span class=SpellE>csp_BroadcastMessagePurge</span>)
3533 - but for the most part all stored procedure names start with the object type
3534 - followed by the 3 functions.<o:p></o:p></span></p>
3713 + <p class=MsoNormal><span style='font-size:8.0pt'>The remaining stored procedures
3714 + in the list come in sets of 3 for create, modify, delete methods and the stored
3715 + procedure name always starts with the name of the object you&#8217;re working
3716 + with.<span style='mso-spacerun:yes'>&nbsp; </span>There&#8217;s a few special
3717 + functions in addition to the basic 3 here and there (for instance <span
3718 + class=SpellE>csp_BroadcastMessagePurge</span>) but for the most part all stored
3719 + procedure names start with the object type followed by the 3 functions.<o:p></o:p></span></p>
3535 3720
3536 3721 <p class=MsoNormal><span style='font-size:8.0pt'>So for instance if you want to
3537 3722 create, modify or delete a subscriber (a user with a mailbox) you would use
  @@ -3581,14 +3766,14 @@
3581 3766 of the <span class=SpellE>proc</span> and instead look at your required
3582 3767 parameters.<o:p></o:p></span></p>
3583 3768
3584 - <h3><a name="_Toc376966610">Return Values from Stored Procedures</a></h3>
3769 + <h3><a name="_Toc382897709">Return Values from Stored Procedures</a></h3>
3585 3770
3586 3771 <p class=MsoNormal><span style='font-size:8.0pt'>As a rule, all <span
3587 3772 class=GramE>the create</span> stored procedures return 1 or more values and all
3588 3773 the rest of the stored procedures do not return anything.<span
3589 3774 style='mso-spacerun:yes'>&nbsp; </span>Why do you care?<span
3590 - style='mso-spacerun:yes'>&nbsp; </span>If you call a stored procedure that returns
3591 - a value without getting that value the call will fail.<span
3775 + style='mso-spacerun:yes'>&nbsp; </span>If you call a stored procedure that
3776 + returns a value without getting that value the call will fail.<span
3592 3777 style='mso-spacerun:yes'>&nbsp; </span>Trying to fetch a return value when one
3593 3778 is not present will also fail of course.<span style='mso-spacerun:yes'>&nbsp;
3594 3779 </span>So you need to be sure to call the procedure you are using with the
  @@ -3739,8 +3924,8 @@
3739 3924 requires we already uploaded a WAV file as a stream file (done using CUPI REST
3740 3925 API which is not covered here) and you have a subscriber&#8217;s ID to act as
3741 3926 the owner (sender) of the message.<span style='mso-spacerun:yes'>&nbsp;
3742 - </span>We&#8217;ll set the broadcast message to live for 5 days max. <span
3743 - style='mso-spacerun:yes'>&nbsp;</span>The code looks like this:<o:p></o:p></span></p>
3927 + </span>We&#8217;ll set the broadcast message to live for 5 days max.<span
3928 + style='mso-spacerun:yes'>&nbsp; </span>The code looks like this:<o:p></o:p></span></p>
3744 3929
3745 3930 <p class=MsoNormal><span style='font-size:8.0pt'><o:p>&nbsp;</o:p></span></p>
3746 3931
  @@ -3854,10 +4039,10 @@
3854 4039 <p class=MsoNormal style='margin-top:0in;mso-layout-grid-align:none;text-autospace:
3855 4040 none'><span style='font-size:8.0pt;mso-bidi-font-family:Arial'>Of note here is
3856 4041 the out parameter for the new <span class=SpellE>objectId</span> &#8211; if
3857 - that is not passed the call to the stored procedure will fail since it&#8217;s
3858 - expecting to pass back a value for the new Id here.<span
3859 - style='mso-spacerun:yes'>&nbsp; </span>If we then turn around and delete that
3860 - same broadcast message the call would look like this:<o:p></o:p></span></p>
4042 + that is not passed the call to the stored procedure will fail since it&#8217;s expecting
4043 + to pass back a value for the new Id here.<span style='mso-spacerun:yes'>&nbsp;
4044 + </span>If we then turn around and delete that same broadcast message the call
4045 + would look like this:<o:p></o:p></span></p>
3861 4046
3862 4047 <p class=MsoNormal style='margin-top:0in;mso-layout-grid-align:none;text-autospace:
3863 4048 none'><span style='font-size:8.0pt;mso-bidi-font-family:Arial'><o:p>&nbsp;</o:p></span></p>
  @@ -3957,10 +4142,10 @@
3957 4142 style='mso-spacerun:yes'>&nbsp; </span>You now know everything you need to for
3958 4143 writing applications using ODBC &#8211; what follows is some examples to help
3959 4144 flesh out common tasks but for the most part everything you need to know is
3960 - contained in the CUDLI interface via the data dictionary notes and the stored
3961 - procedure and view/table interfaces.<o:p></o:p></span></p>
4145 + contained in the CUDLI interface via the data dictionary notes and the stored procedure
4146 + and view/table interfaces.<o:p></o:p></span></p>
3962 4147
3963 - <h2><a name="_Toc376966611">Changing Database Focus</a></h2>
4148 + <h2><a name="_Toc382897710">Changing Database Focus</a></h2>
3964 4149
3965 4150 <p class=MsoNormal><span style='font-size:8.0pt'>By default when you attach to
3966 4151 the Unity Connection server you are connected to the <span class=SpellE><b
  @@ -3973,7 +4158,7 @@
3973 4158 CUDLI if you like).<span style='mso-spacerun:yes'>&nbsp; </span>Here&#8217;s
3974 4159 the list of all database names you can attach to:<o:p></o:p></span></p>
3975 4160
3976 - <p class=MsoListParagraphCxSpFirst style='text-indent:-.25in;mso-list:l0 level1 lfo4'><![if !supportLists]><span
4161 + <p class=MsoListParagraphCxSpFirst style='text-indent:-.25in;mso-list:l1 level1 lfo4'><![if !supportLists]><span
3977 4162 style='font-size:8.0pt;font-family:Symbol;mso-fareast-font-family:Symbol;
3978 4163 mso-bidi-font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
3979 4164 style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  @@ -3982,7 +4167,7 @@
3982 4167 style='font-size:8.0pt'>.<span style='mso-spacerun:yes'>&nbsp; </span>The main
3983 4168 directory database which is the default when attaching to a Connection server.<o:p></o:p></span></p>
3984 4169
3985 - <p class=MsoListParagraphCxSpMiddle style='text-indent:-.25in;mso-list:l0 level1 lfo4'><![if !supportLists]><span
4170 + <p class=MsoListParagraphCxSpMiddle style='text-indent:-.25in;mso-list:l1 level1 lfo4'><![if !supportLists]><span
3986 4171 style='font-size:8.0pt;font-family:Symbol;mso-fareast-font-family:Symbol;
3987 4172 mso-bidi-font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
3988 4173 style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  @@ -3994,7 +4179,7 @@
3994 4179 </span>There isn&#8217;t anything in here that a typical application would be
3995 4180 interested in and certainly nothing you&#8217;d need to create or modify.<o:p></o:p></span></p>
3996 4181
3997 - <p class=MsoListParagraphCxSpMiddle style='text-indent:-.25in;mso-list:l0 level1 lfo4'><![if !supportLists]><span
4182 + <p class=MsoListParagraphCxSpMiddle style='text-indent:-.25in;mso-list:l1 level1 lfo4'><![if !supportLists]><span
3998 4183 style='font-size:8.0pt;font-family:Symbol;mso-fareast-font-family:Symbol;
3999 4184 mso-bidi-font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
4000 4185 style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  @@ -4006,7 +4191,7 @@
4006 4191 process about every 30 minutes or so.<span style='mso-spacerun:yes'>&nbsp;
4007 4192 </span><o:p></o:p></span></p>
4008 4193
4009 - <p class=MsoListParagraphCxSpLast style='text-indent:-.25in;mso-list:l0 level1 lfo4'><![if !supportLists]><span
4194 + <p class=MsoListParagraphCxSpLast style='text-indent:-.25in;mso-list:l1 level1 lfo4'><![if !supportLists]><span
4010 4195 style='font-size:8.0pt;font-family:Symbol;mso-fareast-font-family:Symbol;
4011 4196 mso-bidi-font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
4012 4197 style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  @@ -4081,7 +4266,7 @@
4081 4266 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
4082 4267 none'><span style='font-size:8.5pt;font-family:Consolas'><o:p>&nbsp;</o:p></span></p>
4083 4268
4084 - <h2><a name="_Toc376966612">Checking Connection Version</a></h2>
4269 + <h2><a name="_Toc382897711">Checking Connection Version</a></h2>
4085 4270
4086 4271 <p class=MsoNormal><span style='font-size:8.0pt'>One common task you may need
4087 4272 to do (I certainly do) is check the version of Unity Connection your
  @@ -4141,7 +4326,7 @@
4141 4326 <p class=MsoNormal><span style='font-size:8.0pt'>You can also provide build and
4142 4327 ES levels, although the need to know that level of detail is pretty rare.<o:p></o:p></span></p>
4143 4328
4144 - <h2><a name="_Toc376966613">Checking for Extension Conflicts</a></h2>
4329 + <h2><a name="_Toc382897712">Checking for Extension Conflicts</a></h2>
4145 4330
4146 4331 <p class=MsoNormal><span style='font-size:8.0pt'>Another common task when
4147 4332 creating users (or call handlers perhaps) is to check if there&#8217;s an
  @@ -4253,7 +4438,7 @@
4253 4438 background:white'><span style='font-size:8.0pt;mso-bidi-font-family:Arial;
4254 4439 color:black'><o:p>&nbsp;</o:p></span></p>
4255 4440
4256 - <h2><a name="_Toc376966614">Finding Objects by Name, Extension and/or Alias</a></h2>
4441 + <h2><a name="_Toc382897713">Finding Objects by Name, Extension and/or Alias</a></h2>
4257 4442
4258 4443 <p class=MsoNormal><span style='font-size:8.0pt'>The SDK provides several
4259 4444 &#8220;<span class=SpellE><b style='mso-bidi-font-weight:normal'>Find</b>xxx</span>&#8221;
  @@ -4443,8 +4628,8 @@
4443 4628 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
4444 4629 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
4445 4630 none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
4446 - white;mso-highlight:white'><span style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;
4447 - </span>}<o:p></o:p></span></p>
4631 + white;mso-highlight:white'><span style='mso-spacerun:yes'>&nbsp;&nbsp; </span><span
4632 + style='mso-spacerun:yes'>&nbsp;</span>}<o:p></o:p></span></p>
4448 4633
4449 4634 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
4450 4635 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
  @@ -4479,8 +4664,8 @@
4479 4664 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
4480 4665 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
4481 4666 none'><span style='font-size:8.5pt;font-family:Consolas;color:black;background:
4482 - white;mso-highlight:white'><span style='mso-spacerun:yes'>&nbsp; </span><span
4483 - style='mso-spacerun:yes'>&nbsp;&nbsp;</span>}<o:p></o:p></span></p>
4667 + white;mso-highlight:white'><span style='mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;
4668 + </span>}<o:p></o:p></span></p>
4484 4669
4485 4670 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
4486 4671 margin-left:.5in;margin-bottom:.0001pt;mso-layout-grid-align:none;text-autospace:
  @@ -4543,9 +4728,9 @@
4543 4728 mso-highlight:white'>.WriteLine</span></span></span><span class=GramE><span
4544 4729 style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
4545 4730 mso-highlight:white'>(</span></span><span style='font-size:8.5pt;font-family:
4546 - Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;User found,
4547 - ID=&quot;</span><span style='font-size:8.5pt;font-family:Consolas;color:black;
4548 - background:white;mso-highlight:white'> + <span class=SpellE>strObjectId</span>);<o:p></o:p></span></p>
4731 + Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;User found, ID=&quot;</span><span
4732 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
4733 + mso-highlight:white'> + <span class=SpellE>strObjectId</span>);<o:p></o:p></span></p>
4549 4734
4550 4735 <p class=MsoNormal style='margin-top:0in;margin-right:0in;margin-bottom:0in;
4551 4736 margin-left:.5in;margin-bottom:.0001pt;tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;
  @@ -4553,11 +4738,113 @@
4553 4738 background:white;mso-highlight:white'>}</span><span style='font-size:8.5pt;
4554 4739 mso-bidi-font-family:Arial;color:black'><o:p></o:p></span></p>
4555 4740
4556 - <h1><a name="_Toc376966615">Revision History</a></h1>
4741 + <h2><a name="_Toc382897714">Using the </a><span class=SpellE><span
4742 + style='mso-bookmark:_Toc382897714'>ComboBox</span></span><span
4743 + style='mso-bookmark:_Toc382897714'> Helper Class</span></h2>
4744 +
4745 + <p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
4746 + style='font-size:8.0pt;mso-bidi-font-family:Arial'>If you're like me you have
4747 + to throw up quick <span class=SpellE>WinForms</span> applications as proof of
4748 + concept vehicles or distributable tools as the case may be.<span
4749 + style='mso-spacerun:yes'>&nbsp; </span>One of the items that <span class=GramE>comes</span>
4750 + up fairly often is the need to populate a simple combo box with items the user
4751 + can select from such as which schedule set to apply to a user or which template
4752 + to select when creating a new call handler etc.<span
4753 + style='mso-spacerun:yes'>&nbsp; </span>This comes up often enough that we added
4754 + some sugar to the SDK to help deal with it quickly and efficiently.<span
4755 + style='mso-spacerun:yes'>&nbsp; </span>You'll find the <span class=SpellE>ComboBoxHelper</span>
4756 + static class that's there to help you fill and fetch such lists easily - you
4757 + can extend the design pattern to just about any type of list based object.</span><span
4758 + style='font-size:12.0pt;mso-bidi-font-family:Arial'><o:p></o:p></span></p>
4759 +
4760 + <p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
4761 + style='font-size:8.0pt;mso-bidi-font-family:Arial'>Here's a quick example of
4762 + how to use it to present a list of user templates to choose from when creating
4763 + a new user.<span style='mso-spacerun:yes'>&nbsp; </span>First you simply fill a
4764 + combo box with the display names of all the user templates on your target
4765 + Connection server with a single line.<span style='mso-spacerun:yes'>&nbsp;
4766 + </span>It simply asks you to provide a table or view, which column name to use
4767 + for display purposes and which column name to use for unique id purposes.<span
4768 + style='mso-spacerun:yes'>&nbsp; </span>To fill in the user templates into a
4769 + combo box would look like this:<o:p></o:p></span></p>
4770 +
4771 + <p class=MsoNormal style='margin-left:.5in'><span class=GramE><span
4772 + style='font-size:8.5pt;font-family:Consolas;color:#2B91AF;background:white;
4773 + mso-highlight:white'>ComboBoxHelper</span><span style='font-size:8.5pt;
4774 + font-family:Consolas;color:black;background:white;mso-highlight:white'>.FillComboBoxWithObjects(</span></span><span
4775 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
4776 + mso-highlight:white'>server,cBox1,</span><span style='font-size:8.5pt;
4777 + font-family:Consolas;color:#A31515;background:white;mso-highlight:white'>&quot;vw_usertemplate&quot;</span><span
4778 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
4779 + mso-highlight:white'>,</span><span style='font-size:8.5pt;font-family:Consolas;
4780 + color:#A31515;background:white;mso-highlight:white'>&quot;DisplayName&quot;</span><span
4781 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
4782 + mso-highlight:white'>,</span><span style='font-size:8.5pt;font-family:Consolas;
4783 + color:#A31515;background:white;mso-highlight:white'>&quot;ObjectId&quot;</span><span
4784 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
4785 + mso-highlight:white'>);</span><span style='font-size:8.5pt;font-family:Consolas;
4786 + color:black'><o:p></o:p></span></p>
4787 +
4788 + <p class=MsoNormal><span class=GramE><span style='font-size:8.0pt;mso-bidi-font-family:
4789 + Arial;color:black'>Easy.</span></span><span style='font-size:8.0pt;mso-bidi-font-family:
4790 + Arial;color:black'><span style='mso-spacerun:yes'>&nbsp; </span>All the user
4791 + template display names are shown in the drop down list in alphabetical order
4792 + for you and to fetch the <span class=SpellE>ObjectId</span> for the currently
4793 + selected template requires another single code line like this:<o:p></o:p></span></p>
4794 +
4795 + <p class=MsoNormal><span style='font-size:8.0pt;font-family:Consolas;
4796 + color:black;background:white;mso-highlight:white'><o:p>&nbsp;</o:p></span></p>
4797 +
4798 + <p class=MsoNormal style='margin-left:.5in'><span class=SpellE><span
4799 + class=GramE><span style='font-size:8.5pt;font-family:Consolas;color:black;
4800 + background:white;mso-highlight:white'>strObjectId</span></span></span><span
4801 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
4802 + mso-highlight:white'> = </span><span class=SpellE><span style='font-size:8.5pt;
4803 + font-family:Consolas;color:#2B91AF;background:white;mso-highlight:white'>ComboBoxHelper</span><span
4804 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
4805 + mso-highlight:white'>.GetIdFromCurrentComboBoxItem</span></span><span
4806 + style='font-size:8.5pt;font-family:Consolas;color:black;background:white;
4807 + mso-highlight:white'>(cBox1);</span><span style='font-size:8.5pt;font-family:
4808 + Consolas;color:black'><o:p></o:p></span></p>
4809 +
4810 + <p class=MsoNormal><span style='font-size:8.0pt;font-family:Consolas;
4811 + color:black'><o:p>&nbsp;</o:p></span></p>
4812 +
4813 + <p class=MsoNormal><span style='font-size:8.0pt;mso-bidi-font-family:Arial;
4814 + color:black'>The <span class=SpellE>fillComboBoxWithObjects</span> method also
4815 + allows you to set a WHERE clause if you need to be more selective about which
4816 + objects you select and has a handy &#8220;<span class=SpellE>LocalOnly</span>&#8221;
4817 + Boolean flag which defaults to true to limit the list of items to those only
4818 + hosted on the attached Connection server.<span style='mso-spacerun:yes'>&nbsp;
4819 + </span>If you pass that as false for, say, locations you can get the list of
4820 + all locations in the network of Connection servers if you like.<span
4821 + style='mso-spacerun:yes'>&nbsp; </span>For typical list presentation this can
4822 + save you a bunch of time for simple user interface needs.</span><span
4823 + style='font-size:8.0pt;mso-bidi-font-family:Arial'><o:p></o:p></span></p>
4824 +
4825 + <h1><a name="_Toc382897715">Revision History</a></h1>
4826 +
4827 + <p class=MsoNormal><span style='font-size:8.0pt'>Version 3.0.5 &#8211; 3/18/2014<o:p></o:p></span></p>
4828 +
4829 + <p class=MsoListParagraphCxSpFirst style='text-indent:-.25in;mso-list:l0 level1 lfo9'><![if !supportLists]><span
4830 + style='font-size:8.0pt;font-family:Symbol;mso-fareast-font-family:Symbol;
4831 + mso-bidi-font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
4832 + style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
4833 + </span></span></span><![endif]><span style='font-size:8.0pt'>Added <span
4834 + class=SpellE>ComboBoxHelper</span> class to make filling <span class=SpellE>combobox</span>
4835 + drop downs with lists of objects from ODBC fetches and retrieving them easy.<o:p></o:p></span></p>
4836 +
4837 + <p class=MsoListParagraphCxSpLast style='text-indent:-.25in;mso-list:l0 level1 lfo9'><![if !supportLists]><span
4838 + style='font-size:8.0pt;font-family:Symbol;mso-fareast-font-family:Symbol;
4839 + mso-bidi-font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
4840 + style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
4841 + </span></span></span><![endif]><span style='font-size:8.0pt'>Updated login
4842 + sequence to always issue <o:p></o:p></span></p>
4557 4843
4558 - <p class=MsoNormal><span style='font-size:8.0pt'>Version 3.0.4 &#8211; 1/10/2014<o:p></o:p></span></p>
4844 + <p class=MsoNormal><span style='font-size:8.0pt'>Version 3.0.4 &#8211;
4845 + 1/10/2014<o:p></o:p></span></p>
4559 4846
4560 - <p class=MsoListParagraph style='text-indent:-.25in;mso-list:l3 level1 lfo7'><![if !supportLists]><span
4847 + <p class=MsoListParagraph style='text-indent:-.25in;mso-list:l4 level1 lfo6'><![if !supportLists]><span
4561 4848 style='font-size:8.0pt;font-family:Symbol;mso-fareast-font-family:Symbol;
4562 4849 mso-bidi-font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
4563 4850 style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  @@ -4566,7 +4853,7 @@
4566 4853
4567 4854 <p class=MsoNormal><span style='font-size:8.0pt'>Version 3.0.2 - 1/8/2014<o:p></o:p></span></p>
4568 4855
4569 - <p class=MsoListParagraph style='text-indent:-.25in;mso-list:l1 level1 lfo6'><![if !supportLists]><span
4856 + <p class=MsoListParagraph style='text-indent:-.25in;mso-list:l2 level1 lfo8'><![if !supportLists]><span
4570 4857 style='font-size:8.0pt;font-family:Symbol;mso-fareast-font-family:Symbol;
4571 4858 mso-bidi-font-family:Symbol'><span style='mso-list:Ignore'>&middot;<span
4572 4859 style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;