From: "Adam Flinton" 

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