From: "Adam Flinton" 

I'll give it a go tomorrow.

DB2 right?

Adam

"Robert Comer"  wrote in message
news:3e53b0cf{at}w3.nls.net...
> It wasn't, but still nothing after changing it, but I'm still working on
it.
> (this might take awhile!)
>
> - Bob Comer
>
>
> "Adam Flinton"  wrote in message
> news:3e52ab27$1{at}w3.nls.net...
> >
>
http://dba.openoffice.org/FAQ/#1.6.JDBC%E2%84%A2%20Drivers,%20Servers,%20and
> > %20Vendors|outline
> >
> > My guess is that the db2java.zip ain't on the classpath.
> >
> > "Robert Comer"  wrote in message
> > news:3e529758{at}w3.nls.net...
> > > I can't get it to work on this PC, it wont load either the db2, or the
> > > AS/400 jdbc driver...
> > >
> > > "The specified driver could not be loaded!"  in Openoffice.
> > >
> > > - Bob Comer
> > >
> > >
> > > "Adam Flinton" 
wrote in message
> > > news:3e5291b7{at}w3.nls.net...
> > > > I find the opposite. I really can't be bothered messing
around with
> ODBC
> > > > anymore. Have zip, have it on classpath....know URL
& classname...&
> > you're
> > > > off for just about any db.
> > > >
> > > >
> > > > Adam
> > > >
> > > > "Robert Comer"
 wrote in message
> > > > news:3e527f74{at}w3.nls.net...
> > > > > Thanks.  It's not quite as easy as you say the
first time around,
> but
> > I
> > > > bet
> > > > > it'd be easy the next time.
> > > > >
> > > > > ODBC data sources are awfully easy in Windows in
comparison.  What
> we
> > > need
> > > > > is something like the Windows ODBC setup app...
> > > > >
> > > > > - Bob Comer
> > > > >
> > > > >
> > > > > "Adam Flinton"
 wrote in message
> > > > > news:3e527343$1{at}w3.nls.net...
> > > > > > You have to have:
> > > > > >
> > > > > > A) the zip/jar file on the classpath so the
JRE can find it
> > > > > > B) The URL of the DB
> > > > > > C) The classname to call (driver).
> > > > > >
> > > > > > e.g. some settings:
> > > > > >
> > > > > >   
> > > > > >   
COM.ibm.db2.jdbc.net.DB2Driver
> > > > > >   
jdbc:db2://MACHINE/PORT/DATABASE
> > > > > >
> > > > > >   
> > > > > >   
> > > > > >   
oracle.jdbc.driver.OracleDriver
> > > > > >   
jdbc:oracle:thin:{at}MACHINE:PORT:DATABASE
> > > > > >
> > > > > >   
> > > > > >   
> > > > > >    org.postgresql.Driver
> > > > > >   
jdbc:postgresql://MACHINE:PORT/DATABASE;
> > > > > >
> > > > > >
> > > > > > For MySQl go to:
> > > > > >
> > > > > > http://www.mysql.com/products/connector-j/
> > > > > >
> > > > > > & dl the driver.
> > > > > >
> > > > > > the driver classname =  
"org.gjt.mm.mysql.Driver"
> > > > > >
> > > > > > The URL format =  jdbc:mysql://MACHINE:PORT/DATABASE
> > > > > >
> > > > > > Usual ports:
> > > > > > PGSQL:  jdbc:postgresql://servername:5432/name
> > > > > > MYSQL:   jdbc:mysql://servername:3306/name
> > > > > > DB2 net: jdbc:db2://servername/6789/name
> > > > > > Oracle: jdbc:oracle:thin:{at}servername:1521:name
> > > > > >
> > > > > > Adam
> > > > > >
> > > > > > "Joe Barr"
 wrote in message
> > > > > > news:3e526775$1{at}w3.nls.net...
> > > > > > > On Tue, 18 Feb 2003 17:03:53 +0000, Adam
Flinton wrote:
> > > > > > >
> > > > > > > > Walk in the park....
> > > > > > > >
> > > > > > >
> > > > > > > I haven't done this yet, but I have
heard a couple of warnings
> > about
> > > > > > > knowing what some Java class name or
resource name or some
kind
> of
> > > > name
> > > > > is
> > > > > > > before proceeding.  Any truth to that?
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

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