[olug] JDBC - ODBC huh?

[Mac Petras]

Well, I'm kinda new to Java but here's what I'm thinking....

MS Access is not a database server, it is a file-based RDBMS.
ODBC for MS Access will allow you access the file with a generic
interface. If that file is on another machine, you access the
database file via a Windows Share.

Now since you're running, Linux, this gets a tad more difficult
in that you will most likely need to mount the windows share
using Samba.  Then, theoretically, you might be able to have
read/write access to the file.

Make sense?  I'm a relative newbie to Linux/Java, so please
correct or expound on this if you have more/better info.....
_________________________________________
Mac Petras
Mac at PetrasWeb.com


Eric Penne said:
> Here's my situation:
>
> Linux Tomcat server needs to access MS Access database on
> NT4 server.
>
> What I know:
>
> The MS Access database can be accessed via ODBC.
>
> What I need verification of:
>
> A JDBC-ODBC driver is a driver that allows the Tomcat server
> to speak "JDBC" and the driver converts it to "ODBC".  The
> "ODBC" command can then be sent through whatever medium
> (internal to the machine, network, etc.) to an ODBC-MS
> Access driver that will return the information requested.
> If this is internal to the machine it would make sense to
> have a direct JDBC-MS Access driver.  If it is over the
> network the ODBC interface to the database allows any
> machine that sends ODBC
> queries to access the database.
>
> Is this correct?
> If so, I should not have to touch the NT4 machine running MS
> Access at all if it has an ODBC interface.  All I should
> have to do is setup JDBC-ODBC driver on the Tomcat server.
>
> I've looked at one JDBC-ODBC driver from
> http://www.easysoft.com but it is really expensive for the
> application we are looking at.  Is there any  open source
> JDBC-ODBC drivers?
>
> Thanks
> Eric
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
> _______________________________________________
> OLUG mailing list
> OLUG at olug.org
> http://lists.olug.org/mailman/listinfo/olug