Re: Personnal Oracle 8 - Cannot create a connection service ? Help!

I have 3 tnsnames.ora.

    C:\orant\net80\admin
    C:\orant\net80\admin\sample
    C:\orant\net80\tnsapi

I've set the TNS_ADMIN variable as you told me... No change :( If I ping my IP with the TNSPING80 utility, I got a "No listener" ... If I take a look at the service utility under Windows 2000 Pro, I don't see nothing like Oracle, is it normal?

"news" <support_at_javautil.com> a écrit dans le message news: aDYK5.47717$%t3.2691720_at_news1.rdc1.tx.home.com...
> Do you have more than one tnsnames.ora?
> If multiple products are installed this frequently occurs.
>
> Although oracle doesn't recommend it on WINTEL the TNS_ADMIN environment
> variable works as well
> on NT as it does on unix.
> TNS_ADMIN=d:\orant\net80\admin
>
> or where the desired tnsnames.ora file is located.
>
> delete all of the others.
>
> do you have a sqlnet.ora file?
> do you have tnsping installed?
>
> "Christian Hamel" <christianhamel_at_sympatico.ca> wrote in message
> news:SgXK5.402426$1h3.10795739_at_news20.bellglobal.com...
> > Hi,
> > I've just installed Personnal Oracle 8i on my desktop (Win2000 Pro).
 It
> > install POlite as a default database. I created a new one, let's call
 it
> > MyDB. If I check in the ODBC Adminstration under Windows2000, it
 created
 a
> > POLite Data source with a driver Oracle Lite 40 ODBC Driver. So I
 created
> > an exactly one for MyDB. If I go with Excel -> Microsoft Query, I can
> > easily access my new created MyDB and extract the data from it.
> > My problem is that I cannot access it from SQL Plus. I tried to
 define
> > a new service with Oracle Net8 Easy Config but it doesnt work. MyDB is
> > local on my PC, so I tried to define different type of Service, IPC
 Local,
> > Bequeath, and evenly TCP/IP using my local IP. It never connect when I
 try
> > to test my new connection. I created a user in my database. So I try
 to
> > connect with my new user created and I try with the user SYSTEM too for
> > which I didnt change the default password that is blank..
> > Any help and idea would be greatly appreciated. Thanks!
> >
> >
> >
>
>
Received on Sun Oct 29 2000 - 11:05:27 CST