Database

		private void ExecuteCommand_ConnTest_process()<br />
		{<br />
			ArrayList conn = new ArrayList(3000);<br />
			int num = 0;<br />
<br />
			string conn_s = "...";<br />
			conn_s += "Connect Timeout=600;Max Pool Size=1000000;";<br />
<br />
			try<br />
			{<br />
				while ( true ) <br />
				{<br />
					conn.Add(new SqlConnection(conn_s));<br />
					((IDbConnection)conn[num]).Open();<br />
					num ++; <br />
					Thread.Sleep(10);<br />
				}<br />
			}<br />
			catch( InvalidOperationException ioexp )<br />
			{<br />
				StringBuilder buildError = new StringBuilder();<br />
				buildError.Append( "InvalidOperationException thrown when trying to connect "  );<br />
				buildError.Append( ", error given = " + ioexp.Message);<br />
                             MessageBox.Show(builderError.ToString());<br />
			}<br />
			catch ( Exception e ) <br />
			{<br />
				StringBuilder buildError = new StringBuilder();<br />
				buildError.Append( "Exception thrown when trying to connect "  );<br />
				buildError.Append( ", error given = " + e.Message );<br />
<br />
                             MessageBox.Show(builderError.ToString());<br />
			}<br />
			finally<br />
			{<br />
                             MessageBox.Show(builderError.ToString());<br />
			}<br />
		}

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)