From: "Adam Flinton" 

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