[olug] JDBC - ODBC huh?

[andrew]

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