[olug] JDBC - ODBC huh?

[Jonathan Warren]

I think odbc can handle network connections.  Not really sure though. 

On Mon, Mar 10, 2003 at 09:57:57AM -0600, Mac Petras wrote:
> 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
> 
> 
> 
> 
> 
> _______________________________________________
> OLUG mailing list
> OLUG at olug.org
> http://lists.olug.org/mailman/listinfo/olug