[olug] JDBC - ODBC huh?

[Jonathan Warren]

Access is not a good DB format.  If you must stay there I can understand it but if you can migrate there are a lot of alternatives.  

On Mon, Mar 10, 2003 at 03:19:03PM -0600, andrew wrote:
> A windows machine needs to be running the db in order for you to access 
> it over ODBC.  The ODBC-JDBC bridge mostly works (though some JDBC 2.0 
> stuff doesn't work, and getting a list of primary keys is NOT trivial). 
> MSDE (which is what I would suggesting converting your access db into) 
> works with a pure jdbc driver from freetds.org ... (this driver also 
> works with MSSQL servers and as a super happy bonus, it's free)
> 
> You can't expose an ODBC interface to a Microsoft db from a linux box 
> (unless something new has happened in the last year or so).  If you are 
> running from Access you must serve it from an MS box.  
> 
> There are apps out there that can help you convert your Access DB into 
> something more cross platform and/or standards compliant.
> 
> andrew
> 
> 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
> > 
> >
> 
> 
> 
> _______________________________________________
> OLUG mailing list
> OLUG at olug.org
> http://lists.olug.org/mailman/listinfo/olug