Kbase P66720: What is an ODBC?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/9/2004 |
|
Status: Unverified
GOAL:
What is an ODBC?
FIX:
ODBC is a database connectivity architecture that provides a way for clients to access a variety of heterogeneous databases. The latest version, ODBC 3.0, is based on the CLI (Call-Level Interface) specifications from X/Open and ISO/IEC for database APIs. ODBC uses a single programming interface that is open and not tied to any vendor's database. Microsoft developed ODBC and has continued to develop it as a standard.
ODBC uses the following features:
1. Uses of SQL for DB access operations.
2. Contains a library of Functions/Calls for DB data access. The Functions can be used thru SQL.
3. Clients doesn't need to know the DB location, DB type or communication method to access it.
4. ODBC Applications have universal access to a DB that has an ODBC Driver written for it. (Those DB are called Data Sources).
5. Because every DBMS have his own functions, The ODBC API was designed to let know the application what functions are available for a particular DB.