Since I am a beginner, I have to start with some trial projects, right? I
know this is nothing! and help me...pls answer to the "question.".
On Fri, Apr 15, 2011 at 8:41 PM, Jeff Hubbs <jhubbsl...@att.net> wrote:
> 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
>
>
