Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 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
![]() |
![]() |