ODBC aligns with the following specifications and standards that deal with the Call-Level Interface (CLI). (The ODBC features are a superset of each of these standards.)
* The Open Group CAE Specification “Data Management: SQL Call-Level Interface (CLI)”
* ISO/IEC 9075-3:1995 (E) Call-Level Interface (SQL/CLI)
As a result of this alignment, the following are true:
* An application written [...]
Many misconceptions about ODBC exist in the computing world. To the end user, it is an icon in the Microsoft® Windows® Control Panel. To the application programmer, it is a library containing data access routines. To many others, it is the answer to all database access problems ever imagined.
First and foremost, ODBC is a specification [...]
Historically, companies used a single DBMS. All database access was done either through the front end of that system or through applications written to work exclusively with that system. However, as the use of computers grew and more computer hardware and software became available, companies started to acquire different DBMSs. The reasons were many: People [...]
This tab displays information about the ODBC core components, including the Driver Manager, the cursor library, the installer .dll file, and other files that constitute the core components.
The table below describes the controls on the About tab.
Core component list Displays the description, version, file name, and location of each ODBC core component.
OK Closes the ODBC [...]
Connection pooling enables an ODBC application to reuse a connection from a pool of connections. Use this tab to alter the connection retry wait time and time-out period for a selected driver when using connection pooling. You can also enable and disable performance monitoring, which records a number of connection statistics.
The table below describes the [...]
This tab specifies how the ODBC Driver Manager traces calls to ODBC functions. Tracing is performed by a trace DLL that captures calls between the Driver Manager and either the application or the driver, and then records them in a log file. The Driver Manager can:
• Trace calls continuously or for one connection only
• Perform [...]
This tab displays information about the ODBC drivers installed on your computer. No action can be performed from this tab. You must use the specific driver setup program to add or remove ODBC drivers.
The table below describes the controls on the Drivers tab.
ODBC Drivers Displays the name, version, company, file name, and file creation date [...]
Use this tab to add, delete, or set up file-based data sources that can be shared among all users who have the same drivers installed. These data sources don’t need to be user-dedicated or local to a computer.
The table below describes the controls on the File DSN tab.
File Data Sources Displays all file data source [...]
Use this tab to add, delete, or set up data sources with system data source names (DSNs). These data sources are local to a computer but not user-dedicated. Any user with the correct permissions can access a system DSN.
The table below describes the controls on the System DSN tab.
System Data Sources Lists all system DSNs, [...]
Use this tab to add, delete, or set up data sources with user data source names (DSNs). These data sources are local to a computer and accessible only by the current user.
Below describes the controls on the User DSN tab.
User Data Sources Lists all user DSNs, including the name and associated driver of each. Double-clicking [...]