.NET 2.0 COM Excel add-in stops responding when SqlConnection object is created "Johan Zietsman" <johan.zietsman[ at ]webmail.co.za> 24.08.2006 15:35:33 Dear All I have encountered a problem when creating a System.Data.SqlClient.SqlConnection in my Excel add-in. I am using: - Visual Studio 2005 - Excel 2003 SP2 I created the add-in with the VS2005 Shared Add-in Wizard. I then included the required Office and Microsoft.Office.Interop.Excel assembly references. In the OnConnection method I add two buttons to the Excel menu. In the first button (called createSqlConnectionButton) I do the following: System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(); In the second button (called createOleDbConnectionButton) I do the following: System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(); I attach the code to this post. When I press the createOleDbConnectionButton to execute its event handler, everything works fine. When I press the createSqlConnectionButton to execute its event handler, it also executes, but after that, the add-in does not respond to any user interaction from these buttons any more. Any help on this will be greatly appreciated. Kind regards Johan Zietsman begin 666 Connect.cs M;F%M97-P86-E($UY061D:6XR#0I[#0H[ at ](" [ at ]=7-I;F<[ at ]4WES=&5M.PT*(" [ at ] M('5S:6YG($5X=&5N<VEB:6QI='D[#0H[ at ](" [ at ]=7-I;F<[ at ]4WES=&5M+E)U;G1I M;64N26YT97)O<%-E<G9I8V5S.PT*(" [ at ]('5S:6YG(%-Y<W1E;2Y7:6YD;W=S M+D9O<FUS.PT*(" [ at ]('5S:6YG(%-Y<W1E;2Y2969L96-T:6]N.PT*(" [ at ]('5S M:6YG(%-Y<W1E;2Y#;VQL96-T:6]N<RY'96YE<FEC.PT*(" [ at ]('5S:6YG(%-Y M<W1E;2Y$:6%G;F]S=&EC<SL-"B [ at ]("!U<VEN9R!3>7-T96TN1&%T83L-"B [ at ] M("!U<VEN9R!-:6-R;W-O9G0N3V9F:6-E+D-O<F4[#0H[ at ](" [ at ]=7-I;F<[ at ]36EC M<F]S;V9T+D]F9FEC92Y);G1E<F]P+D5X8V5L.PT*#0H)6T=U:61!='1R:6)U M=&4H(D8V14-$13%!+3 U,C,M-#%"1BTX1$$Q+3-!0S<U04-"0C4X-2(I+"!0 M<F]G260H(DUY061D:6XR+D-O;FYE8W0B*5T-"[ at ]EP=6)L:6,[ at ]8VQA<W,[ at ]0V]N M;F5C=" Z($]B:F5C="P[ at ]17AT96YS:6)I;&ET>2Y)1%1%>'1E;G-I8FEL:71Y M,[ at ]T*"7L-"[ at ]D)<'5B;&EC($-O;FYE8W0H*0T*"0E[#0H)"7T-"[ at ]T*"0EP=6)L M:6,[ at ]=F]I9"!/;D-O;FYE8W1I;VXH;V)J96-T(&%P<&QI8V%T:6]N+"!%>'1E M;G-I8FEL:71Y+F5X=%]#;VYN96-T36]D92!C;VYN96-T36]D92P[ at ];V)J96-T M(&%D9$EN26YS="P[ at ]<F5F(%-Y<W1E;2Y!<G)A>2!C=7-T;VTI#0H)"7L-"B [ at ] M(" [ at ](" [ at ](" [ at ](&5X8V5L(#T[ at ]*$UI8W)O<V]F="Y/9F9I8V4N26YT97)O<"Y% M>&-E;"Y!<'!L:6-A=&EO;BEA<'!L:6-A=&EO;CL-"B [ at ](" [ at ](" [ at ](" [ at ](&%D M9$EN26YS=&%N8V4[ at ]/2!A9&1);DEN<W0[#0H-"B [ at ](" [ at ](" [ at ](" [ at ]($)U:6QD M365N=2[ at ]I.PT*(" [ at ](" [ at ]("!]#0H-"[ at ]D)<'5B;&EC('9O:60[ at ]3VY$:7-C;VYN M96-T:6]N*$5X=&5N<VEB:6QI='DN97AT7T1I<V-O;FYE8W1-;V1E(&1I<V-O M;FYE8W1-;V1E+"!R968[ at ]4WES=&5M+D%R<F%Y(&-U<W1O;2D-"[ at ]D)>PT*"0E] M#0H-"[ at ]D)<'5B;&EC('9O:60[ at ]3VY!9&1);G-5<&1A=&4H<F5F(%-Y<W1E;2Y! M<G)A>2!C=7-T;VTI#0H)"7L-"[ at ]D)?0T*#0H)"7!U8FQI8R!V;VED($]N4W1A M<G1U<$-O;7!L971E*')E9B!3>7-T96TN07)R87D[ at ]8W5S=&]M*0T*"0E[#0H) M"7T-"[ at ]T*"0EP=6)L:6,[ at ]=F]I9"!/;D)E9VEN4VAU=&1O=VXH<F5F(%-Y<W1E M;2Y!<G)A>2!C=7-T;VTI#0H)"7L-"[ at ]D)?0T*#0H[ at ](" [ at ](" [ at ]('!R:79A=&4[ at ] M36EC<F]S;V9T+D]F9FEC92Y);G1E<F]P+D5X8V5L+D%P<&QI8V%T:6]N(&5X M8V5L.PT*"0EP<FEV871E(&]B:F5C="!A9&1);DEN<W1A;F-E.PT*#0H[ at ](" [ at ] M(" [ at ]('!R:79A=&4[ at ]=F]I9"!"=6EL9$UE;G4H*0T*(" [ at ](" [ at ]("![#0H[ at ](" [ at ] M(" [ at ](" [ at ]("!T<GD-"B [ at ](" [ at ](" [ at ](" [ at ]('L-"B [ at ](" [ at ](" [ at ](" [ at ](" [ at ](" O M+R!!9&0[ at ]=&AE(&UE;G4[ at ]:71E;2!T;R!T:&4[ at ]5V]R:W-H965T($UE;G4[ at ]0F%R M+[ at ]T*(" [ at ](" [ at ](" [ at ](" [ at ](" [ at ]($-O;6UA;F1"87([ at ]=V]R:W-H965T365N=4)A M<B ](&5X8V5L+D-O;6UA;F1"87)S6R)7;W)K<VAE970[ at ]365N=2!"87(B73L- M"B [ at ](" [ at ](" [ at ](" [ at ](" [ at ]("!I;G0[ at ]:2 ]('=O<FMS:&5E=$UE;G5"87(N0V]N M=')O;'-;(E=I;F1O=R)=+DEN9&5X.PT*(" [ at ](" [ at ](" [ at ](" [ at ](" [ at ]($-O;6UA M;F1"87)0;W!U<"!E;7-I;71E;4)U='1O;E!O<'5P(#T[ at ]*$-O;6UA;F1"87)0 M;W!U<"EW;W)K<VAE971-96YU0F%R+D-O;G1R;VQS+D%D9"A-<V]#;VYT<F]L M5'EP92YM<V]#;VYT<F]L4&]P=7 L($UI<W-I;F<N5F%L=64L($UI<W-I;F<N M5F%L=64L(&DL('1R=64I.PT*(" [ at ](" [ at ](" [ at ](" [ at ](" [ at ](&5M<VEM=&5M0G5T M=&]N4&]P=7 N16YA8FQE9" ]('1R=64[#0H[ at ](" [ at ](" [ at ](" [ at ](" [ at ](" [ at ]96US M:6UT96U"=71T;VY0;W!U<"Y6:7-I8FQE(#T[ at ]=')U93L-"B [ at ](" [ at ](" [ at ](" [ at ] M(" [ at ]("!E;7-I;71E;4)U='1O;E!O<'5P+D-A<'1I;VX[ at ]/2 B5&5S=&5R(# R M(CL-"[ at ]T*(" [ at ](" [ at ](" [ at ](" [ at ](" [ at ]("\O($%D9"!T:&4[ at ])T-R96%T92!3<6Q# M;VYN96-T:6]N)R!I=&5M+[ at ]T*(" [ at ](" [ at ](" [ at ](" [ at ](" [ at ]($-O;6UA;F1"87)" M=71T;VX[ at ]8W)E871E4W%L0V]N;F5C=&EO;D)U='1O;B ]("A#;VUM86YD0F%R M0G5T=&]N*65M<VEM=&5M0G5T=&]N4&]P=7 N0V]N=')O;',N061D*$US;T-O M;G1R;VQ4>7!E+FUS;T-O;G1R;VQ"=71T;VXL($UI<W-I;F<N5F%L=64L($UI M<W-I;F<N5F%L=64L($UI<W-I;F<N5F%L=64L('1R=64I.PT*(" [ at ](" [ at ](" [ at ] M(" [ at ](" [ at ](&-R96%T95-Q;$-O;FYE8W1I;VY"=71T;VXN16YA8FQE9" ]('1R M=64[#0H[ at ](" [ at ](" [ at ](" [ at ](" [ at ](" [ at ]8W)E871E4W%L0V]N;F5C=&EO;D)U='1O M;BY6:7-I8FQE(#T[ at ]=')U93L-"B [ at ](" [ at ](" [ at ](" [ at ](" [ at ]("!C<F5A=&53<6Q# M;VYN96-T:6]N0G5T=&]N+D-A<'1I;VX[ at ]/2 B0W)E871E(%-Q;$-O;FYE8W1I M;VXB.PT*(" [ at ](" [ at ](" [ at ](" [ at ](" [ at ](&-R96%T95-Q;$-O;FYE8W1I;VY"=71T M;VXN0VQI8VL[ at ]*ST[ at ];F5W(%]#;VUM86YD0F%R0G5T=&]N179E;G1S7T-L:6-K M179E;G1(86YD;&5R*&-R96%T95-Q;$-O;FYE8W1I;VY"=71T;VY?0VQI8VLI M.PT*#0H[ at ](" [ at ](" [ at ](" [ at ](" [ at ](" [ at ]+R\[ at ]061D('1H92 G0W)E871E($]L941B M0V]N;F5C=&EO;B<[ at ]:71E;2X-"B [ at ](" [ at ](" [ at ](" [ at ](" [ at ]("!#;VUM86YD0F%R M0G5T=&]N(&-R96%T94]L941B0V]N;F5C=&EO;D)U='1O;B ]("A#;VUM86YD M0F%R0G5T=&]N*65M<VEM=&5M0G5T=&]N4&]P=7 N0V]N=')O;',N061D*$US M;T-O;G1R;VQ4>7!E+FUS;T-O;G1R;VQ"=71T;VXL($UI<W-I;F<N5F%L=64L M($UI<W-I;F<N5F%L=64L($UI<W-I;F<N5F%L=64L('1R=64I.PT*(" [ at ](" [ at ] M(" [ at ](" [ at ](" [ at ](&-R96%T94]L941B0V]N;F5C=&EO;D)U='1O;BY%;F%B;&5D M(#T[ at ]=')U93L-"B [ at ](" [ at ](" [ at ](" [ at ](" [ at ]("!C<F5A=&5/;&5$8D-O;FYE8W1I M;VY"=71T;VXN5FES:6)L92 ]('1R=64[#0H[ at ](" [ at ](" [ at ](" [ at ](" [ at ](" [ at ]8W)E M871E3VQE1&)#;VYN96-T:6]N0G5T=&]N+D-A<'1I;VX[ at ]/2 B0W)E871E($]L M941B0V]N;F5C=&EO;B([#0H[ at ](" [ at ](" [ at ](" [ at ](" [ at ](" [ at ]8W)E871E3VQE1&)# M;VYN96-T:6]N0G5T=&]N+D-L:6-K("L](&YE=R!?0V]M;6%N9$)A<D)U='1O M;D5V96YT<U]#;&EC:T5V96YT2&%N9&QE<BAC<F5A=&5/;&5$8D-O;FYE8W1I M;VY"=71T;VY?0VQI8VLI.PT*(" [ at ](" [ at ](" [ at ](" [ at ]?0T*(" [ at ](" [ at ](" [ at ](" [ at ] M8V%T8V[ at ][ at ]*$5X8V5P=&EO;B!E*0T*(" [ at ](" [ at ](" [ at ](" [ at ]>PT*(" [ at ](" [ at ](" [ at ] M(" [ at ](" [ at ]($UE<W-A9V5";W[ at ]N4VAO=RAE+DUE<W-A9V4I.PT*(" [ at ](" [ at ](" [ at ] M(" [ at ]?0T*(" [ at ](" [ at ]("!]#0H-"B [ at ](" [ at ](" [ at ]=F]I9"!C<F5A=&53<6Q#;VYN M96-T:6]N0G5T=&]N7T-L:6-K*$-O;6UA;F1"87)"=71T;VX[ at ]0W1R;"P[ at ]<F5F M(&)O;VP[ at ]0V%N8V5L1&5F875L="D-"B [ at ](" [ at ](" [ at ]>PT*(" [ at ](" [ at ](" [ at ](" [ at ] M365S<V%G94)O>"Y3:&]W*")#<F5A=&4[ at ]4W%L0V]N;F5C=&EO;B(I.PT*#0H[ at ] M(" [ at ](" [ at ](" [ at ]("!3>7-T96TN1&%T82Y3<6Q#;&EE;G0N4W%L0V]N;F5C=&EO M;B!C;VYN(#T[ at ];F5W(%-Y<W1E;2Y$871A+E-Q;$-L:65N="Y3<6Q#;VYN96-T M:6]N*"D[#0H[ at ](" [ at ](" [ at ]('T-"[ at ]T*(" [ at ](" [ at ]("!V;VED(&-R96%T94]L941B M0V]N;F5C=&EO;D)U='1O;E]#;&EC:RA#;VUM86YD0F%R0G5T=&]N($-T<FPL M(')E9B!B;V]L($-A;F-E;$1E9F%U;'0I#0H[ at ](" [ at ](" [ at ]('L-"B [ at ](" [ at ](" [ at ] M(" [ at ]($UE<W-A9V5";W[ at ]N4VAO=R[ at ]B0W)E871E($]L941B0V]N;F5C=&EO;B(I M.PT*#0H[ at ](" [ at ](" [ at ](" [ at ]("!3>7-T96TN1&%T82Y/;&5$8BY/;&5$8D-O;FYE M8W1I;VX[ at ]8V]N;B ](&YE=R!3>7-T96TN1&%T82Y/;&5$8BY/;&5$8D-O;FYE ?8W1I;VXH*3L-"B [ at ](" [ at ](" [ at ]?0T*#0H[ at ](" [ at ]?0T*?0`` ` end