Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training  




Share on Google+Share on Google+

ghouse modhin
1 Answer(s)      6 years and 6 months ago
Posted in : Java Beginners

I am using windows 7 with 32 bit os I installed java 1.6 version I also installed oracle 10g. When I am trying to execute jdbc-odbc programs it simply displays "jdbc drivers not found" plz help me

View Answers

February 18, 2011 at 3:44 PM

Java connect to MS Access database

If you want to connect MS Access database with the java code using driver "sun.jdbc.odbc.JdbcOdbcDriver", then follow these steps:

1)Go to the start->Control Panel->Administrative Tools-> data sources.

2)Click Add button and select the driver Microsoft Access Driver(*.mdb).

3)After selecting the driver, click finish button.

4)Then give Data Source Name and click ok button.

5)Your DSN will get created.

6) Restart your compiler and compile your java code.


import java.sql.*;
class RetrieveData{
    public static void main(String[] args){
           Connection con = DriverManager.getConnection("jdbc:odbc:student");
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from data");
               System.out.println(rs.getString("name")+" "+rs.getString("address"));
        catch(Exception e){


Related Tutorials/Questions & Answers:
hai   when we click on submit button request doesnot go to next servlet instead of that that servlet simply downloaded why? can tell me plz   It seems that the problem lies in your code. Anyways, we are providing you
hai   I am using windows 7 with 32 bit os I installed java 1.6 version I also installed oracle 10g. When I am trying to execute jdbc-odbc programs it simply displays "jdbc drivers not found" plz help me   Java
hai  hai this is anitha , i am persuing my B.Tech. 3rd year,i am doing a mini project,my task is to develope a code in java,to generate a graph using sql database values. so,kindly help me with my mini
hai this is sql question
hai this is sql question  what are tables in home appliances web application
hai java - Java Beginners
hai java  what do u mean by unchecked exception and checked exception? and do any java pgm will run with out thread concept... and what si thread...  Hi Friend, Please visit the following link: http
j2me exception - MobileApplications
j2me exception  Hai
matrix addition
matrix addition  hai
matrix addition
matrix addition  hai
matrix substraction
matrix substraction  hai
matrix substraction
matrix substraction  hai
matrix determination in java
matrix determination in java  hai
matrix polynamial addtion
matrix polynamial addtion  hai
jsp webapplication
jsp webapplication  hai Good mring to all
jdbc  Hai , Give a steps for jdbc connectivity
need sourcecode - Java Beginners
need sourcecode  Hai, I need program for packetization for videos
number - Java Interview Questions
number  apka number kya hai aap apna number mera id per send ker do
Mapping Technics - Hibernate
Mapping Technics  Hai i want some clarifications about one-to-many bidirectional relationship
Search - Java Beginners
Search  hai, how will we can search diff type of files using j2me
RARP program using java
RARP program using java   hai, how to implement the RARP concept using java
database - JDBC
database  hai friend, yes i want to use java database connection in eclipse IDE. Thanks in advance
serverdeploymenterror  hai this anji i required how we configure weblogic server in myeclipseIDE? with detail steps regards anjireddy
hibernate query
hibernate query  hibernate apache par kam karta hai kya   Hi Friend, Yes. Thanks
jsp  hai please give me the table grid code code for jsp
Interface vs abstract class
Interface vs abstract class  Hai, Is there any possible to defining abstract methods in Interface
length in array
length in array  hai wat s length in array and where it s used