ado_ref_connection.asp

W3Schools tutorial..web designing

  <tr>
    <td valign="top"><a href="met_conn_begintrans.asp">BeginTrans</a></td>
    <td valign="top">Begins a new transaction</td>
  </tr>
  <tr>
    <td valign="top"><a href="met_conn_cancel.asp">Cancel</a></td>
    <td valign="top">Cancels an execution</td>
  </tr>
  <tr>
    <td valign="top"><a href="met_conn_close.asp">Close</a></td>
    <td valign="top">Closes a connection</td>
  </tr>
  <tr>
    <td valign="top"><a href="met_conn_begintrans.asp">CommitTrans</a></td>
    <td valign="top">Saves any changes and ends the current transaction</td>
  </tr>
  <tr>
    <td valign="top"><a href="met_conn_execute.asp">Execute</a></td>
    <td valign="top">Executes a query, statement, procedure or provider specific
      text</td>
  </tr>
  <tr>
    <td valign="top"><a href="met_conn_open.asp">Open</a></td>
    <td valign="top">Opens a connection</td>
  </tr>
  <tr>
    <td valign="top"><a href="met_conn_openschema.asp">OpenSchema</a></td>
    <td valign="top">Returns schema information from the provider about the data
      source</td>
  </tr>
  <tr>
    <td valign="top"><a href="met_conn_begintrans.asp">RollbackTrans</a></td>
    <td valign="top">Cancels any changes in the current transaction and ends the
      transaction</td>
  </tr>
</table>

<h3>Events</h3>
<p><b>Note:</b>&nbsp; You cannot handle events using VBScript or JScript (only Visual Basic, Visual C++, and Visual J++ languages can handle
events).</p>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
  <tr valign="top">
    <th width="30%" align="left" valign="top">Event</th>
    <th width="70%" align="left" valign="top">Description</th>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="ev_conn_transcomplete.asp">BeginTransComplete</a></td>
    <td valign="top">Triggered after the BeginTrans operation</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="ev_conn_transcomplete.asp">CommitTransComplete</a></td>
    <td valign="top">Triggered after the CommitTrans operation</td>
  </tr>
  <tr>
    <td valign="top"> <a href="ev_conn_connect.asp"> ConnectComplete</a></td>
    <td valign="top">Triggered after a connection starts</td>
  </tr>
  <tr>
    <td valign="top"> <a href="ev_conn_connect.asp"> Disconnect</a></td>
    <td valign="top">Triggered after a connection ends</td>
  </tr>
  <tr>
    <td valign="top"> <a href="ev_conn_execute.asp"> ExecuteComplete</a></td>
    <td valign="top">Triggered after a command has finished executing</td>
  </tr>
  <tr>
    <td valign="top"> <a href="ev_conn_infomessage.asp"> InfoMessage</a></td>
    <td valign="top">Triggered if a warning occurs during a ConnectionEvent
      operation</td>
  </tr>
  <tr>
    <td valign="top"> <a href="ev_conn_transcomplete.asp"> RollbackTransComplete</a></td>
    <td valign="top">Triggered after the RollbackTrans operation</td>
  </tr>
  <tr>
    <td valign="top"><a href="ev_conn_connect.asp">WillConnect</a></td>
    <td valign="top">Triggered before a connection starts</td>
  </tr>
  <tr valign="top">
    <td valign="top"><a href="ev_conn_execute.asp">WillExecute</a></td>
    <td valign="top">Triggered before a command is executed</td>
  </tr>
</table>
<h3>Collections</h3>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
  <tr valign="top">
    <th width="30%" align="left" valign="top">Collection</th>
    <th width="70%" align="left" valign="top">Description</th>
  </tr>
  <tr>
    <td valign="top">Errors</td>
    <td valign="top">Contains all the Error objects of the Connection object</td>
  </tr>
  <tr>
    <td valign="top">Properties</td>
    <td valign="top">Contains all the Property objects of the Connection object</td>
  </tr>
</table>
<br />
<hr />
<a href="ado_ref_command.asp"><img border="0" alt="previous" src="../images/btn_previous.gif" width="100" height="20" /></a>
<a href="ado_ref_error.asp"><img border="0" alt="next" src="../images/btn_next.gif" width="100" height="20" /></a>

<br />
<hr />

<!-- **** SPOTLIGHTS 1 **** -->

<iframe src="../banners/aspallframe.asp" height="110" width="485"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
<hr />
<!-- **** SPOTLIGHTS 2 **** -->


<!-- **** SPOTLIGHTS 3 **** -->
<table cellpadding="0" cellspacing="0"><tr><td width="72"></td><td>
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*txt*/
google_ad_slot = "1699448869";
google_ad_width = 336;
google_ad_height = 280;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td></tr></table>
<hr />

<center>

<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*imgtxt*/
google_ad_slot = "8606855891";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>

</center>
<hr />


<!-- **** END SPOTLIGHTS **** -->

</td></tr>

<tr><td>
<p>Jump to: <a href="#top" target="_top"><b>Top of Page</b></a>
or <a href="../default.asp" target="_top"><b>HOME</b></a> or
<a href='ado_ref_connection.asp@output=print' target="_blank">
<img src="../images/print.gif" alt="Printer Friendly" border="0" />
<b>Printer friendly page</b></a></p>
<p>W3Schools provides material for training only. We do not warrant the correctness of its contents.
The risk from using it lies entirely with the user.
While using this site, you agree to have read and accepted our
<a href="../about/about_copyright.asp">terms of use</a> and
<a href="../about/about_privacy.asp">privacy policy</a>.
</p>
<p><a href="../about/about_copyright.asp">Copyright 1999-2008</a> by Refsnes Data. All Rights Reserved.</p>
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr>
<td width="60%" align="left">
<a href="../../validator.w3.org/check@uri=referer" target="_blank">
<img src="../images/vxhtml.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../jigsaw.w3.org/css-validator/check@uri=referer" target="_blank">
<img src="../images/vcss.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../www.w3.org/WAI/WCAG1A-Conformance" title="Explanation of Level A Conformance" target="_blank">
<img src="../images/wai.gif" alt="W3C-WAI level A conformance icon" width="88" height="31" border="0" /></a>
</td>
<td>
<a href="../xhtml/xhtml_howto.asp" target="_top">W3Schools was converted to XHTML in December 1999</a>
</td></tr>

</table>
</td></tr>
</table>
</td>


<td width="145" align="center" valign="top">




<iframe style="background-color:#f1f1f1" src="../banners/rightcolumn.asp@secid=ado" height="1850" width="147"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
</iframe>

</td>
</tr></table>

</body>
</html>