Re: ODBC Connection




Bob wrote:
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
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

.



Relevant Pages

  • Re: MUMPS - Java/Oracle
    ... into predominantly Oracle and JAVA enterprise systems. ... This has been true in every big system, and MUMPS systems have the ... of the programmer as much as the syntax of the language. ... I would be surprised that Cache didn't have ACID features. ...
    (comp.lang.mumps)
  • Re: MUMPS - Java/Oracle
    ... into predominantly Oracle and JAVA enterprise systems. ... JAva is said to be particularly good at handling complexity. ... and constrast that with the size of the Mumps world, ... But, be that as it may, Cache will have to compare itself "toe to toe" ...
    (comp.lang.mumps)
  • Re: MUMPS - Java/Oracle
    ... JAva is said to be particularly good at handling complexity. ... and constrast that with the size of the Mumps world, ... I understand that Cache has added ACID features to the basic mumps sparse matrix idea. ... Does cache support Xquery to directly query XML documents? ...
    (comp.lang.mumps)
  • Re: ODBC driver needed need for the java app
    ... Do anyone have idea of the ODBC driver needed for a simple java ... application accessing the ORACLE DB? ... install the oracle client in local Or ...
    (comp.lang.java.programmer)