Menu
What exactly are ODBC, JDBC and ADO.NET? What are the links between them?
202
What is the difference between ODBC and ADO? ODBC is an open interface, which can be used by any application to communicate with any database system, while ADO is a wrapper around OLE DB (which is the successor to ODBC). If the database does not support OLE (non-OLE environments) then ODBC is the best choice.
To access an ODBC data source using ADO.NET, use the . NET Framework Data Provider for ODBC.
There is no speed advantage inherent to ODBC vs ADO.NET, but there is some speed loss for such bridged solutions, due to the extra layer of API translation.
But as the number of records were increased, Java(JDBC) came out as the winner. The reason that I thought of is that may be the ODBC drivers load much faster than JDBC but the access speed of JDBC is better than ODBC, hence, such results.
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.
170
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.
39
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
