Sad :-(, if it didnot help.
Then the possible cause could be a problem with the classpath.
Your piece of code is working fine at my end.
Post the exact problem alongwith your classpath settings & any other
relevant information if you wish to get more assistance from this list.
Have a nice day.
With regards,
Sachin S. Khanna
http://www.emailanorder.com
----- Original Message -----
From: Sharon Om <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 9:55 PM
Subject: Re: JDBC connection
> sorry... didn't help.
>
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of Sachin S. Khanna
> Sent: Friday, May 11, 2001 11:32 PM
> To: [EMAIL PROTECTED]
> Subject: Re: JDBC connection
>
>
> > Class.forName("sun.jdbc.odbc.JdbcOdbcDrive");
> may be you have fallen prey to a typo error by missing out on the alphabet
> 'r':-).
> The above should be changed to :
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> Have a nice day.
> With regards,
> Sachin S. Khanna
> http://www.emailanorder.com
> ----- Original Message -----
> From: Sharon Om <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, May 12, 2001 1:53 AM
> Subject: JDBC connection
>
>
> > Hello. I have the following code for connecting to the jdbc:odbc pool.
> > While compiling the Java code, I keep getting an
"ClassNotFoundException"
> in
> > Class.forName.
> > I also tried declaring Class T and have T.forName. I get the similar
> error
> > for "T.forName". How can I get this to work?
> >
> > Thank you for your help.
> > Sharon
> > ====================
> > package property;
> >
> >
> > import java.sql.*;
> > import java.io.Serializable;
> >
> > public class database implements java.io.Serializable
> > {
> >
> > public database() {
> >
> > }
> >
> > public String runSql()
> > {
> > String browserOutput = "";
> > Connection sqlca = null;
> > Statement sqlStatement = null;
> > ResultSet myResultSet=null;
> >
> >
> > /*Connect to database, run SQL and produce output */
> >
> > try {
> > /* Connection to the database */
> > Class.forName("sun.jdbc.odbc.JdbcOdbcDrive");
> > String theDatabase = "jdbc:odbc:loadtool";
> > sqlca =
> DriverManager.getConnection(theDatabase,"loadtool","loadtool");
> > }
> > catch (SQLException e) {
> >
> > browserOutput = "Error:SQL error of: "+e.getMessage();
> > }
> >
> > return browserOutput;
> > }
> >
> > }
> >
> >
>
===========================================================================
> > 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
>
>
===========================================================================
> 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
