add [an ODBC data source]
Make a data source available to ODBC through the Add operation of the ODBC Administrator utility. Adding a data source tells ODBC where a specific database resides and which ODBC driver to use to access it. Adding a data source also invokes a setup dialog box for the particular driver so you can provide other details the driver needs to connect to the database.
The default owner name for all system tables in a c-treeACE SQL database. Users must qualify references to system tables as ADMIN.tablename.
Generally, in client/server systems, the part of the system that sends requests to servers and processes the results of those requests.
c-treeACE SQL environment
An open database created by the combination of c-treeACE SQL layered on top of the c-treeACE Server.
See ODBC data source
delete [an ODBC data source]
Remove information about an ODBC data source through the Delete operation of the ODBC Administrator utility. Deleting a data source does not delete the database it corresponds to, but removes information about the database's location from the ODBC.INI file or registry key.
Names in SQL statements enclosed in double quotation marks (“”). Enclosing a name in double quotation marks preserves the case of the name and allows it to include reserved words and special characters. Subsequent references to a delimited identifier must also use enclosing double quotation marks.
Microsoft-supplied utility to add and delete ODBC data sources and drivers. The Administrator maintains two files (or registry keys).
Any program that calls ODBC functions and uses them to issue SQL statements. Many vendors have added ODBC capabilities to their existing Windows-based tools.
ODBC data source
In ODBC terminology, a specific combination of a database system, the operating system it uses, and any network software required to access it. Before applications can access a database through ODBC, you use the ODBC Administrator to add a data source -- register information about the database and an ODBC driver that can connect to it -- for that database. More than one data source name can refer to the same database, and deleting a data source does not delete the associated database.
Vendor-supplied software that processes ODBC function calls for a specific data source. The driver connects to the data source, translates the standard SQL statements into syntax the data source can process, and returns data to the application.
ODBC driver manager
A Microsoft-supplied program that routes calls from an application to the appropriate ODBC driver for a data source.
The fundamental element in SQL syntax. Query expressions specify a result table derived from some combination of rows from the tables or views identified in the FROM clause of the expression. Query expressions are the basis of SELECT, DECLARE CURSOR, CREATE VIEW, and INSERT statements
Another term for result table.
A temporary table of values derived from columns and rows of one or more tables that meet conditions specified by a query expression.
The core internal component of c-treeACE SQL. The SQL engine receives requests from the c-treeACE SQL ODBC driver, processes them, and returns results.
A virtual table that recreates the result table specified by a SELECT statement. No data is stored in a view, but other queries can refer to it as if it were a table containing data corresponding to the result table it specifies.