Java Jdbc-odbc

Java Jdbc-odbc

What is the difference between JDBC and ODBC?
View Answers

October 27, 2010 at 5:16 PM

Hi,

Here is the answer,

JDBC standard java interface to communicate with a database ODBC from Microsoft developed interface to communicate with a database.

JDBC-ODBC driver an interface where the communication is translated from JDBC to ODBC and the communication after the driver to the database is via ODBC.

a-ODBC is for Microsoft and JDBC is for java applications.

b-ODBC can't be directly used with Java because it uses a C interface.

c-ODBC makes use of pointers which have been removed totally from java.

d-ODBC mixes simple and advanced features together and has complex options for simple queries,But JDBC is designed to keep things simple while allowing advanced capabilities when required.

e-ODBC requires manual installation of the ODBC driver manager and driver on all client machines.JDBC drivers are written in java and JDBC code is automatically installable,secure,and portable on all platforms.

f- JDBC API is a natural Java Interface and is built on ODBC. JDBC retains some of the basic feature of ODBC

Thanks.









Related Tutorials/Questions & Answers:
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
Advertisements
JDBC ODBC Connection In Java
JDBC ODBC Connection In Java In this section we will read about the various... a bridge between the Java Programming Language and the ODBC to use the JDBC API... in Java and we will make a connection using JDBC ODBC driver and then we
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... to the selected database driver.It is very well known as jdbc front end of a database
JDBC-Odbc Connection
in  JDBC into ODBC. For ODBC,it is a normal java application program. This bridge... help you in explaining JDBC Odbc Connection in Java. The code explains you... JDBC-ODBC Connection      
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 connection
jdbc odbc connection  i need a program in java which uses a jdbc odbc... computer and then access in your Java program.ADS_TO_REPLACE_1 Read the JDBC ODBC..._TO_REPLACE_2 Example of JDBC ODBC bridge. Thanks
jdbc odbc
= DriverManager.getConnection("jdbc:odbc:swing"); String sql = "INSERT...jdbc odbc  Sir, i want to get the selected value from JCombobox to ms...://www.roseindia.net/java/example/java/swing/store-jcombobox-selecteditem-value
The JDBC-ODBC Bridge.
The JDBC-ODBC Bridge.  Are there any ODBC drivers that do not work with the JDBC-ODBC 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 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
Connection using Jdbc-odbc bridge Driver
program, Jdbc-Odbc bridge driver create connection between java application...Connection using JDBC-ODBC bridge driver JDBCExample.java..."); con=DriverManager.getConnection("jdbc:odbc:datastud");  
JDBC-Odbc Connectivity
JDBC-ODBC Connectivity       The code illustrates an example from JDBC-ODBC...;static private final String connection = "jdbc:odbc
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
jdbc odbc
jdbc odbc  i want to fetch the data from the ms access and print on ms word for printing purpose?? the whole program is in swing to ms acess connectivity.. the whole set up is perform only printing part is remaining? so help me
jdbc odbc
jdbc odbc  i want to fetch the data from the ms access and print on ms word for printing purpose?? the whole program is in swing to ms acess connectivity.. the whole set up is perform only printing part is remaining? so help me
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
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 Retrieve Excel data into mysql using type 2 JDBC-ODBC driver
How to Retrieve Excel data into mysql using type 2 JDBC-ODBC driver  Can any please help it is very urgent. I tried to read excel sheet using ODBC..."); Connection conn = DriverManager.getConnection("jdbc:odbc:excel
online quiz program coding using jsp, jdbc odbc connection with ms. access.. Thank you.
online quiz program coding using jsp, jdbc odbc connection with ms. access.. Thank you.  please provide online quiz program coding using jsp, jdbc odbc connection with ms. access.. Thank you.   Create table test
Java JDBC
Java JDBC   Is the JDBC-ODBC Bridge multi-threaded
XLS JDBC Example
is used to access xls file from java application. It is read only JDBC driver... comes with ODBC driver therefore you should use JDBC - ODBC bridge driver... = DriverManager.getConnection("jdbc:odbc:datasource", "", ""); stmt
Java jdbc connection
Java jdbc connection  Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection
Java JDBC
Java JDBC  Is JDBC-ODBC bridge multi-threaded?  NO. The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls made.... The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls
java,sql
java,sql  Hello sir,iam an MCA student.I want a project code of jdbc,odbc connection for educational details of a student.please send me the code.  you din't send me the reply,please send it fastly sir
Product Components of JDBC
of  Java Platform Enterprise Edition (J2EE).  4. The JDBC-ODBC.... The JDBC Driver Manager. 3. The JDBC Test Suite. 4. The JDBC-ODBC Bridge.ADS....  JDBC application programmming interface is a  part of the Java
java servlet connectivity problem with access
= DriverManager.getConnection("jdbc:odbc:CUSTOMER...java servlet connectivity problem with access  Import java.sql...("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc
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
java basics
java basics  What are the different driver types available in JDBC... as: JDBC-ODBC bridge plus ODBC driver, also called Type 1. Native-API, partly Java driver, also called Type 2. JDBC-Net, pure Java driver, also called Type
java,sql
java,sql  Hello sir,iam sireesha studying MCA.i want a project on educational details of a student by using jdbc,odbc connection including sql.../jdbc/index.shtml Learn JDBC and then you can easily develop any project
excel file using JDBC java.?
excel file using JDBC java.?  hey, i am a telecomm. engineer , and i am try to develop a tool which reads from a excel file and then appends the same... used JDBC ODBC to read from excel file. i am not able to append it using
java
; String url = "jdbc:odbc:Driver={Microsoft Access Driver..."; // String dbName = "register.accdb"; //String driver = "jdbc:odbc... code change the following line String url = "jdbc:odbc:Driver={Microsoft Access
how to access the MS ACCESS database with java
= DriverManager.getConnection("jdbc:odbc:student"); Statement st... = DriverManager.getConnection("jdbc:odbc:student"); Statement st=con.createStatement..."); Connection con = DriverManager.getConnection("jdbc:odbc:student
How to store JComboBox selected Item into Ms Access Database - Java Beginners
("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con =DriverManager.getConnection("jdbc:odbc... =DriverManager.getConnection("jdbc:odbc:access","",""); Statement stmt=con.createStatement...(); } public SwingFrame(){ JFrame f = new JFrame("Frame in Java Swing
How to save JCombobox Selected Item in to Access Database - Java Beginners
("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con =DriverManager.getConnection("jdbc:odbc... =DriverManager.getConnection("jdbc:odbc:access","",""); Statement stmt=con.createStatement(); int i... SwingFrame(){ JFrame f = new JFrame("Frame in Java Swing"); f.getContentPane
java
java  how to connect java with the odbc or any orher database system?   Java JDBC connect to MS Access database Follow these steps: 1)Go...("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc
java - JDBC
, The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls that it makes to ODBC. Multi-threaded Java programs may use the Bridge...java  drivermanager class loads the drivers to connect odbc
java coding
java coding  plz correct this one ....i want to retrive data row from...("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:college"); Statement st=con.createStatement
java - Swing AWT
"); Connection conn = DriverManager.getConnection("jdbc:odbc:access...java  how can i add items to combobox at runtime from jdbc  .../java/example/java/swing/AddRemoveItemFromCombo.shtml Thanks  Hi Friend
unable to connect database in java
=DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=E:/Final Project... to connect database with my application by using java but i am unable to connect...();} And i am getting this error java.sql.SQLException: [Microsoft][ODBC
java - JDBC
{ String url="jdbc:odbc:access"; File file=new File("c:\\barbie.jpg...("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc...java  how to create a database for java with images in ms access(2007
java coding
con=DriverManager.getConnection("jdbc:odbc:college"); Statement stm...=DriverManager.getConnection("jdbc:odbc:college"); Statement st=conn.createStatement...java coding  can any one plez tell me how to retrive a row from
Java Program - JDBC
("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:access... = DriverManager.getConnection("jdbc:odbc:access"); Statement st...Java Program  Write a Java Code using swings and display records from
unable to connect database in java
=DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=E:/Final Project..."); Connection con = DriverManager.getConnection("jdbc:odbc:student... to connect database with my application by using java but i am unable to connect
java,sql
on JDBC,ODBC connection to display student administration system (or) student...("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc...("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:access
Java to insert picture to database - JSP-Servlet
=resp.getWriter(); try { /* Load the JDBC ODBC bridge driver... the DSN, empDSN. */ con=DriverManager.getConnection("jdbc:odbc:test...Java to insert picture to database  Hi Guys, Please assist me
java programming - Java Beginners
=DriverManager.getConnection("jdbc:odbc:access","",""); Statement st...java programming  a simple program for library using event driven and use jdbc to connect backend database   Hi Friend, Try
java date - Java Beginners
con = DriverManager.getConnection("jdbc:odbc:msdesktop"); Statement st... = DriverManager.getConnection("jdbc:odbc:msdesktop"); PreparedStatement pstmt...java date   Hi, Please observe the below code: import

Ads