Re: Oracle Lite 8i TNS Names how to setup ?
Date: Sun, 27 Aug 2000 21:41:03 +0200
Message-ID: <967405243.28280.1.pluto.d4ee154e_at_news.demon.nl>
Hi Stefan,
I only saw Oracle Lite briefly, I immediately dumped, as it is too limited
compared to the 'normal' database.
AFAIK Oracle lite contains a stripped version of sqlnet. It *might* be
impossible to connect to other databases at all. But yes, you can't create a
database in Oracle Lite, and you can only connect to the Oracle lite
database by using the ODBC string. You would guess that setting up the LOCAL
string value in hkey\local_machime\software\oracle works as asual, removing
the need to type a connect string.
Regards,
Sybrand Bakker, Oracle DBA
"Stefan Kursawe" <skursawe_nospam_at_earthlink.net> wrote in message
news:WbGp5.27$r5.1432_at_newsread03.prod.itd.earthlink.net...
> Hi Sybrand,
>
> I read the "Getting Started Document", but didn't find the odbc: connect
> string.
>
> What do I need the TNSNAMES.ORA then, if I only run Oracle 8iLite ?
> It only has to be configured, if I want to connect to a database other
than
> Lite ?
>
> How can I set the "odbc:polite" as a default, so I don't need to type it
> everytime ?
>
> regards
> Stefan
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote
> news:967182547.11644.0.pluto.d4ee154e_at_news.demon.nl...
> > It is.
> > Faced this issue before.
> >
> > Regards,
> >
> > Sybrand Bakker, Oracle DBA
> > "Stefan Kursawe" <skursawe_nospam_at_earthlink.net> wrote in message
> > news:Abjp5.68$H_1.3642_at_newsread2.prod.itd.earthlink.net...
> > > Thanks Selim,
> > >
> > > the odbc connect did work, is this the only way to connect to Oracle
Lite
?
> > >
> > > Stefan
> > >
> > > > Hi Selim,
> > > >
> > > > I will give it a try as soon I get home, but does it mean I don't
need
to
> > > > configure TNSNAMES.ORA
> > > > at all, will my Oracle Lite DB only be accessed thru ODBC ??
> > > >
> > > > regards
> > > > Stefan
> > > >
> > > > <selim007_at_my-deja.com> wrote in message
news:8o3mpp$320$1_at_nnrp1.deja.com...
> > > > > Try this:
> > > > >
> > > > > User name : SYSTEM
> > > > > Password : <anything> (initially the SYSTEM password is null)
> > > > > Host String: ODBC:POLITE
> > > > >
> > > > > In article
<D_Em5.8550$Cc2.318503_at_newsread1.prod.itd.earthlink.net>,
> > > > > "Stefan Kursawe" <skursawe_at_earthlink.net> wrote:
> > > > > > Hi,
> > > > > >
> > > > > > after the Oracle Lite 8i download I am not able to connect
to
my
> > > > > > local POLITE.ODB through SQL*PLUS.
> > > > > >
> > > > > > How do I have to set my TNSNAMES.ORA that it looks for my
local
DB ?
> > > > > >
> > > > > > thanks for help
> > > > > > Stefan
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
>
>
Received on Sun Aug 27 2000 - 21:41:03 CEST