cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Diff between JDBC & ODBC

Former Member
0 Likes
3,098

hi,,

What is the difference between JDBC and ODBC

thanks

guna

View Entire Topic
Former Member
0 Likes

Hello Guna,

ODBC

ODBC is a multidatabase API for programs that use SQL statements to access data. An ODBC-based program can access heterogeneous databases without needing source code changes-one program can retrieve and store content in different vendors' databases via the ODBC interface. ODBC thus provides database-neutral delivery of both SQL and database content. Be aware, however, that you must load ODBC driver software for each vendor's database you want to access.

JDBC

JDBC is a collection of database access middleware drivers that provide Java programs with a call-level SQL API. Java applets and applications can use the drivers' API to connect to databases, store and retrieve database content and execute stored procedures, thus making JDBC a Java-enabled delivery mechanism for SQL. JDBC is to Java programs what ODBC is to programs written in languages other than Java. In fact, JDBC's design is based on ODBC's

Regards

Prasad