🚀 go-pugleaf

Hi,
Does someone kno how to connect via JDBC to a MS Access database without
creating a System DSN?

I heard this would be possible with a statement like this:
Connection conn = DriverManager.getConnection(
 "jdbc:odbc:;DRIVER={Microsoft Acces Driver *.mdb)};DBQ=C:\\mydb.mdb",
 "", "");

I've tried this using "sun.jdbc.odbc.JdbcOdbcDriver" with both JDK 1.2
and 1.3. I always get a:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name
not found and no default driver specified

I heard it works with Microsoft's "com.ms.jdbc.odbc.JdbcOdbcDriver", but
using this with (MS SDK 4.0) I get the same Exception.

The database mydb.mdb exists and I've also tried the url 
"jdbc:odbc:DRIVER={Microsoft Acces Driver (*.mdb)};DBQ=C:\\mydb.mdb"
(without the first ";"). I've also connected to System DSNs successfully
with both SDKs, but that's just what I want to avoid.

I would be really happy if someone could help me.

Thanks!

Roland


PS. If it's necessary to use Microsoft's driver, how can it used within
Sun's SDK? (Just adding some zip-file to the classpath didn't work for
me.)