Java Jdbc-odbc

Home Answers Viewqa Java-Interview-Questions Java Jdbc-odbc

QuestionAsk Questions?

samar

Java Jdbc-odbc
1 Answer(s) 2 years and 7 months ago
Posted in : Java Interview Questions

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.

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

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

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. Read the JDBC ODBC example. Thanks Here is another example with explanation: Example of JDBC ODBC

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 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 Connectivity
JDBC-ODBC Connectivity The code illustrates an example from JDBC-ODBC...;"jdbc:odbc:emp"; public

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

Connection using Jdbc-odbc bridge Driver
Connection using JDBC-ODBC bridge driver JDBCExample.java..."); con=DriverManager.getConnection("jdbc:odbc:datastud"); ...;} } Output Description of Program In the above program, Jdbc-Odbc

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

The JDBC-ODBC Bridge.
The JDBC-ODBC Bridge. Are there any ODBC drivers that do not work with the JDBC-ODBC Bridge

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

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

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

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

XLS JDBC Example
is used to access xls file from java application. It is read only JDBC driver... driver therefore you should use JDBC - ODBC bridge driver to connect your excel... = DriverManager.getConnection("jdbc:odbc:datasource", "", ""); stmt = conn.createStatement

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

Product Components of JDBC
. The JDBC Driver Manager. 3. The JDBC Test Suite. 4. The JDBC-ODBC Bridge... (Java EE) in itself. The JDBC API has four main interface: The latest... which connect Java applications to a JDBC driver. Usually Driver Manager

Java JDBC
Java JDBC Is the JDBC-ODBC Bridge multi-threaded

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

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

Java
("jdbc:odbc:air_dsn", "sa", "pass@123"); Statement stat = con.createStatement..."); con.close(); con = DriverManager.getConnection("jdbc:odbc:air_dsn","sa", "pass@123... i experience an error which says Error :java.sql.SQLException: [Microsoft][ODBC

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 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 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
=DriverManager.getConnection("jdbc:odbc:co"); } catch(Exception e... { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc...;Control Panel->Administrative Tool->Data Sources(ODBC) 2. Open User DSN tab

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

Error while SQL Server connection to Java
"); con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER;user=DTHOTA;password...("password", " "); con=DriverManager.getConnection("jdbc:odbc:SQL_SERVER", prop

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

Online quiz mini project
Online quiz mini project Sir i need a online quiz program coding using java servlet, jdbc odbc connection with ms. access. If possible send that source code to me. Thank you

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

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 " + "(*.mdb... textboxes, This is my code: editdata.jsp <%@ page language="java" import="java.util.*;"%> <%@ page language="java" import="java.sql.*"%> <

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

jdbc - JDBC
drivers for concurrent access? Question: Is the JDBC-ODBC Bridge multi-threaded? Answer: No. The JDBC-ODBC Bridge does not support concurrent access from different threads. The JDBC-ODBC Bridge uses synchronized methods

Java
.getConnection("jdbc:odbc:access"); Statement st = con.createStatement... =DriverManager.getConnection("jdbc:odbc:access","",""); Statement st

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
= DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver...;% } %> </BODY> editData.jsp <%@ page language="java" import="java.util.*;"%> <%@ page language="java" import="java.sql.*"%> <

Call Picture into java
("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:hyt","root","hayatinew"); Statement stat = con.createStatement(); ResultSet

connect database without specifying dsn name in java
jdbc & odbc..... i have saw this code on the web-site try...(); c=DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver

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

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics