Discussion on Access Microsoft Access Database From Java Using JDBC-ODBC Bridge - Sample Code

July 8, 2010: 6:18 am
plz give example where u have used any of the following classes to help ur existing code: AccessJDBCUtil.java AccessJDBCTest.java plz reply me on my email id if u can. thankyou

June 27, 2010: 9:17 am
I need the steps that is how to connect jsp in access dadabase and sql database.

April 17, 2010: 2:47 am
how to store data in ms access using servlet please send me the code

April 14, 2010: 9:46 am
I have a problem while creating runtime DSN for SQL Server in JSP.Please suggest me.

March 20, 2010: 12:39 am
I am using front end as jsp with html as presentation logic and using ms acess as my back end accepting the data from the acess it is working give me some examples programs regarding this application

March 19, 2010: 1:43 am
amoll try this code it will work properly -------------------------------------- import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class NorthwindServlet extends HttpServlet { public static void main (String[] args) { System.out.println(doQuery()); } public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException { PrintWriter out=res.getWriter(); out.println(doQuery()); } public static String doQuery() { StringBuffer buf=new StringBuffer(); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:Northwind"," "," "); Statement st=con.createStatement(); String query="SELECT * FROM Employees"; ResultSet rs=st.executeQuery(query); buf.append("Empoyee Database"+ "\n" +"\n"); while (rs.next()) { buf.append(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+"\n"); } con.close(); } catch (ClassNotFoundException cnfe) { buf.append("Couldn’t find class file"+cnfe); } catch(SQLException sqle){ buf.append("SQL Exception"+sqle); } return buf.toString(); } }

March 16, 2010: 10:07 am
i need a code to search through a database(SQL Server) and display the results in a table.The string word will be searched in a separate frame.

February 19, 2010: 6:00 am
I need to know the sql command to count the number of attributes in Ms access database in java(using jdbc connection)

February 11, 2010: 4:32 am
how to use the SEO tool in java?or how to import SEO tool to Java?

December 8, 2009: 6:32 am
Hi i want to get the 750th record from the database using simple jdbc code

December 2, 2009: 5:29 am
How we can create MDB file through java programming.

November 10, 2009: 3:55 pm
HOW DO I INSERT AND DELETE DATE FROM DATABASE USING STATEMNET RS=ST.EXECUTEUPDATE()IN JAVA DEVELOPMENT

November 7, 2009: 1:36 am
I am doing a project in networks .. I want to know how to connect microsoft access using java code.. can you tell me the code for connection establishment.

October 21, 2009: 3:49 am
i am doing an assignment and i am required to import a database file to java and im nt sure of the code to use.can u plz help me out wth a simple program doing that plz.

September 29, 2009: 6:33 am
i m not geting an ms access data base connection when i write a java program usig jdbc odbc bridge dsn that will be created not found

September 14, 2009: 4:22 am
sir i need a code immed..... to write a java program using applet swings. front end java back end ms access. i will give a input(usre name admin and password admin) to the applet wimdow then open to the another page. that page contain simple 3 buttons.

August 21, 2009: 9:39 am
I have a jsp form, from where i've taken a value like String val1=request.getParameter("fieldname"); now I've converted string to integer like int val = Integer.parseInt(val1); but the problem is I can not insert this int value to ms access database where the field is number type! urgent...plz help me! Thanks in advance

July 30, 2009: 11:01 am
I am trying to connect ms access database using servlet(with Tomcat Server) but getting problem in connection. I got the Exception as below: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified What I do? Where I keep my database? Code: import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.sql.*; public class check extends HttpServlet { Connection con; Statement stmt; ResultSet rst; PrintWriter out; public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException { try { out=res.getWriter(); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:logdata"); stmt=con.createStatement(); rst=stmt.executeQuery("select * from Employee"); } catch(Exception ae) { out.println("Exception : "+ae); } try { out.println("Servlet with jdbc"); out.println("Hello"); while(rst.next()) { String str1=(String)rst.getString(1); String str2=(String)rst.getString(2); out.println(""); out.println(""+str1+""); out.println(""+str2+""); out.println(""); } out.println("Bye"); } catch(Exception e) { out.println("Exception : "+e); } } }

July 4, 2009: 1:44 pm
hi sir i'm doing a simple program on how to use the MS acces as a database but the interface is using a java, can you give me a sample program how to connect access to java?

June 17, 2009: 10:01 am
hi..i am doing a project in J2ME.... how to connect to msaccess.... can anyone send me a sample code...

March 30, 2009: 10:45 am
this is my program import java.io.*; import java.sql.*; public class odbcaccessconnection { public static void main(String[] args) { Connection con = null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; // Connect with a url string con = DriverManager.getConnection("jdbc:odbc:hy_access"); System.out.println("Connection ok."); con.close(); } catch (Exception e) { System.err.println("Exception: "+e.getMessage()); } } } i have error that exception :no data found please clear it

March 23, 2009: 3:05 pm
i just want to know, how to insert, delete, edit and search in java programming using DataBase via MS ACCESS

March 17, 2009: 4:16 pm
Connection issues between JSP and MS Access Anybody know why I would be getting the following error: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The connection will work for a while ... then we will start getting the above error. Rebooting the server hosting the JSP & MS Access DB will fix the issue for while. Any suggestions welcome... Here's what we have tried Attempt 1 *************** Attempt 2 ********************** Changed: rs.close(); st.close(); cn.close(); To: if (rs != null) rs.close(); if (st != null) st.close(); if (cn != null) cn.close();

March 16, 2009: 10:16 am
Are you using the JDBC-ODBC bridge driver?

March 16, 2009: 9:10 am
hi sir, i have some problem in using the ms access databse with swings. it throws driver not found exception. can u come out with any solution.

March 3, 2009: 5:00 pm
i m doing a project is (online shopping) using java .. how to create MS access database, table using java and how to insert data got from the user into the access table. and how to retrive the data into database pls help me...thanks in advance. regards sathishreddy satsri.masri@gmail.com 9010465523

February 22, 2009: 8:11 pm
hi... your site is very useful for newbiz thanks for providing a good reference material for students thanks

February 22, 2009: 6:37 am
how to connect between java with MSAccess database with some simple example

February 20, 2009: 8:43 am
Hi i ve problem with this code when i run this servlet then it will display following err msage Couldn't find class filejava.lang.ClassNotFoundException: sun.jdbc.odbc.jdbcodbcDriver so anyone can suggest me whats the problem? ..................................................... i ve given code below ..................................................... import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class NorthwindServlet extends HttpServlet { public static void main (String[] args) { System.out.println(doQuery()); } public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException { PrintWriter out=res.getWriter(); out.println(doQuery()); } public static String doQuery() { StringBuffer buf=new StringBuffer(); try { Class.forName("sun.jdbc.odbc.jdbcodbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:Northwind"," "," "); Statement st=con.createStatement(); String query="SELECT * FROM Employee"; ResultSet rs=st.executeQuery(query); buf.append("Empoyee Database"+ "\n" +"\n"); while (rs.next()) { buf.append(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+"\n"); } con.close(); } catch (ClassNotFoundException cnfe) { buf.append("Couldn't find class file"+cnfe); } catch(SQLException sqle){ buf.append("SQL Exception"+sqle); } return buf.toString(); } }

February 1, 2009: 7:42 am
hi sir how to create a table in MS-ACCESS throw jdbc bridge driver

January 6, 2009: 6:03 am
Hi, I wanted to know if there is any mechanism by which I can create a new MS Access DB file through java.. Thanks in advance!

December 11, 2008: 11:33 pm
Hai friends, I hope if i have any doubt i can share with u and get the solution for the problem. thank u friends

November 18, 2008: 11:43 am
hey guys i m new to this can anyone kindly help me i want to connect my java with sql without establishing a ODBC. so tat whenever i run my program i get connected to the database

October 20, 2008: 11:53 pm
I am populating MSAccess tables using jdbc-odbc.There are around 20,000 records i have to populate in each table..This process is taking a lot of time.Can somebody help me out is there is any alternate way thru which i can do the same with maximum speed.

September 30, 2008: 6:45 am
help me with a code to connect java to relational database using jddc-odbc bridge and also code to modify and add data to the connected database

September 23, 2008: 5:55 am
how to connect ms access using servlet with odbc

August 25, 2008: 6:27 am
hi friends now i join programmer in java plotform, its a small company.now i am very happy

May 31, 2008: 1:25 am
Register Page First Name: Last Name : Age : city :

May 31, 2008: 1:21 am
Hi Guys I am JEYARAM. This is sample coding an using JDBC connection to the DataBase. ===================================================== Register Page First Name: Last Name : Age : city : ===================================================== Regards JEAYRAM .A 9894174502.

May 31, 2008: 1:04 am
this is site very useful my project development. Thank you sir.. Regards Jeyaram.A

May 29, 2008: 5:05 am
You should read the Java Tutorial which is available for free from Sun.

May 28, 2008: 10:30 pm
hi iam narender i want to learn java basics with sutaible examples which book i refer i mean to easy to learn

May 16, 2008: 10:07 pm
hi everyone can you give me a sample code of admin.where belong the username anda password

April 27, 2008: 2:45 pm
i am doing a j2ee project in online business service engine..i was using oracle 9i database but sometimes the Ora90HTTPserver service stops automatically and then does not starts. i would like to know why this happens..i am not able to execute my project.then i converted my datbase to ms-access and i linked it wid java with the code and also connected through control panel but i am still not able to execute my project..can any1 tell me how to connect ms-access to my program properly or y the ora90http server service in services.msc stops and does not starts..it show the error"the service stopped automatically"

March 28, 2008: 9:08 pm
Please post your questions on our forum as it will allow others to help you easily.

March 27, 2008: 10:17 pm
Hi, Iam new to jsp&sevelets and i have to connect jsp with access db.... i have created DSN name as Test and i used this code .... ------------------------------------------------- import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class JDBCConnection { public static Connection getConn() { Connection con = null; //Statement st = null; try { Class.forName(\"sun.jdbc.odbc.JdbcOdbcDriver\");//registring the driver //con = DriverManager.getConnection(\"jdbc:odbc:est\",\"\",\"\"); con = DriverManager.getConnection(\"jdbc:odbc:Test\",\"\",\"\"); System.out.println(\"Connection------>\" + con); return con; } catch (SQLException se) { System.out.println(se.toString()); } catch (Exception e) { System.out.println(e); } return (null); } public static void main(String[] args) { JDBCConnection.getConn(); } } ------------------------------------------------ but iam getting an error : java.sql.SQLException: No data found kindly help me with code and step by step process to connect access to jsp.. :-)

March 14, 2008: 9:36 am
how to sore d excel data in access database or SQL.. plz help.. thank...

March 12, 2008: 8:26 am
hai friend this is suresh.i want the program in java.how to connect the Access database from javaprogram.please send the program code to my mail id.and what is the Key word to access the Data base. Thanking You.... suresh..

March 9, 2008: 6:32 am
how to access database using tamcat and msaccess in jsp

March 9, 2008: 6:31 am
how to accesss database in jsp using tomcat serverand msaccess

February 29, 2008: 8:52 am
hi, i m doing a project in jsp and servlets.i m using jsp for designing the UI and servlets for business logic.i want to store the datas dat i get from the regsiter page.plz tell me whether i should connect the servlet or the jsp with the database and also plz tell me the steps for MSAccess database conectivity wid the correct code.

February 26, 2008: 10:48 pm
I have provided the sample code in the post above. Download and use it.

February 26, 2008: 2:50 am
i would like to know how to connect MS Access database from Applets & application & I need the sample program for it. kindly help me out.

February 13, 2008: 7:26 am
i have created a database using MS ACCESS and i dont know how to access it through using Java program, because i want to get the items i stored in my database so that i can retrieve it out to my Java program..thnx

February 7, 2008: 10:27 am
hi,i need to connect to database in java program, if created a MS Access Database ,where should i save it and how should i access it from my program?

January 30, 2008: 9:47 pm
after establishing the connection between java and msaccess i have created one table through java program after running this program it is giving messge as table is created but it is not there in my database...... where it will be stored?

January 14, 2008: 4:19 am
how to create MS access database, table using java and how to insert data got from the user into the access table.thanks in advance

January 14, 2008: 4:12 am
how to create MS Access database, table using java code. And how to insert some data got from user into the access table.help please. thanks in advance

December 7, 2007: 8:24 pm
sir, how to open a report in microsoft access using java codes??help plz

November 28, 2007: 4:20 am
i want toconnect MSAccess with JSP.And check the username and password which i give matches with those in MSAccess Table

November 22, 2007: 6:58 am
I have an application sever and a database server. from application server, i need to write java code to connect to the MS Access database in database server. help me with the code please.

November 19, 2007: 11:37 pm
Sir I have placed a TextBox in the Frame I can't able to insert the value i got from that box to the Access table or other(dbms).tell me the way or codings to insert the values to the backend(Access or sqlserver)

November 13, 2007: 12:02 pm
Why would you want to import using Javascript? Use Java / PHP or any decent server side language.

November 13, 2007: 1:35 am
sir,how to export and import data between MS Access and Excell sheet using the java script.will you please send me the code.

October 13, 2007: 12:19 am
Please tell where can i find Beans Development Kit software(BDK) of any version.Tell corectly Web-site.

August 21, 2007: 5:49 am
I have written a java programe and gave the required Connection to MSAccess through ODBC .when compiling it is ok but running the program Windows giving an error stating java.sql.exception=No suitable Driver. What should i do? And I like to know how to connect MSAcess to java programe in Control panel,not in java programe since i have already know how to connect ODBC in java programe.I want to know how to connect MS Access in ODBC drive through CONTROLPANEL.That is going to ControlPanel and clicking on ODBC and then DSN dialog box will open and next giving the DSN Name and then what?

August 18, 2007: 10:37 am
i want to know how to open an ms access report from my java application pls......

August 18, 2007: 10:05 am
please help me! this is my code snippet, i have created a dsn called MyDSN the code below gives an SQL Exception where the connection object is created. error says the default driver not specified can u please tell me what is the cause for this: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:MyDSN","sa",""); thank you

August 16, 2007: 1:00 am
i want to open ms word document by using java code, is there any code regarding this.If there is any code please send me, its urgent............

August 13, 2007: 8:03 pm
Hi,

August 7, 2007: 12:09 am
hi sir, i want a simple application to access from ms access through jsp

July 19, 2007: 11:16 pm
Hai sir.. I want to how to connect ms access database through the JSP Programming!

July 11, 2007: 11:35 am
I would like to read an ms Excel document and use it to initialiaza a database I created with Access... any ideas on how to do this?

July 10, 2007: 3:13 am
want simple ms access database connection java program

June 15, 2007: 4:55 pm
i can't connect my java gui with msaccess database.plez send me proper working code for jdbc.

June 7, 2007: 12:21 am
im getting an exception "no data found" what might be the problem?

May 27, 2007: 2:56 am
i am looking for a code to display images on desktop pls help me

May 9, 2007: 12:11 pm
I like your code, thank you for sharing this with everyone. It really helped me do what I needed to do, which was get some data from a Access Database into my java program.

April 19, 2007: 12:32 pm
This is a very nice way to understand the programs i like this site

March 28, 2007: 2:48 am
I have a doubt sir.I am developing a tool which uses java with Ms access .I am updating my ms access database using java. I need to spread the data on the ms access database to Ms Excel sheet using java(via jdbc connection).

March 16, 2007: 12:59 am
i hav a problem to connect with ms access database i write following code to access the author table frm MS access database ...but it can't working anybody tell me wht's the probs.... i run this code via tomcat server..it's print first hello... further nothing import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class DataBase extends HttpServlet { public void doGet(HttpServletRequest req,HttpServletResponse res) throws IOException, ServletException { doPost(req,res); } public void doPost(HttpServletRequest req,HttpServletResponse res) throws IOException, ServletException { try { PrintWriter pw=res.getWriter(); pw.println("hello"); String str="SELECT * FROM author"; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:prakash","",""); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(str); pw.println("hello"); while(rs.next()) { String id= rs.getString("au_id"); pw.println("id"+id); String fname= rs.getString("au_fname"); pw.println("fname"+fname); String lname= rs.getString("au_lname"); pw.println("lname"+lname); } } catch(SQLException e) { System.err.println("SQL Exception found!"); } catch(ClassNotFoundException e) { System.err.println("JdbcOdbc Bridge Driver not found!"); } finally { System.err.println("hello finally inner"); } } catch(Exception ex) { System.out.println("error"+ex); } finally { System.err.println("hello finally outer"); } System.out.println("yes OUTER"); } }

December 25, 2006: 4:22 am
if we enter the text in a text box how to store it in the database.using jsp please send the coding.

December 1, 2006: 12:51 am
i want a code for my jsp program ,how to connect msaccess database stored in website?. i already connected by using dsn name in my local system. what i need is how to connect msaccess datbase stored in website. my code lass.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String filename = "c:database/demo1.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}";

August 28, 2006: 11:02 pm
This is the simple code to create database through MS Access.. private static final String accessDBURLPrefix = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; private static final String accessDBURLSuffix = ";DriverID=22;READONLY=false}"; // Initialize the JdbcOdbc Bridge Driver static { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e) { System.err.println("JdbcOdbc Bridge Driver not found!"); } } /** Creates a Connection to a Access Database */ public static Connection getAccessDBConnection(String filename) throws SQLException { filename = filename.replace('', '/').trim(); String databaseURL = accessDBURLPrefix + filename + accessDBURLSuffix; return DriverManager.getConnection(databaseURL, "", ""); }

May 4, 2006: 7:26 am
That type 4 JDBC driver for MS Access is at now.

April 7, 2006: 8:15 am
There is also a type 4 JDBC driver implementation for MS Access by some chinese company. The website is https://www.hxtt.net.