Hi, i´ve got a microsoft access database *.mdb in a pc.
in another pc i´ve got an ODBC driver as DSN to connect to this database from windows and i connect to this database from a jsp web. I must change this windows for a linux but, how can i make the migration???.
I must user the same database, it´s imposible to change it!!!!.
anybody know how can i create an DSN with an ODBC in linux and where can i download de Microsoft access driver for linux???

http://mdbtools.sourceforge.net

Assuming you want to read an MS Access database file (.mdb) from a java application on linux without involving a remote JET database engine running on Windows somewhere. Also, beware that the Sun ODBC:JDBC bridge is crap and not intended for production. For the ODBC:JDBC bridge, the www.easysoft.com driver is a quality option, but it cost money.

If anyone knows of other/better strategies for accessing an MS Access mdb file directly from a java program, please let *me* know also.

Also see:
http://rmijdbc.objectweb.org/
http://www.easysoft.com/

Or if you want to use a java API instead of JDBC:
http://jakarta.apache.org/poi/index.html (Java API To Access Microsoft Format Files)


Roger
www.project.net