Re: Personal Oracle 8 & Developer/2000

From: Paul Couchman <paul.couchman_at_kvaerner.com>
Date: Thu, 20 May 1999 12:41:25 GMT
Message-ID: <37440164.20115033@news.kvaerner.com>

I had a similar problem, but this was on NT 4.0. The below comments are not necessarily applicable to Win95.

The main problem is that Developer/2000 V2 has no knowlege of Net8 and so SQL*Net V2 needs to be used. You will need to ensure that the database listener is running and that you have a TNSNAMES.ORA entry for connection to the listener. Below is a listener.ora entry and a tnsnames.ora entry I used for connection to the database:

You can then connect as user/pass_at_DBLOCAL.world

Hope this is of some help, and does not cause confusion. It was some time since I had this problem and haven't pursued it much recently.

Paul

LISTENER.ORA

LISTENER =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = TCP)(PROTOCOL = TCP)(Host =
<machine>)(Port = 1521))

(ADDRESS = (PROTOCOL=IPC)(KEY=ORCL))
)

CONNECT_TIMEOUT_LISTENER = 10 SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =

      (SID_NAME = ORCL)
    )
(SID_DESC = (SID_NAME=ORCL))

  )

TNSNAMES.ORA

#
# Local ORACLE database
#

DBLOCAL.world =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = TCP)
          (PROTOCOL = TCP)
          (Host = <machine_name>)
          (Port = 1521)
        )

    )
(CONNECT_DATA = (SID = ORCL)

    )
  )

On Mon, 03 May 1999 10:39:59 GMT, uytterhoeven_at_my-dejanews.com wrote:

>Hi,
>
>I've downloaded the trial products 'Personal Oracle 8' and Deloper/2000 v.2.
>When I installed PO8 I guess everything worked fine. I could access the
>database with SQL*Plus with account/password (SCOTT/TIGER) and no
>connectionstring. I now want to use Developer/2000 but I'm not sure which
>bits I have to install so I installed everything. When I tried to create a
>form linked to Personal Oracle then it seems that using just the account and
>password don't work. If i have to use a connection string which one would it
>be? Do i have to do something with ODBCAdmin and how? What about SQL*Net?
>ETC.....
>
>Please help getting my developer tools connected to my local databse?
>
>THANKS!!!!!!!
>
>Uytterhoeven Walter
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own

Received on Thu May 20 1999 - 07:41:25 CDT