File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes a easy question   please help !!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "a easy question   please help !!!" Watch "a easy question   please help !!!" New topic

a easy question please help !!!

David Liu

Joined: Apr 16, 2002
Posts: 24
how can I access microsoft access2000 in jsp
this is my code
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
sqlRst=sqlStmt.executeQuery("select name,age from people");
<title>JDBC ACCESS 测试<title>
<table border="1" cellspacing="0" align="center">

but tomcat says "no suitable driver"

It's better burn out than to fade away.
Janet Wilson
Ranch Hand

Joined: Jul 16, 2002
Posts: 98
I'm sure you figured out an answer to your question and I'm not even certain this will help you out since it's Java and not JSP, but figured I would share some beginner code I have been creating for a training plan which might give you some pointers? The following code does successfully attach to an Access 2000 DB from within JDK 1.4.1 using a User DSN:

Remember, it's meant as a training tool! Hope this helps!
I agree. Here's the link:
subject: a easy question please help !!!
It's not a secret anymore!