From: "Robert Comer" 

> DB2 right?

I'm trying both the DB2 and the AS/400 drivers...

- Bob Comer


"Adam Flinton"  wrote in message
news:3e53bc42{at}w3.nls.net...
> 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