wood burning stoves 2.0*
The moose likes JDBC and the fly likes connect to Access from jsp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "connect to Access from jsp" Watch "connect to Access from jsp" New topic
Author

connect to Access from jsp

Steven Riche
Greenhorn

Joined: Feb 10, 2004
Posts: 3
Hi all:
I am new to jsp and i met a problem while connecting to Microsoft Access.
The following is the code:
<%@ page import="java.sql.*" %>
<html>
<body>
<%
String name=request.getParameter("name");
String balance=null;

if(name==null || "".equals(name)){
name="";
balance="";
}
else{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
out.println("load driver");
Connection dbc=DriverManager.getConnection("jdbc dbc:kkk");
out.println("get connected");
Statement s=dbc.createStatement();
ResultSet rs=s.executeQuery("select balance from tt where name='"+name+"'");
if (rs.next()){
balance=rs.getString(1);
}
rs.close();
s.close();
dbc.close();
}catch(Exception ex){
out.println(ex.getMessage());
}
}


%>
<form method="Get">
Name <input type="text" name="name" value=<%= name %>>
Balance <input type="text" name="balance" value=<%= balance %>>
<input type="submit" name="submit">
<input type="reset" name="reset">
</form>

</body>
</html>

The error message is:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
the datasoure "kkk" is in the ODBC pool and it tests well when I run a standalone program.
Any ideas?
Billybob Marshall
Ranch Hand

Joined: Jan 27, 2004
Posts: 202
Is "kkk" a 'system' DSN, or a 'user' or 'file' DSN? If not a 'system' DSN, when you start the J2EE server, is it running as the same user that owns the DSN?
Steven Riche
Greenhorn

Joined: Feb 10, 2004
Posts: 3
billbob, thanks.
cause I am using Tomcat 5, which start as Windows Service.
Billybob Marshall
Ranch Hand

Joined: Jan 27, 2004
Posts: 202
Originally posted by Steven Riche:

...I am using Tomcat 5, which start as Windows Service.

That's probably the "SYSTEM" user. So your 'kkk' DSN needs to be defined as a 'system' DSN, not a user one.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: connect to Access from jsp
 
Similar Threads
Servlet becomming slow
Servlet becomming slow
Connect to access from jsp
with out authentication it is forwading to another page
passing parameters from JSP to a Servlet