Welcome to the ADODB Programming Reference guide. This is an informative reference source that documents all of the properties, collections, methods, and events for the nine ADO (ActiveX Data Objects) objects. Note that two new objects, Record and Stream, were added to ADO with version 2.5.
Microsoft introduced ADO to the world during the winter of 1996. From the inception, ADO was designed to be a high-level interface to provide ease of access to data stored in a wide variety of database sources. The earlier versions of ADO could only access relational databases with fixed columns and data types. However, since the release of version 2.5, ADO is now able to interface not only with relational databases, but also with non-relational databases, folders, data files, and even e-mail messages. For example, ADO can now handle data that are contained in a tree-like structure with a root, nodes, and leaves. It can also handle data where the number of columns and the data type vary from row to row. This represents a significant improvement in the usefulness and value of ADO.
The recent release of ADO 2.6 (and now 2.7) has extended this scope even farther to support the use of XML in conjunction with SQL Server 2000. This added capability allows the Stream object to contain not only an XML command that can then be executed against SQL Server 2000, but also XML data returned as a result of a query. This latest release also offers improved performance of commands that only return a single row and more detailed information to help with errors.
In ADO 2.6 and greater, the Command object has gained three new properties, CommandStream, Dialect, and NamedParameters. The Parameter and Record objects both now support a Properties Collection. Also note that the Status property is now filled with information to help with the 'Errors Occurred' error. Check it out.
The key to this newly-found versatility is the component-based technology of OLE DB. OLE DB was conceived by Microsoft as an answer to the expanding needs of the Internet and e-commerce. Microsoft has an ultimate goal of universal data access and OLE DB represents an important evolutionary step towards reaching that goal.
ADO can be used with a variety of programming languages, including Visual Basic, VBScript, JScript, Visual C++, and Visual J++. Further, by using ASP, you can reference ADO components on HTML-generated Web pages. ADO is fully integrated with TRADIUM's Basic Script programming language. Also, specific powerfull operations can be made by using a combination of ADO and TRADIUM's
SQL Objects.
ADO is an important technology with which all developers should be familiar.
Besides the nine main
objects that ADO contains, there are four main
collections. Defining them in Basic Script is easy, due to the
autocompletion feature in Basic Script's IDE: Just type a dot (.) after the keyword "ADODB" and a large range of properties, collections, methods and events appear. This is how you should declare the main objects and collections: