[olug] JDBC - ODBC huh?

[Mac Petras]

Thanks Daniel -

That is the other option - just one I wasn't sure existed.

Basically, rmijdbc will "act" like a "server" for your
application to connect to. It will access the database file and
serve up the information via RMI.  If you were to use it to
access a server (a la SQL Server) it would be more like a
gateway/bridge to the server - a lot of extra overhead if you
don't need it.
_________________________________________
Mac Petras
Mac at PetrasWeb.com


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