ActiveX Data Objects
A set of Component Object Model (COM) objects that provides an easy-to-use, scriptable interface to data sources
Auto and Immediate windows
The Autos window displays the values of variables that are within the scope of currently executing procedures. The Immediate window shows the results of debug statements running in the code, or that you type in directly.
Need a definition
High-volume servers often operate in clusters. This way, more than one computer can handle many users. From the user's point of view, the cluster appears to be a single fast computer.
An object used to execute queries.
comparison and logical operators
Characters used to form expressions. Comparison operators compare two values or expressions. Logical operators, sometimes called Boolean operators, produce a logical TRUE/FALSE result.
An Active Data Object that is used to establish and maintain connections to data sources.
Uses data. ADO and VBScript are data consumers.
Contains and exposes data to data consumers, such as a database, spreadsheet, etc.
This refers to storing data on a remote server. The data is accessed across a network. The remote data server could be in the same room or building as the client or even in a different country.
Data Source Name (DSN)
A term for the information used to connect an application to an ODBC database.
A variable or field attribute that specifies the kind of data it can hold.
A data-bound DTC is associated with a specific data item. DTCs are not data-bound until this is done. For example, you can drag a DTC onto a page, but it isn't bound to anything until it's properties are set
An application that primarily involves database access.
The mode of operation when the application is being written.
direct connection string
A string that selects a database by file name instead of using an ordinary DSN.
Distributed Component Object Model
An extension of the Component Object Model that allows communication between objects on different computers.
A location in a database record where a data element is stored, also called a column.
floating point data type
A single precision number containing a sign bit and a 23-bit mantissa.
Used in Web pages to display information, also referred to as HTML elements.
A function provided by the Hypertext Transfer Protocol to request an action of the Web server.
Commonly used to set initial values of variables, properties, and so on. Initialization code can be executed as soon as the Web
page is loaded to make global settings, or in a function or procedure to make local settings.
Provides access to an application, objects, hardware, etc.
To execute program statements zero or more times in a loop structure.
The process of generating a result set by matching rows from two or more database tables.
In the context of this course, refers to the association between the application and the datasource.
Software layer that enables communication between the application and the database.
Storage that is not directly accessible. For example, optical juke boxes and tape drives are examples of offline volumes.
OLE Automation Client
An application that accesses objects exposed by another application.
When a system operates redundantly, two or more computers perform the same function. This way, if a failure occurs, the
surviving system can continue operation unimpeded.
Similar to a join, except that all rows from one table will appear in the result set, even if there are no corresponding rows
in other tables.
A script object that lets you treat active server pages as an object.
A database in use in the production environment
This means to use a programming logic and code to get data from a data source.
When a field name is ambiguous, that is it appears in more than one table, you must qualify which field you want to use by
prefixing the appropriate table name and a period before the field name.
This is a VBScript variable that is used to hold SQL statements.
An Active Data Object that it used to retrieve, modify, display, and navigate recordsets.
A database that is organized and accessed based on relationships between tables, rows, and columns.
Debugging processes or scripts that are executed on a remote computer.
The mode of operation when the application is running.
script language engine
A software component that interprets a scripting language.
Is a special type of application that can be automatically started when the machine is booted, or can be started manually by the user
Consists of statements that allow you to query databases from your applications.
Used to provide more specific instructions in a statement.
A database object, such as a query that can be executed.
Stored procedures are like little programs stored in the database and executed on command.
The different data types represented by the variant type.
swap space or swap file
Disk space used by the operating system to temporarily remove information from main memory.
The rules used to form a statement.
A stored procedure that is automatically executed when SQL modification statement occurs, such as insert, delete, and modify.
A column value that is unique to each row.
The data type for all variables that aren't explicitly declared as a specific type.
A database object that appears to be a table, but is really the result of a predefined query.