No I am in Windows mode. On Fri, Apr 15, 2011 at 11:26 PM, Propes, Barry L <barry.l.pro...@citi.com>wrote:
> Jeff has some really good points here, Rahul. > > I'm a guy who spent several years doing ASP development with both MS Access > and SQL Server over the web before getting into Java. > Even still, I didn't fathom trying to mess with MS Access with Java when I > was making that transition. I started with mySQL on my Windows desktop to > get started, but when I got access to our Oracle servers, went that route. > > Like Jeff says, you can do this basically for no cost using both Tomcat and > mySQL. > > Sure, it's command line, unlike MS Access, but you shouldn't have too much > trouble with it. Jeff, if he's using MS Access, he's probably not on Linux, > is he? > > > -----Original Message----- > From: Jeff Hubbs [mailto:jhubbsl...@att.net] > Sent: Friday, April 15, 2011 12:46 PM > To: Tomcat Users List > Subject: Re: Working of Tomcat with MS Access > > A beginner needs to at least begin with workable platforms and software. > PostgreSQL on Linux has a total software license cost of $0.00; your > barrier to entry with inappropriate software is considerably higher. > > On 4/15/11 1:35 PM, RAHUL RAJ wrote: > > 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 > >> > >> > > > --------------------------------------------------------------------- > 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 > >