Re: help tnsnames

I am assuming that developer is installed on the same machine as Oracle8i. If not you don't have a prayer of connecting to a non-networked server :). I am also assuming that you have a tcp/ip stack on the server even if there is no network connection the loopback (127.0.0.1) connection will work if there is a tcp/ip stack present.
The developer tnsnames.ora should have an entry like this:

envela.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

      (ADDRESS =
           (PROTOCOL = TCP)
           (HOST = 127.0.0.1)
           (PORT = 1521)
       )
    )
    (CONNECT_DATA =      (SID = envela)

Richard Cuello wrote in message <3892508B.8D4FA22C_at_columbia.edu>...
>I wanted to thank you for your help. Unfortunately, It
>didn't work. But, I am learning the mechanics. : )
>
>My global database name: ENVELA
>database system Identifier: ENVELA
>Internal Password: Oracle
>Sys account password: change_on_install
>System account password: Manager
>
>I followed the steps and substituted the the sid(ORCL)
>with (ENVELA).
>
>I'm providing you a copy of the the Tnsnames file for developer 6.0 and
>Oracle 8i.
>Can you please look over it and see what I'm doing
>wrong.
>
>Question: What is the host name? I named my computer
>(NEO). It isn't networked.
>Question: Could you connect to the database through
>forms and reports with the system/manager password?
>
>thanks again
>Jonus
Received on Mon Jan 31 2000 - 00:00:00 CET