Java Jdbc-odbc

Ads
 

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.

Ads









Related Tutorials/Questions & Answers:
Java JDBC ODBC
Java JDBC ODBC  What is the difference between JDBC and ODBC
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... a bridge between the Java Programming Language and the ODBC to use the JDBC API
Advertisements
JDBC-Odbc Connection
in  JDBC into ODBC. For ODBC,it is a normal java application program. This bridge... in explaining JDBC Odbc Connection in Java. The code explains you a how creation... 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
= 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
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 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 Connectivity
JDBC-ODBC Connectivity       The code illustrates an example from JDBC-ODBC...;"jdbc:odbc:emp";   public 
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
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 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
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
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
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
=DriverManager.getConnection("jdbc:odbc:testDSN"); Statement s...://www.roseindia.net/java/example/java/swing/SetColumnHeader.shtml
Java
= DriverManager.getConnection("jdbc:odbc:student"); Statement st...Java  Hello Friend, Thanks for revert... Actually am new to java, I having softwares like netbeans IDE6.8, Tomcat and Mysql(server), I create
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
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
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
("sun.jdbc.odbc.JdbcOdbcDriver"); Connection connect =DriverManager.getConnection("jdbc:odbc:access...java   how to get values from jtable and save in database ?  ...("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost
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:odbc:air_dsn", "sa", "[email protected]"); Statement stat = con.createStatement..."); con.close(); con = DriverManager.getConnection("jdbc:odbc:air_dsn","sa", "[email protected] i experience an error which says Error :java.sql.SQLException: [Microsoft][ODBC
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
How to add dynamic table in java
("jdbc:odbc:access"); String sql = "Select * from data"; Statement stmt...How to add dynamic table in java  How to add dynamic table in java   import java.awt.*; import java.sql.*; import java.util.*; import
java swing (jtable)
= DriverManager.getConnection("jdbc:odbc:roseindia"); String sql = "Select * from...java swing (jtable)  hii..how to get values of a particular record in jtable from ms access database using java swing in netbeans..?? please help
convert java Application to Java Applet
"); cn = DriverManager.getConnection("jdbc:odbc:AddressBook "); }catch...convert java Application to Java Applet  hi every Java Master or Java Professional , my Name Is Vincent i'm java beginner can i ask a question

Ads