CODEWITHSUNDEEP
.netdatabase
Bastien Vandamme
Bastien Vandamme

Reputation: 18485

ODBC vs JDBC vs ADO.NET

What exactly are ODBC, JDBC and ADO.NET? What are the links between them?

Upvotes: 25

Views: 18680

Answers (2)

Reed Copsey
Reed Copsey

Reputation: 564891

These are all different data access technologies.

ODBC is an (older) open standard. It's designed to be database and technology neutral. JDBC and ADO.NET can both actually use ODBC internally as a provider, if requested.

JDBC is a similar concept, but designed to be a standard for Java.

ADO.NET is a .NET data access technology.

Upvotes: 22

SLaks
SLaks

Reputation: 888223

ODBC (Open Database Connectivity) is a standard API that can be used to communicate with databases.

JDBC (Java Database Connectivity) is a Java standard that can be used to communicate with databases.

ADO.Net is a .Net standard that can be used to communicate with databases.

Individual databases, such as SQL Server or MySQL, have drivers that implement each of these APIs.

In addition, there are ODBC implementations for JDBC and ADO.Net that allow them to use ODBC drivers.

Upvotes: 14

Related Questions