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

That type 4 JDBC driver for MS Access is at now.

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}”;

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”);
}
}

This is a very nice way to understand the programs
i like this site

i am looking for a code to display images on desktop pls help me

i can’t connect my java gui with msaccess database.plez send me proper working code for jdbc.

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?

hi sir, i want a simple application to access from ms access through jsp

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…………

i want to know how to open an ms access report from my java application pls……

Please tell where can i find Beans Development Kit software(BDK) of any version.Tell corectly Web-site.

Why would you want to import using Javascript?
Use Java / PHP or any decent server side language.

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.

sir, how to open a report in microsoft access using java codes??help plz

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

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?

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.

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.

how to access database using tamcat and msaccess in jsp

how to sore d excel data in access database or SQL..
plz help..
thank…

Please post your questions on our forum as it will allow others to help you easily.

hi everyone can you give me a sample code of admin.where belong the username anda password

You should read the Java Tutorial which is available for free from Sun.

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.

hi friends
now i join programmer in java plotform, its a small company.now i am very happy

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

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

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!

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();
}
}

hi…

your site is very useful for newbiz thanks for providing a good reference material for students

thanks

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.

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();

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

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?

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

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