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
begin: vcard
fn: Stefan Labuhn
n: Labuhn;Stefan
email;internet: [EMAIL PROTECTED]
title: 05251 / 606146
x-mozilla-cpt: ;0
x-mozilla-html: FALSE
version: 2.1
end: vcard