Re: Microsoft Access DB Driver for JDBC

James Croft wrote:
>
> Lee Fesperman wrote:
> > Jsnail wrote:
> >
> >>Does any body know of any freeware ms access drivers for jdbc that
> >>allow direct access to an ms access db. The jdbc odbc bridge works but
> >>i dont know how to dynamically add odbc data connections in windows
> >>(Some code to do this would also help).
> >
> > There is no JDBC driver for Access.
>
> The JDBC-ODBC bridge is intended (dunno, never used it although the
> poster says it works) to allow Java apps to talk to any ODBC datasource.

Well, the OP mentioned the JDBC-ODBC bridge, so it was obvious that he was looking for a
'native' JDBC driver for Access.

> >
> > The only way to add ODBC datasources in Java is to use JNI.
> >
>
> Security issues aside wouldn't it be possible to create a temporary .reg
> file with the changes needed and call 'regedit myupdate.reg' using Javas
> Runtime.exec() function?
>
> As I said before I'm fairly new to Java so have no idea if its security
> features will block this. If it worked it'd be easier than JNI.

Java security might block exec() but doesn't care what you execute with it.

> > You need to get a better db.
> >
>
> As ghastly as Access is to real men who drink real beer and use real
> databases there may be a perfectly valid reason for using it, eg. the
> boss/client demanding that it be used.

I'll leave it to the OP to clarify that, but I was giving very good advice in general
.... and not just because of JDBC-ODBC problems.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)
.

Relevant Pages

  • Re: jdbc permissions
    ... Using the SQL Server 2000 Driver for JDBC on a Java 2 Platform ... additional permissions. ...
    (microsoft.public.sqlserver.server)
  • Re: Possible Type Conversion Defect
    ... Specifically we are breaking due to the lack of conversion from BIGINT to ... Microsoft SQL Server 2000 JDBC driver. ... I'll agree that the JDBC API specifications could be a bit more precise. ... a JDBC driver attempts to convert the underlying data to the Java ...
    (microsoft.public.sqlserver.jdbcdriver)
  • path question
    ... I'm just started off with databases and jdbc. ... I load the driver by: ... copy the com/org directories to some dir and include them in the java ... For the classpath as well, ...
    (comp.lang.java.databases)
  • Re: ClassNotFoundException
    ... > Java application, using JDBC. ... > 3) My Java app is on Windows XP Home; ... > driver installed and a CLASSPATH set before running DBPING" ... > c) I know CLASSPATH system variable isn't set. ...
    (comp.lang.java)
  • Stuff the purple heart programmers cook up
    ... C To act like a framework for the JDBC driver developers. ... D To hide the specifics of accessing particular kinds of database ... Topic: Java 2: Survey Author: Chris Mc Devitt ... The JDBC ResultSet is actually an interface java.sql.ResultSet. ...
    (comp.lang.java.programmer)