MSAccess without ODBC

[timasmith]

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

 

[Bjorn Abelli]

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 =
"jdbcdbcRIVER={Microsoft Access Driver (*.mdb)};DBQ=mydb.mdb";

Connection connection =
DriverManager.getConnection (url);


// Bjorn A



Inviato da X-Privat.Org - Registrazione gratuita http://www.x-privat.org/join.php

 

[webmaster.hxtt]

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