C#

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    Console.WriteLine("ServerVersion: {0}", connection.ServerVersion);
    Console.WriteLine("State: {0}", connection.State);
}

C:\>"test sql 2003"<br />
ServerVersion: 08.00.0194<br />
State: Open<br />
<br />
C:\>"test sql 2005"<br />
ServerVersion: 08.00.0194<br />
State: Open

C:\>"test sql 2003"<br />
ServerVersion: 08.00.0194<br />
State: Open<br />
<br />
C:\>"test sql 2005"<br />
<br />
Unhandled Exception: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.<br />
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)<br />
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)<br />
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)<br />
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)<br />
   at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)<br />
<br />
   at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable)<br />
   at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean<br />
trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean<br />
 aliasLookup)<br />
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)<br />
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String  newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)<br />
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)<br />
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)<br />
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owning Object)<br />
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)<br />
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)<br />
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)<br />
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)<br />
   at System.Data.SqlClient.SqlConnection.Open()<br />
   at Test_SQL.Program.Main(String[] args)

shyagam wrote:

BTW... Is anybody else experiencing problem with the site except me (not like the one above)?

shyagam wrote:

Is there a better way?

shyagam wrote:

there should be a way to simply get the address of an object

Bitmap _capturedImage = null;
Brush _redbrush = new SolidBrush(Color.Red);
Brush _blackbrush = new SolidBrush(Color.Black);
Pen _pen = new Pen(_blackbrush);
Point _mousedown = new Point(-1,-1);
Rectangle _captureRect = new Rectangle(_mousedown, 0, 0);
bool _mouseheld = false;
</p>
private void videopanel_MouseDown(object sender, MouseEventArgs e)
{
   _mouseheld = true;
  _mouseDown = e.Location;
}
</p>
private void videopanel_MouseMove(object sender, MouseEventArgs e)
{
   if(_mouseheld)
   {
      videopanel.Refresh();

      Graphics g = videopanel.CreateGraphics();
      Point _mousemove = e.Location;
      g.DrawRectangle(
            _pen,
            _mouseDown.X,
            _mouseDown.Y,
            _mousemove.X - _mouseDown.X,
            _mousemove.Y - _mouseDown.Y);
   }
}
</p>
private void videopanel_MouseUp(object sender, MouseEventArgs e)
{
   _mouseheld = false;
   Graphics g = videopanel.CreateGraphics();
   Point _mouseup = e.Location;

   _captureRect = new Rectangle(
         _mousedown,
         _mouseup .X - _mouseDown.X,
         _mouseup .Y - _mouseDown.Y);

   _pen = new Pen(_redbrush);
   g.DrawRectangle(_pen, _captureRect);
}
</p>
private void CaptureButton_Click(object sender, EventArgs e)
{
   Graphics g = videopanel.CreateGraphics();

   Bitmap _bitmapComplete = new Bitmap(videopanel.Width, videopanel.Height);

   Rectangle _bitmapRect = new Rectangle(
         0,
         0,
         videopanel.Width,
         videopanel.Height);
   
   videopanel.DrawToBitmap(_capturedImage, _bitmapRect);

   _capturedImage = new Bitmap(
          _captureRect.Width,
          _captureRect.Height,
          g);

   g.DrawImage(_bitmapComplete, _bitmapRect,
          _captureRect, GraphicsUnit.Pixel);
}

//Add these two points aswell
private Point _rectstart = new Point(-1,-1);
private Point _rectend = new Point(-1,-1);
</p>
//then rewrite these methods as follows
private void videopanel_MouseMove(object sender, MouseEventArgs e)
{   
	if(mouse_down)
	{
		videopanel.Refresh();

		_pen = new Pen(this._blackbrush);
		Graphics g = this.videopanel.CreateGraphics();
		Point _mousemove = new Point(e.X, e.Y);

		if(_mousemove.X > _mousedown.X &&
		_mousemove.Y > _mousedown.Y)
		{
			_rectstart = new Point(
			   _mousedown.X,         
			   _mousedown.Y);
         
			_rectend = new Point(
			   _mousemove.X,         
			   _mousemove.Y);
		}
		else if(_mousemove.X < _mousedown.X &&
			_mousemove.Y < _mousedown.Y)
		{
			_rectstart = new Point(       
			   _mousemove.X,         
			   _mousemove.Y);
      
			_rectend = new Point(
			   _mousedown.X,         
			   _mousedown.Y);
		}
		else if(_mousemove.X > _mousedown.X &&
			_mousemove.Y < _mousedown.Y)
		{
			_rectstart = new Point(
			   _mousedown.X,         
			   _mousemove.Y);
        
			_rectend = new Point(
			   _mousemove.X,         
			   _mousedown.Y);
		}
		else
		{
			_rectstart = new Point(
			   _mousemove.X,         
			   _mousedown.Y);
    
			_rectend = new Point(
			   _mousedown.X,         
			   _mousemove.Y);
		}

		_captureRect = new Rectangle(         
			_rectstart,         
			new Size(
			_rectend.X - _rectstart.X,         
			_rectend.Y - _rectstart.Y));

		g.DrawRectangle(         
			_pen,         
			_captureRect);

	}
}
</p>		
private void videopanel_MouseUp(object sender, MouseEventArgs e)
{   
	mouse_down = false;

	Graphics g = this.videopanel.CreateGraphics();   
			
	_pen = new Pen(_redbrush);
	g.DrawRectangle(_pen, _captureRect);
}