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

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 - 09:22:26 CST