You do realize, I hope, that what you're proposing is akin to sourcing
parts for your jet engine from Fisher-Price?
IMHO MS Access is not and never has been useful as a professional
database product. I'm not even sure if what you are proposing even
holds up in the looking-through-binoculars-from-the-big-end sense.
MS Access is a desktop application that accesses files on disk. Java
apps running on Tomcat typically access an RDBMS over a network
connection via SQL statements and their responses. AFAIK there is not a
"server instantiation" of MS Access; in fact, part of the whole point of
MS Access as an ongoing product is that it acts as a "gateway drug" to
MS' SQL Server product, the transition to which would be triggered by
the inherent limitations (and, in my past experience, persistent
unaddressed bugs) of Access.
I think you need to back up a bit and work toward getting your data
liberated from MS Access and ported into a proper RDBMS like PostgreSQL
or one of MS SQL Server, Oracle, IBM DB2, etc. if you feel that money
must be continually spent on software licenses for such. Then you will
be facing Java apps and Tomcat in a far more conventional way.
So, to sum up this and earlier responses: 1) Learn to code Java 2)
Understand real RDBMSses.
- Jeff
On 4/15/11 6:04 AM, RAHUL RAJ wrote:
Hello,
I am working on building a jsp website with MS Access as
database. When my login page is loaded on tomcat
(localhost:8080/login.jsp), it shows the following error:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified.
The jdbc program alone is working perfectly, So There might not be
problems due to Driver, Data source name, Database Tables or any
other software version compatibilities.
OS: Windows Vista Home Basic
Tomcat Version: 5.5.x
jdk version: 1.6
MS Access 2010
code is given below:
<%@ page language="java" import="java.sql.*" %>
<html>
<body>
<form method="post">
<p> Enter your username :<input type="text" name="username"/> </p>
<p> Enter your password :<input type="text" name="password"/> </p>
<input type="submit" value="Login"/>
<%
String usn = request.getParameter("username");
String pass = request.getParameter("password");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:rahul";
Connection con = DriverManager.getConnection(url, "", "");
Statement s = con.createStatement();
ResultSet rs = s.executeQuery("select * from customers");
while(rs.next())
{
String u = rs.getString(1);
String p = rs.getString(2);
if(usn.equals(u)&& pass.equals(p))
{
out.println("login successfull");
}
else
{
out.println("login failed");
}
}
}
catch(Exception e)
{
out.println("Error"+e);
}
%>
</form>
</body>
</html>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org