Visual Basic Concepts

Using an rdoConnection Object

Once the rdoConnection object is created, you can use it to:

• Add stand-alone rdoConnection objects to a specific rdoEnvironment transaction scope by using the Add method against a selected rdoConnections collection.
  
  
• Create rdoResultset or rdoQuery objects using the OpenResultset or CreateQuery method, respectively.
  
  
• Execute action queries to update database data, modify the schema, or perform administrative functions.
  
  
• Execute stored procedures and manage their result sets, output parameters, and return values.
  
  
• Disconnect from the data source and free its resources using the Close method against the rdoConnection object.

Note that the rdoConnection object does not set the scope for transactions; this is maintained at the rdoEnvironment level. You cannot use the transaction methods like BeginTrans, CommitTrans, or RollbackTrans against the rdoConnection object — just a specific rdoEnvironment object.