title: Pooling:more than one connection to a database
body: <p>I have a doubt that whether Pooling actually works with vb.net.
  I used below query to check the connection to the database from different pc.</p>
  
  <pre><code>SELECT hostname,p.status,[program_name],loginame,name
  FROM Master..sysprocesses  as p join master.dbo.sysdatabases as  d on p.dbID = d.dbID
  WHERE p.ecid=0 and p.hostname&lt;&gt;'' 
  order by name
  </code></pre>
  
  <p>In the output i saw more than one connection from a pc to the same database.</p>
  
  <p>So i got doubt about this.In my vb.net application i open connection only once so i was thinking like the connection will be used from same pool,so there will be only one open connection to a database from a PC.</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I have a vb.net application which makes use of connection to SQL server databases. </p>
  
  <ol>
  <li><p>If i open a multiple instances of same program then connection will be drawn from same pool or different pool? </p></li>
  <li><p>If we open different exe but both open connection to same databases then same connection pool will be used by both?</p></li>
  </ol>
  
  <p>When we run query in SQL server many connections are shown to same DB from same PC.</p>