> you don't need the .newInstance() on the end of your driver...
on the other hand it doesn't harm you at all. i read somewhere that i'd be
better off with .newInstance(), due to some bug in browser's (either IE or
Netscape) jvm. or i might be just wrong. anybody can back me up on this?
vVolf
>
> i.e.
> try {
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> }
> catch (java.lang.ClassNotFoundException ex)
> { }
>
> hth
>
> Alan
>
> >
> > I am having some problem in jsp. When i try to connect my jsp
> > application to database it gives me error "No suitable
> > driver".I am using Tomcat server and Access 97.
> > I am giving u the code here.
> > <%@ page import="java.sql.*" %>
> > try {
> > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
> > }
> > catch (java.lang.ClassNotFoundException ex)
> > { }
> >
> >
> > try
> > {
> > <% Connection connection =
> > DriverManager.getConnection("jdbc:odbc:project"); %>
> > }
> > catch (SQLException ex)
> > {}
> > <% Statement statement = connection.createStatement();
> > ResultSet resultSet = statement.executeQuery("select * from
> > registration"); %>
> > <P> The results are:
> > </P>
> > <UL>
> > <% while (resultSet.next()) { %>
> > <LI><%= resultSet.getString(1) %></LI>
> > <% } %>
> > </UL>
> >
> > ********************************
> > Please Note :My java application runs fine and gives no
> > problem even while using Database.
> > I am using WindowsMe.and Access97 database.
> > My autoexec.bat is as follows.
> > SET
> > CLASSPATH=C:\jdk1.2.2\bin;C:\jdk1.2.2\lib;C:\WINDOWS;C:\WINDOW
> > S\COMMAND;C:\jdk1.2.2\jre\bin;
> > SET windir=C:\WINDOWS
> > SET winbootdir=C:\WINDOWS
> > SET COMSPEC=C:\WINDOWS\COMMAND.COM
> > SET PROMPT=$p$g
> > SET TEMP=C:\WINDOWS\TEMP
> > SET TMP=C:\WINDOWS\TEMP
> > SET BLASTER=A220 I5 D1 T4
> > SET JAVA_HOME=C:\jdk1.2.2
> > SET TOMCAT_HOME=c:\tomcat
> >
> >
> > waiting for your response
> > bye
> > gautam
> >
> > [EMAIL PROTECTED]
> > ______________________________________________________
> > 123India.com - India's Premier Portal
> > Get your Free Email Account at http://www.123india.com
> >
> >
> >
>
