Chapter 28. Introduction to ODBC

Introduction

A disadvantage of embedded SQL is that only the programming languages for which a precompiler has been developed can be used. Without one, embedded SQL does not work. Usually precompilers are developed by the vendor of the SQL product. However, it is impossible for a vendor to develop a precompiler for every programming language and each development environment—there are just too many of them. This was one of the reasons another approach was considered for processing SQL statements, one that is less dependent on a host language.

The method found was based on the Call-Level Interface (CLI). A CLI is an application programming interface (API), which is a set of functions or routines with clearly defined ...

Get Introduction to SQL: Mastering the Relational Database Language, Fourth Edition/20th Anniversary Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.