please dont rip this site

Connection Object

A Connection object represents an open connection to an OLE DB data source.


Errors, Properties


Attributes, CommandTimeout, ConnectionString, ConnectionTimeout, DefaultDatabase, IsolationLevel, Mode, Provider, Version


BeginTrans, CommitTrans, RollbackTrans, Close, Execute, Open


You can create Connection objects independently of any other previously defined object.

A Connection object represents a unique session with a data source. In the case of a client/server database system, it may be equivalent to an actual network connection to the server. Depending on the functionality the provider exposes, some collections, methods, or properties of a Connection object may not be available.

Note For information on Microsoft OLE DB providers including the Microsoft ODBC Provider for OLE DB, see the documentation for the Microsoft® OLE DB SDK or visit the Microsoft OLE DB web page.

Using the collections, methods, and properties of a Connection object, you can do the following:

· Configure the connection before opening it with the ConnectionString, ConnectionTimeout, and Mode properties.

· Set the default database for the connection with the DefaultDatabase property.

· Set the level of isolation for the transactions opened on the connection with the IsolationLevel property.

· Select an OLE DB provider with the Provider property.

· Establish, and later break, the physical connection to the data source with the Open and Close methods.

· Execute a command on the connection with the Execute method and configure the execution with the CommandTimeout property.

· Manage transactions on the open connection, including nested transactions if the provider supports them, with the BeginTrans, CommitTrans, and RollbackTrans methods and the Attributes property.

· Examine errors returned from the data source with the Errors collection.

· Read the version from the ADO implementation in use with the Version property.

See Also

Command, Recordset

file: /Techref/language/asp/comp/dadobj01_1.htm, 4KB, , updated: 1996/11/21 19:01, local time: 2022/8/19 22:39,

 ©2022 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE. Questions?
Please DO link to this page! Digg it! / MAKE!

<A HREF=""> Connection Object (ADO)</A>

After you find an appropriate page, you are invited to your to this massmind site! (posts will be visible only to you before review) Just type a nice message (short messages are blocked as spam) in the box and press the Post button. (HTML welcomed, but not the <A tag: Instead, use the link box to link to another page. A tutorial is available Members can login to post directly, become page editors, and be credited for their posts.

Link? Put it here: 
if you want a response, please enter your email address: 
Attn spammers: All posts are reviewed before being made visible to anyone other than the poster.
Did you find what you needed?

  PICList 2022 contributors:
o List host: MIT, Site host, Top posters @20220819
* Page Editors: James Newton, David Cary, and YOU!
* Roman Black of Black Robotics donates from sales of Linistep stepper controller kits.
* Ashley Roll of Digital Nemesis donates from sales of RCL-1 RS232 to TTL converters.
* Monthly Subscribers: Gregg Rew. on-going support is MOST appreciated!
* Contributors: Richard Seriani, Sr.

Welcome to!