Re: What's the best way to connect to oracle on NT
Date: Fri, 28 Jun 2002 11:46:01 -0700
Message-ID: <uhpbape2ebmi68_at_corp.supernews.com>
install oracle client on your NT machine. Then define the TENS_ADMIN
environment variable (or if you familiar with registry, edit it
accordingly). Copy (ftp) the tsunamis.oar and silent.oar files from your
oracle server (talk to your dab if you do not know where they are located -
I like to put them under /vary/opt/oracle on solaris). Then you will be
able to use sqlplus to connect to your server. You can always use jdbc also
as someone answered before. We are talking about client/server here. You
can also use 9iAS to access from any client machine (NT or otherwise) to
your database server. Oracle licensing issues need to be revisited not to
be surprised later ;)
regards
Safer ACTON
Oracle DAB/Developer
"Rauf Sarwar" <rsarwar_at_ifsna.com> wrote in message
news:c2d690f2.0206240551.44986880_at_posting.google.com...
> "les" <sleszek_at_hotmail.com> wrote in message
news:<YjwR8.1107$ZM3.243712_at_news20.bellglobal.com>...
> > Hello,
> >
> > What is the best way to connect to oracle database on NT.
> > 1) JDBC - JDBC (any samples, tips, links?)
> > 2) JDBC - ODBC (any smaples, tips, links?)
> > 3) ???
> >
> > I'm new to database connections so any advice is welcome on drivers
setup
> > steps and configuration.
> >
> > I need to access oracle database hosted on NT from JSP files hosted on
> > solaris.
> >
> > Any help is greatly appreciated,
> > Leszek
>
>
> JDBC thin or JDBC oci7/8. You can look at examples for both in
> ORACLE_HOME\jdbc\demo\demo.zip file.
>
> Oracle net8/sqlnet required if you are using oci7/8 driver.
Received on Fri Jun 28 2002 - 20:46:01 CEST