jdbc - applet

[Jochen Kauffmann]

Hey everybody,

I have an applet to access a MS Access DB. The connection is made with:

URL = "jdbc:odbc:My";
User = "guest";
Password = "guest";

try
{
Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");
}
catch (Exception e)
{
text.append("No JDBC/ODBC - Driver ...\n");
text.append(e.getLocalizedMessage() + " " + e.getMessage()+"\n");
return;
}

stat = null;
con = null;

try
{
con = DriverManager.getConnection(URL,User,Password);
stat = verbindung.createStatement();
}
catch (Exception e)
{
e.printStackTrace();
text.append("No connection to " + URL + "\n");
text.append(e.getLocalizedMessage() + " " + e.getMessage()+"\n");
}

...



The DB and the applet is on a lokal Novell-Server path (No FTP or HTTP). It works perfect within VJ++ and IE on my computer. But it dosnt with

1. Netscape
- I guess its because of the jdbc-odbc driver. Am I right? How can I get around this problem? Maybe just with a nativ jdbc-driver. Is there somewhere a MS Access jdbc-driver for free?
2. on another computer
- I registerd the DB with the ODBC-Administrator from win98 on my computer. Do I need to repeat this on any other computer, or can I adress the DB (via URL or something else) directly from my applet?

Thanx in advance,
Jochen