Database Management/ODBC

This lesson introduces Open Database Connectivity (ODBC).

Objectives and SkillsEdit

Objectives and skills for this lesson include:

  • Understand ODBC concepts
  • Use ODBC to connect front-end applications to a variety of back-end data sources

ReadingsEdit

  1. Wikipedia: Open Database Connectivity

MultimediaEdit

  1. YouTube: Installing a SQL Server ODBC driver

ActivitiesEdit

  1. Install the ODBC driver(s) for your selected database management system:
  2. Configure an ODBC data source to connect to the Northwind database on your selected DBMS.
  3. Select a database application to use for this lesson. LibreOffice Base and Microsoft Access are recommended.
  4. Use your selected database application to connect to your DBMS Northwind database. Run queries against the Northwind database to test connectivity.
  5. Create forms and reports in your selected database application to interact with the DBMS Northwind database.

Lesson SummaryEdit

  • Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS).[1]
  • ODBC was originally developed by Microsoft and Simba Technologies during the early 1990s.[2]
  • ODBC remains in wide use today, with drivers available for most platforms and most databases. It is not uncommon to find ODBC drivers for database engines that are meant to be embedded, like SQLite, as a way to allow existing tools to act as front-ends to these engines for testing and debugging.[3]

Key TermsEdit

device driver
Provides a software interface to hardware devices, enabling operating systems and other computer programs to access hardware functions without needing to know precise details about the hardware being used.[4]
Open Database Connectivity (ODBC)
A standard application programming interface (API) for accessing database management systems (DBMS).[5]

See AlsoEdit

ReferencesEdit