There's roughly 7 steps
load the jdbc driver
define the url connection and establish it
create a statement object
execute the query
do whatever with the results
close the connection
but access should only be used for personal desktop stuff like keeping track
of your own personal bill paying or something miniscule like that
port everything over to sql server or something better
-----Original Message-----
From: Ruaidhr� Fernandes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 12:47 PM
To: [EMAIL PROTECTED]
Subject: Re: MS Access
Hi all,
Im new to JSP. Trying to create an e-commerce web site
using JSP alone.
Im usinf MS Acess as my database and im wondering how
i would go about making a connection to it using JSP.
If anyone knows or knows some web page explaining how
to do it that would be great.
Thanks
Ruaidhri Fernandes
--- Ashish Shrestha <[EMAIL PROTECTED]> wrote:
> Celeste Haseltine wrote:
> > I must admit that I had not heard of the FreeTDS
> driver. I've already
> > purchased a Type 4 JDBC driver, but just out of
> curiousity, is FreeTDS a
> > type 4 driver, or a type 2? For my production
> internet application, I
> > needed a Type 4 driver, and one that included the
> extended API.
>
> It is a Type 4 driver, but I think the
> implementation is not
> complete.
> --
> a s h i s h @ j d g n p . o r g
> Get Headlines 0.5.2 for free at
> http://headlines.sourceforge.net/
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body:
> "set JSP-INTEREST DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
=====
"If a rabbit's foot is so lucky,..... what happened to the rabbit?"
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
