MSAccess without ODBC

Thread view:

timasmith@hotmail.com - 26 Apr 2006 11:52 GMT

I vaguely recall a JDBC-ODBC bridge or something. Anyone know if I can
supply a MS Access database and a Java Driver which accesses it
directlly without a need for ODBC data source to be created?

thanks

Tim

Reply to this Message

Bjorn Abelli - 26 Apr 2006 13:36 GMT

<timasmith@hotmail.com> wrote...

> I vaguely recall a JDBC-ODBC bridge or something.
> Anyone know if I can supply a MS Access database and
> a Java Driver which accesses it directlly without a
> need for ODBC data source to be created?

You can always use the one Sun provided in the Java library.

DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());

You don't have to create a dsn on the machine in order to use an ODBC
driver:

String url =
"jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=mydb.mdb";

Connection connection =
DriverManager.getConnection (url);

// Bjorn A

Reply to this Message

webmaster.hxtt@gmail.com - 26 Apr 2006 16:55 GMT

Or use HXTT Access(http://www.hxtt.com/access.html), a commerical type
4 pure Java JDBC driver for MS Access.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...