From: "Adam Flinton" 


"Robert Comer"  wrote in message
news:3e52700c{at}w3.nls.net...
> How do I know the name of the driver?  I have gobs of things with jdbc in
> the name.
>

Look it up. See my posting to Joe on this thread.


> I can't seem to call the JDBC driver manager to register a data source
from
> a java program either. (in windows, just trying things while waiting for
the
> download.) I bet it's my classpath, but this stuff is confusing since I'm
> not a Java programmer. 
>

There ain't no such thing as a JDBC driver manager.....it's all done via
URLs. Do you register all the web pages you browse with a "Web Page
manager"? All you need is the jar on the classpath & 2 strings
(classname & DB URL).....(4 if you want to pass in name & pw as
well).

OK to recap ..you need:

A) the driver file (zip or jar usually) B) This file needs to be in the
classpath of the app using it (simplest to set it into the global Java
classpath) C) The name of the class (see post to Joe) D) the URL of the DB
(see post to Joe) E) A username & password (that's up to you).


Adam

> - Bob Comer
>
>
> "Adam Flinton"  wrote in message
> news:3e526f0b{at}w3.nls.net...
> > Yup in OpenOffice.
> >
> > Adam
> >
> > "Robert Comer"  wrote in message
> > news:3e52678c{at}w3.nls.net...
> > > > 2) go to tools/datasources
> > >
> > > In Openoffice?  (I don't have that installed here, but I download
it...)
> > >
> > > - Bob Comer
> > >
> > >
> > > "Adam Flinton" 
wrote in message
> > > news:3e52641f{at}w3.nls.net...
> > > > Walk in the park....
> > > >
> > > > OK
> > > > 1) Make sure you have the jre installed & the JDBC
driver file to
hand
> > > > somewhere on your PC
> > > > 2) go to tools/datasources
> > > > 3) Click on the "New Data Source"
> > > > 4) select the database type of "JDBC" &
enter the URL in the "Data
> > source
> > > > URL"
> > > > 5) Click on the tab marked "JDBC" & fill
in the rest of the details.
> > > >
> > > > Job done. If you then want to see the tables etc click on the
"Tables"
> > tab
> > > > etc.etc.
> > > >
> > > > This is the same on both Windows & Linux. Compare
the above to Joe
> > trying
> > > to
> > > > get ODBC running on Linux.
> > > >
> > > > Adam
> > > >
> > > >
> > > >
> > > > "Robert Comer"
 wrote in message
> > > > news:3e524278{at}w3.nls.net...
> > > > > > Biggest ease of use problem is soluable very
easily. It's called
> > "use
> > > > > JDBC".
> > > > >
> > > > > I've seen very little about how to set up JDBC
unfortunately, and
> for
> > > ease
> > > > > of use, we're talking users, not programmers.  I want to see
things
> > > about
> > > > > how to set up your
spreadsheet/wordprocessor/querytools to access
> data
> > > via
> > > > > JDBC.
> > > > >
> > > > > - Bob Comer
> > > > >
> > > > >
> > > > >
> > > > > "Adam Flinton"
 wrote in message
> > > > > news:3e523646{at}w3.nls.net...
> > > > > > Biggest ease of use problem is soluable very
easily. It's called
> > "use
> > > > > JDBC".
> > > > > >
> > > > > >
> > > > > > Adam
> > > > > >
> > > > > > "Joe Barr"
 wrote in message
> > > > > > news:3e5234d6$1{at}w3.nls.net...
> > > > > > > OpenOffice.org is more sophisticated and
powerful than I
> realized.
> > > It
> > > > > can
> > > > > > >  be made to work with various
database-management systems, and
> it
> > > can
> > > > do
> > > > > > >  the mailmerge functions required by
many SOHO types.
> Ease-of-use
> > > > issues
> > > > > > >  need attention.
> > > > > > >
> > > > > > > http://www.linuxworld.com/2003/0217.barr.html
> > > > > > > --
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

--- BBBS/NT v4.01 Flag-4