ADO ActiveCommand and ActiveConnection Properties

Complete Recordset Object Reference

ActiveCommand

The ActiveCommand property returns a variant that contains the Command object associated with the Recordset object.

Note: If the Recordset object was not created by a Command object, Null is returned.

ActiveConnection

The ActiveConnection property sets or returns a string or variant that contains the Connection object associated with the Recordset object. If the connection is closed, this property sets or returns a definition for a connection.

Syntax

Complete Recordset Object Reference

Altova® MapForce®
Graphical XML Mapping Tool from the Developers of XMLSpy®

Need an easy way to get data into XML, or transform XML to another format? MapForce lets you map XML data to/from any combination of XML, database, flat file, Excel 2007, XBRL, or Web services data. Then it transforms data instantly or auto-generates royalty-free data integration code for recurrent conversions. New features in Version 2010!

Download a free, fully functional 30-day trial to experience the following features: Easy-to-use, graphical data mapping interface Instant data transformation XSLT 1.0/2.0 and XQuery code generation Java, C#, and C++ code generation Advanced data processing functions Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more Visual Studio & Eclipse integration Download a fully-functional trial today!