ODBC

E35619

application programming interface data access standard

ODBC (Open Database Connectivity) is a standard API that enables applications to access and query data from a wide variety of relational and non-relational database management systems using a common interface.

Try in SPARQL Jump to: Surface forms Statements Referenced by

All labels observed (5)

Label	Occurrences
ODBC canonical	14
Open Database Connectivity	2
ODBC specification	1
OLE DB	1
System.Data.Odbc	1

Statements (49)

Predicate	Object
instanceOf	application programming interface ⓘ data access standard ⓘ
abbreviation	ODBC self-link ⓘ
basedOn	Call Level Interface specification ⓘ
category	data access middleware ⓘ database connectivity technology ⓘ
compatibleWith	.NET languages via ODBC providers ⓘ C ⓘ surface form: C programming language C++ ⓘ surface form: C++ programming language Java via JDBC-ODBC bridge (historically) ⓘ
designGoal	database independence for applications ⓘ uniform access to heterogeneous data sources ⓘ
developedBy	Microsoft ⓘ
enables	portability of database applications across DBMS ⓘ
fullName	ODBC self-linksurface differs ⓘ surface form: Open Database Connectivity
hasComponent	ODBC Driver Manager ⓘ ODBC driver ⓘ data source name ⓘ
introducedIn	early 1990s ⓘ
managedBy	ODBC Driver Manager on host system ⓘ
provides	API for connecting to data sources ⓘ API for executing SQL statements ⓘ API for metadata discovery ⓘ API for retrieving query results ⓘ common interface for database access ⓘ
purpose	enable database-independent application development ⓘ provide a standard API for accessing databases ⓘ
relatedTo	ADO.NET ⓘ JDBC ⓘ OLE DB ⓘ
requires	ODBC-compliant driver for each DBMS ⓘ
runsOn	Linux ⓘ Windows ⓘ surface form: Microsoft Windows macOS ⓘ
standardizedBy	Microsoft ⓘ
supports	SQL databases ⓘ non-SQL data sources ⓘ non-relational database management systems ⓘ relational database management systems ⓘ
supportsFeature	connection pooling ⓘ metadata functions ⓘ parameterized queries ⓘ prepared statements ⓘ scrollable cursors ⓘ transactions ⓘ
uses	SQL as primary query language ⓘ connection strings ⓘ data source names ⓘ drivers to communicate with specific DBMS ⓘ

Referenced by (19)

Full triples — surface form annotated when it differs from this entity's canonical label.

Power BI → supportsStandard → ODBC ⓘ

this entity surface form: OLE DB

SQL Server → supportsAPI → ODBC ⓘ

MySQL → supportsInterface → ODBC ⓘ

PostgreSQL → supportsProtocol → ODBC ⓘ

Lotus Domino → supportsStandard → ODBC ⓘ

IBM DB2 → supportsAPI → ODBC ⓘ

subject surface form: IBM Db2

ODBC → fullName → ODBC self-linksurface differs ⓘ

this entity surface form: Open Database Connectivity

ODBC → abbreviation → ODBC self-link ⓘ

OLE DB → relatedTo → ODBC ⓘ

Oracle Autonomous Data Warehouse → supportsInterface → ODBC ⓘ

ODBC Driver Manager → supportsStandard → ODBC ⓘ

this entity surface form: Open Database Connectivity

ODBC Driver Manager → conformsTo → ODBC ⓘ

this entity surface form: ODBC specification

Microsoft Access → supports → ODBC ⓘ

IMS → supportsInterface → ODBC ⓘ

ADO.NET → namespace → ODBC ⓘ

this entity surface form: System.Data.Odbc

.NET (via integration) → supportsProtocol → ODBC ⓘ

Microsoft Jet Database Engine → accessedVia → ODBC ⓘ

Multiple Active Result Sets (MARS) → usedWith → ODBC ⓘ

subject surface form: Multiple Active Result Sets