one more thing
the command prompt for creating tables etc. in mysql is really cryptic
so it is better if u do all your project in MS Aceess
create all your database in MSAccess and then in final stages of the project
there is tool called MSAccess to MySql conveter which u can find at mysql.org
use this tool and transfer ur database in Mysql.
we used this successfully in our project.
good luck
khem,
Ryan Ahmed wrote:
> Dear Sir/Madam,
> I am a student who has taken up a job to build a
> greetings website using servlets.
> I have finished all the servlets except the one to
> connec to the mySql database and make
> tables/transactions.
> To connec to the database in localhost is easy i just
> goto the settings and assign the driver etc but what
> do i on the web?
> I normally use->
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> Connection conn =
> DriverManager.getConnection("jdbc:odbc:MyDatabase");
> to connect to the msaccess db but what do i use here?
> Even if i download the driver
> mm.mysql.jdbc-1.2c.tar.gz
>
> Where do i put it?
> ion my servlet dir?
> or in my /data dir?
>
> I am a virtual host and have been assigned jrun.
> Also it would be a massive help if you can tell me
> where can i find a servlet that can create a table in
> the db for me.
> Please help as i have to complete this project as soon
> as possible.
> Thanking you
> Ryan.
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> 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".
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
