Re: Servlet and JDBC problems

[Maron, Jonathan]

  Are you using JView?  You'd have to change

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

  to

        Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");

Jon


-----Original Message-----
From: Stefan Labuhn [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 26, 1999 12:44 PM
To: [EMAIL PROTECTED]
Subject: Servlet and JDBC problems


Hi

I want to make a connection to a FoxPro database.
When I do this connection with an application I have no problems.
But when I do it in the servlet I get an Exception.
I use the IIS and FoxPro Database.

Here is the exception:

java.sql.SQLException: No suitable driver
java.lang.Throwable.<init>(Compiled Code)
java.lang.Exception.<init>(Compiled Code)
java.sql.SQLException.<init>(SQLException.java:64)
java.sql.DriverManager.getConnection(Compiled Code)
java.sql.DriverManager.getConnection(DriverManager.java:126)


and here is the code:
  try
      {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection connection =
DriverManager.getConnection("jdbc:odbc:FoxPro", "Name", "Passwort");
        Statement statement = connection.createStatement();
        dbout(statement);

        statement.close();
        connection.close();
      } catch(java.lang.ClassNotFoundException e)
      {
      e.printStackTrace();
      } catch(java.sql.SQLException e)
      {
      e.printStackTrace();
    }


Can someone help me?

Thanks
    Stefan

Jonathan Maron.vcf