[olug] JDBC - ODBC huh?

[Nick Walter]

Here's a step-by-step walkthrough:

http://www.objectweb.org/rmijdbc/Access/access.html

I researched this awhile back and it looked possible, but my project changed
requirements and so I never actually tried it.  I'd be interested to know
how well it works for you.

Nick Walter

----- Original Message -----
From: "Eric Penne" <epenne at yahoo.com>
To: <olug at olug.org>
Sent: Monday, March 10, 2003 6:05 AM
Subject: [olug] JDBC - ODBC huh?


> 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
>