Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN: 9781285196145
Author: Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher: Cengage Learning
bartleby

Concept explainers

Question
Chapter 14, Problem 5RQ
Program Plan Intro

Open Database Connectivity (ODBC):

  • Open database connectivity is an Application Programming Interface (API) used to access the Database Management System (DBMS).
  • It has the ability of accessing the relational data sources using Structured Query Language (SQL) on any application platform.

Data Source Name (DSN):

  • The data source name is used for describing the data source.
  • It is used to describe the structure of the current data source.
  • It includes attributes like
    • Name of the data source
    • Location of the data source
    • ID and password related to data access
    • Information about the database driver
  • It includes four different types namely, Machine DSNs, File DSNs, System DSNs and User DSNs.

Blurred answer
Students have asked these similar questions
Describe the process by which an application connects to a database using ODBC.
Explain how ODBC, OLE DB, and ADO are related.
What is ODbc, and how is it used?
Knowledge Booster
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
  • Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781285196145
    Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
    Publisher:Cengage Learning
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781305627482
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning
  • Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781285196145
    Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
    Publisher:Cengage Learning
    Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781305627482
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning