From: "Robert Comer" 

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