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

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 - 10:54:30 CST