What is ODBC

What is ODBC

What is Java ODBC and JDBC?

View Answers

February 25, 2008 at 12:50 PM



Method of type one driver is
Java prog.
|
JDBC Driver
|
ODBC Driver
|
Data base


Odbc drivers are written using Pointers concept in C language. Java does not support pointers concept.

In this case calls to data base are first received by JDBC driver. Then it will convert these calls to function calls understandable by ODBC driver (In terms of pointer concepts). These calls will be sent to the data base.

February 25, 2008 at 1:34 PM

ODBC

ODBC (Open Data Base Connectivity) is basically an interface that provides a common API to deal with the ODBC compliant database management systems. The designers of ODBC tried to make it independent of programming languages, database systems, and operating systems. The application developed by using ODBC driver will be able to store data into any database management system that is equipped with an ODBC driver.
ODBC drivers are often developed in sub-components:

· An ODBC Driver Manager
· ODBC Drivers

The application asks to the ODBC driver manager to call to an appropriate ODBC driver.

The ODBC driver manager choose the appropriate ODBC driver from all the registered driver with that ODBC driver manager, loads that driver, and sends read or write requests using that driver.
The ODBC driver calls the ODBC function, submits the SQL requests to the database, and returns the results to the application.

Thanks
Regards Roseindia











Related Tutorials/Questions & Answers:
What is ODBC - JDBC
What is ODBC  What is Java ODBC and JDBC?   Method of type... | ODBC Driver | Data base Odbc drivers
odbc - Java Beginners
What is odbc connection  What is odbc connection
Advertisements
Java Jdbc-odbc
Java Jdbc-odbc  What is the difference between JDBC and ODBC
Java JDBC ODBC
Java JDBC ODBC  What is the difference between JDBC and ODBC
ODBC connection
ODBC connection   import java.sql.*; import java.util.*; public class OJDBCAvi { public static void main(String args[])throws Exception... ODBC program,bt here I am getting error i.e Exception in Thread "main
ODBC connection
ODBC connection   import java.sql.*; import java.util.*; public class OJDBCAvi { public static void main(String args[])throws Exception... ODBC program,bt here I am getting error i.e Exception in Thread "main
ODBC connection
ODBC connection   import java.sql.*; import java.util.*; public class OJDBCAvi { public static void main(String args[])throws Exception... ODBC program,bt here I am getting error i.e Exception in Thread "main
jdbc odbc
jdbc odbc   i have two tables in database 1table's attribute is foreign key of another in this case how to retrive value from both table and show in a gridview combine using java code   Sql query to retrieve values
jdbc odbc
= DriverManager.getConnection("jdbc:odbc:swing"); String sql = "INSERT
JDBC-ODBC
JDBC-ODBC  HI what should i give names for DNS and TNS in Administrative Tools so that there will be connection between Database (oracle) and java.Actually how to operate Administrative Tools
JDBC-ODBC
JDBC-ODBC  HI what should i give names for DNS and TNS in Administrative Tools so that there will be connection between Database (oracle) and java.Actually how to operate Administrative Tools
The JDBC-ODBC Bridge.
The JDBC-ODBC Bridge.  Are there any ODBC drivers that do not work with the JDBC-ODBC Bridge
jdbc odbc connection
jdbc odbc connection  i need a program in java which uses a jdbc odbc connection   Hi, You can create odbc datasource on your windows computer and then access in your Java program.ADS_TO_REPLACE_1 Read the JDBC ODBC
odbc MS EXCEL
odbc MS EXCEL  hey my whole database is stored in MS Excel. so please tell me that can we connect to that database. if yes, how to do that. please help me out i am doing it in netbeans can please tell me the steps
JDBC-ODBC Bridge multi-threaded.
JDBC-ODBC Bridge multi-threaded.  Is the JDBC-ODBC Bridge multi-threaded
JDBC ODBC related problem
JDBC ODBC related problem  i WANT HELP RELATED TO JDBC CONNECTIVITY WITH MS ACCESS.. HERE IS MY FULL CODE... import java.awt.Container; import... con; con = DriverManager.getConnection("jdbc:odbc:Digambar
JDBC-Odbc Connection
JDBC-ODBC Connection       JDBC-ODBC Connection is a JDBC driver that translates the operation in  JDBC into ODBC. For ODBC,it is a normal java application program. This bridge
jdbc odbc sql server exception
jdbc odbc sql server exception  Hi, I am trying to use sql server with java jdbc odbc but I am getting this exception java.sql.SQLException: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '@P1
JDBC ODBC Connection In Java
JDBC ODBC Connection In Java In this section we will read about the various aspects of JDBC ODBC such as, JDBC-ODBC bridge, JDBC ODBC connection, how to create DSN etc. JDBC-ODBC Bridge As its name JDBC-ODBC bridge, it acts like
PHP SQL ODBC
PHP SQL ODBC       This example illustrates how to create an ODBC Connection for php application. Follow the given steps to create an ODBC connection to a MS Access Database: 
JDBC-Odbc Connectivity
JDBC-ODBC Connectivity       The code illustrates an example from JDBC-ODBC...;static private final String connection = "jdbc:odbc
ModuleNotFoundError: No module named 'odoo8-addon-import-odbc'
ModuleNotFoundError: No module named 'odoo8-addon-import-odbc'  Hi...: No module named 'odoo8-addon-import-odbc' How to remove the ModuleNotFoundError: No module named 'odoo8-addon-import-odbc' error? Thanks   
how to set fetch size for jdbc odbc driver
how to set fetch size for jdbc odbc driver  What is the default fetch size for the JDBC ODBC driver and how can i fetch a set of results for JDBC ODBC driver?   Fetching results JDBC ODBC Driver A. The default fetch
Php Sql ODBC
Php Sql ODBC  This example illustrates how to create a ODBC Connection for php application. With an ODBC connection, you can connect to any database, on any computer in your network, as long as an ODBC connection is available
jdbc,odbc,MySQL,swing - Java Beginners
jdbc,odbc,MySQL,swing  write a code that displays a menu list of all available database drivers in a window,and allows the user to select any driver from this list and execute any query (within a text field)related
jdbc odbc
jdbc odbc
Connect to MS Acces wothout using ODBC but JDBC - JDBC
Connect to MS Acces wothout using ODBC but JDBC  Hi, I want to connect my MS Access using JDBC but not ODBC. Please help me out. Thanks
ODBC driver manager return 'Data source name not found.
ODBC driver manager return 'Data source name not found.  Why does the ODBC driver manager return 'Data source name not found and no default driver specified Vendor: 0
ModuleNotFoundError: No module named 'odoo10-addon-base-external-dbsource-odbc'
ModuleNotFoundError: No module named 'odoo10-addon-base-external-dbsource-odbc...: ModuleNotFoundError: No module named 'odoo10-addon-base-external-dbsource-odbc' How...-external-dbsource-odbc' error? Thanks   Hi, In your python
Sun's JDBC-ODBC driver does not implement the getPrimaryKeys() method for the DatabaseMetaData Objects.
Sun's JDBC-ODBC driver does not implement the getPrimaryKeys() method for the DatabaseMetaData Objects.  Is there a way to find the primary key(s) for an Access Database table? Sun's JDBC-ODBC driver does not implement
how to connect java with ms access using odbc in eclipse
how to connect java with ms access using odbc in eclipse  import..."); //Connection con = DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft... = DriverManager.getConnection("jdbc:odbc:student.accdb"); Statement st
Connection using Jdbc-odbc bridge Driver
Connection using JDBC-ODBC bridge driver JDBCExample.java..."); con=DriverManager.getConnection("jdbc:odbc:datastud");  ... program, Jdbc-Odbc bridge driver create connection between java application
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.  String sql = "UPDATE emp_details SET empEname = ?, emailId = ?, guid =?, proximityCard =?, managerEmailId = ?, reviewerEmailId
what is bit
what is bit  what is bit
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection  what is hibernate.archive.autodetection? what is autodetection and why it is used
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection  what is hibernate.archive.autodetection? what is autodetection and why it is used
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection  what is hibernate.archive.autodetection? what is autodetection and why it is used
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection  what is hibernate.archive.autodetection? what is autodetection and why it is used
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection  what is hibernate.archive.autodetection? what is autodetection and why it is used
What is procedure
What is procedure  What is procedure in computers? What are the primary categories of procedures
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection  what is hibernate.archive.autodetection? what is autodetection and why it is used
What is Hibernate
What is Hibernate  Hi, What is Hibernate? Thanks
What is Hibernate
What is Hibernate  Hi, What is Hibernate? Thanks
What is Hibernate
What is Hibernate  Hi, What is Hibernate? Thanks
What is JDBC?
What is JDBC?  What is JDBC
What is FBT
What is FBT   hello, What is FBT
What is ActionServlet?
What is ActionServlet?  What is ActionServlet
What is Trigger?
What is Trigger?  What is Trigger
What is VLR ?
What is VLR ?  hii, What is VLR

Ads