02 May 2013

Tutorial: JDBC Connectivity with MS-Access Database

Hi friends,
Today i'm going to teach you how you can connect your MS-Access Database with java program (JDBC).
I hope you'l enjoy.

1.open ms Access | create database | save at your Location
2.Control Panel\Administrative Tools
3.click User dsn OR system dsn
4.click add
5.select Microsoft Access Driver(*.mdb,*.accdb)
7.Give name for dsn
8.click select
9.give the path to your database
10.click ok(You will see your dsn in the list);

write java program as follow

import java.sql.*;
import java.io.*;
import java.util.*;
class dbconnect1
          public static void main(String args[])
                             Connection con=DriverManager.getConnection("jdbc:odbc:xyz","","");
                             System.out.println("Connection established successfully");
                   catch(Exception e)

note:=(here XYZ is the dsn name you just created in step 7th step)

Tutorial by: Prakash Joshi

No comments :

Post a Comment

Popular Posts