Easysoft ODBC-ODBC Bridge User's Guide - Glossary

Terms and definitions

API

    Application Programmer Interface. An API is a published set of function calls and constants allowing different programmers to utilize a ready-written library of subroutines.

Application

    An Application Program ("Application" or "App") is a program that applies the computer to solving some real-world problem. In ODBC terms, it is the program connecting to the data source.

Authorization code

    You must have an authorization code for the Easysoft product you wish to license in order to obtain a purchased license. When you purchase a product your authorization code is emailed to you. You do not need an authorization code to obtain a trial license.

Bitmask

    A value which, when written out in binary, has a meaning assigned to each digit, which can be 0 or 1. This is a very efficient way of storing a number of flags in a small amount of memory.

    When viewed in decimal it is a single number resulting from adding up the values of the individual bits. The bits are worth 1, 2, 4, 8, 16, 32 and so on.

Client/Server

    The name given to the architecture whereby one process (the server) keeps track of global data, and another task (the client) is responsible for formatting and presenting the data. The client requests queries or actions be performed on the data by the server. Often these processes run on different hosts across a local-area network.

Column

    The vertical dimension of a table. Columns are named and have a domain (or type). The term column might refer to only the definition of a column (i.e. its name and type), or to all the data in it.

Connection String

    ODBC driver managers accept a connection string when a client connects. Ideally it contains all necessary attribute values to make the connection to a data source, but provision is made for the driver to negotiate with the application or the user for any missing information.

Data Source

    In ODBC terms, a data source is a database or other data repository coupled with an ODBC Driver, which has been given a Data Source Name (see DSN) to identify it to the ODBC Driver Manager.

DLL

    Dynamic Link Library. Windows' mechanism for shared object code. See also Shared Object.

Download

    The transfer of data from a remote machine (on the internet, for example) to your local machine. Mechanisms for achieving this include FTP and the World Wide Web.

Driver

    See ODBC driver.

Driver Manager

    Software whose main function is to load ODBC drivers. ODBC applications connect to the Driver Manager and request a DSN. The Driver Manager loads the driver specified in the DSN's configuration file. In Windows, the ODBC Data Source Administrator is used to set up the Driver Manager.

DSN

    Data Source Name. This is a name associated with an ODBC data source. Driver Managers, such as unixODBC or the Microsoft Windows Driver Manager, use the Data Source Name to cross-reference configuration information and load the required driver.

Field

    A placeholder for a single datum in a record, for example you can have a Surname field in a Contact Details record. Called a cell in Microsoft Access.

Flags

    Single-bit values, representing `Yes' or `No'. When more than one flag is present, they are normally stored in a bitmask.

Host

    A computer visible on the network.

HTTP

    HyperText Transfer Protocol. The means of transferring web pages.

HTTPAdmin

    An NT user name, valid on the machine the server is running on. This is the only user allowed to amend settings, or display certain items, through theWeb Administrator.

Middleware

    Software that is placed between the client and the server to improve or expand functionality.

ODBC (Open DataBase Connectivity)

    A standard API for connecting application programs to relational database systems through a suitable driver. ODBC is available on a wide number of platforms and the Easysoft ODBC-ODBC Bridge allows the database and the application to reside on different machines across the network.

ODBC driver

    Software that accesses a proprietary data source, providing a standardized view of the data to ODBC.

Operating System

    A collection of software programs, APIs and working practices that control and integrate the execution of system functions on behalf of application programs.

Platform

    The term platform normally covers the hardware and operating system as a unit. For example; a PC running Microsoft Windows, a PC running BSD Unix, and a Sun running Solaris are three different platforms.

Server

    A computer, or host, on the network, designed for power and robustness rather than user-friendliness and convenience. Servers typically run round-the-clock and carry central corporate data.

¯ OR ¯

    A process performing the centralized component of some task, for example extracting information from a corporate database. See Client/Server.

Shared Object

    A piece of object code (i.e. a program fragment) for loading and executing by other programs.

SQL (Structured Query Language)

    A standard language for interacting with relational database systems, based on Relational Theory.

System Data Source

    In the context of ODBC under Microsoft Windows, a data source which can be accessed by any user on a given system. See also User Data Source.

Table

    A data set in a relational database, composed of rows and columns.

    For example, the following table has two columns (vendor and name) and two rows (one for the Easysoft ODBC-ODBC Bridge and the other for MySoft's ODBC client software) :

software
vendor name
Easysoft Easysoft ODBC-ODBC Bridge
MySoft My ODBC Client Application

    The term table can also apply to just the definition of the table, without its data.

User Data Source

    An ODBC Data Source with access limited to a specific user on a given system. See also System Data Source.

Web Administrator

    The OOB Server under Windows runs a simple web server which can be used to display and amend certain server statistics and parameters.


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.