[olug] JDBC - ODBC huh?

[Daniel Pfile]

Mac is right, odbc can, but not ms access, you config the data source 
in the os (nt) and then the os handles using libraries to talk to the 
db. Using network mounts you can share an access db over the network, 
as long as the client machine is nt.

What he needs is an rmijdbc bridge. The server with the access db will 
need to run a small java rmijdbc bridge.

Here's sun's faq topic on it:
http://java.sun.com/products/jdbc/faq.html#5

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

-- Daniel

On Monday, March 10, 2003, at 10:18 AM, Jonathan Warren wrote:

> 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
> _______________________________________________
> OLUG mailing list
> OLUG at olug.org
> http://lists.olug.org/mailman/listinfo/olug