Components of an ODBC connection

How an ODBC connection is made

When you access an ODBC data source in PowerBuilder, your connection
goes through several layers before reaching the data source. It
is important to understand that each layer represents a separate
component of the connection, and that each component might come
from a different vendor.

Because ODBC is a standard API, PowerBuilder uses the same interface
to access every ODBC data source. As long as a driver is ODBC compliant, PowerBuilder can
access it through the ODBC interface to the ODBC Driver Manager.
The development environment and the ODBC interface work together
as the application component.

Figure 2-1 shows
the general components of an ODBC connection.

Figure 2-1: Components of an ODBC connection

Component descriptions

Table 2-1 gives
the provider and a brief description of each ODBC component shown
in the diagram.

Table 2-1: Provider and function of ODBC
connection components
Component	Provider	What it does
Application	Sybase	Calls ODBC functions to submit SQL statements, catalog requests, and retrieve results from a data source. PowerBuilder uses the same ODBC interface to access all ODBC data sources.
ODBC Driver Manager	Microsoft	Installs, loads, and unloads drivers for an application.
Driver	Driver vendor	Processes ODBC function calls, submits SQL requests to a particular data source, and returns results to an application. If necessary, translates an application’s request so that it conforms to the SQL syntax supported by the back-end database. See “Types of ODBC drivers”.
Data source	DBMS or database vendor	Stores and manages data for an application. Consists of the data to be accessed and its associated DBMS, operating system, and (if present) network software that accesses the DBMS.

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 15.0

August 20, 2023

Was this article helpful?