ODBC Connection

Thread view:

Bob - 17 Dec 2006 00:10 GMT

Hi

Quick question. I have a CACHE link into an old mumps based system. In order
to access the old tables I install an ODBC driver and then access the tables
using access or some other DB tool. I can also query them from my
applications.

My question is....Can I connect to the database from my Java applications
without installing the ODBC driver on every machine.

To simplify things I have an access database sitting on a shared network
drive with the link tabls i need.

Thanks

J

Reply to this Message

Jeff - 19 Dec 2006 23:47 GMT

> Hi
>
[quoted text clipped - 12 lines]
>
> J

The "without installing the ODBC driver on every machine" is the hard
part, which is probably why no other responses. The challenge here is
that _something_ needs to know how to talk to the mumps DB. Java
doesn't inherently, so therefore there will need to be some sort of
software that is installed on the client machines so they can talk
mumps. Other than ODBC, you would need a Java mumps driver (like
JConnector is for MySQL). A quick google search on java mumps found at
http://www.abcisp.com/m01s02.html something called ESIObjects, which is
open source and supposedly connects java apps to mumps dbs. Worth a
look.
/js

Reply to this Message

ODBC Connection

Free Magazines