🚀 go-pugleaf

Thanks, it was a typo.

Roland

"D.M.(Mike) Mattix" schrieb:
> 
> In article <398C309B.A19117DC@web.de>, Roland.Zumkeller@web.de says...
> > 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.)
> >
> >
> Maybe it's just a typo but it occured twice.  My ODBC MS Access driver
> has two s's in Access.  Since this is a keyed lookup if your code has
> only one s in Access then that might be the problem.
> 
> Mike Mattix
> dmmattix@swbell.net