From: "Robert Comer" 

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