Re: connecting to an ACCESS database

Hi Camila, 
I think Darius is right, MS Access isn´t your better choice. However i 
think you were not looking for a suggestion on what DBMS you sould or not 
use, although he has reason too.
To get connected directly to an SQL Data Base System like MySQL, 
PostgreSQL or Microsoft SQL you should use the IP address or server´s 
name and the server´s port where the BDMS is listening for connections. 
 
 Here is the original text from the "Java Expert Solutions" book

--- True to the nature of the Internet, JDBC identifies a database with 
an URL. The URL is of the form:
jdbc:<subprotocol>:<subname related to the DBMS/Protocol> 
For databases on the Internet/intranet, the subname can contain the Net 
URL //hostname:port/? The <subprotocol> can be any name that a database 
understands. The odbc subprotocol name is reserved for ODBC-style data 
sources. A normal ODBC database JDBC URL looks like: 
jdbc:odbc:<>;User=<>;PW=<> 
If you are developing a JDBC driver with a new subprotocol, it is better 
to reserve the subprotocol name with JavaSoft, which maintains an 
informal subprotocol registry.----

Romel.

-----Original Message-----
From: "Darius Katz" <darius.katz@xxxxxxxxxx>
To: enhydra@xxxxxxxxxxx
Date: Mon, 16 Dec 2002 21:00:58 +0100
Subject: Re: Enhydra:  connecting to an ACCESS database

> MS Access is not a true DBMS, but an advanced, SQL-compatible
> file-access system. There is no "direct" way to connect to MS Access
> but
> through the Jet Engine. That's what ODBC does for you if you can't
> access the API yourself.
> 
> I think MySQL is a better choice or even PostgreSQL which is also a
> free, open source database.
> 
> -- Darius
> 
> > Camila Piñeiro wrote:
> > 
> > Hi!
> >  I'm using an Access database in my application, and I conecct to it
> > thru the odbc:
> >     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> >     conn = DriverManager.getConnection("jdbc:odbc:bd");
> > but I want to do it directly, with out the ODBC.
> >  I read in the manual "Getting started with Lutris Enhydra" that
> there
> > is no other way if the database is in Access. Is it still true?
> >  If it is, can you tell me what do I have to do if my database is in
> > MySQL?
> >  Thanks a lot,
> > Camila
> 
> _______________________________________________
> Enhydra mailing list
> Enhydra@xxxxxxxxxxx
> http://www.enhydra.org/mailman/listinfo.cgi/enhydra