Connecting Developer 2K or Discover 3 to PO 8

Here is what Oracle says.

Good luck

Madhu Cherukuri

Developer/2000 is an Oracle7 based tool which uses a SQL*Net connection to communicate with the database. Oracle8 uses a new networking standard for communicating with it's databases called Net8. In order for an Oracle7 tool to be able to communicate to an Oracle8 database, you must install and configure SQL*Net.

When Developer/2000 version 2.0 is installed a version of SQL*Net is installed that is not compatible with Oracle8 version 8.0.3. The following steps will need to be completed in order to set up a connection from Developer/2000 2.x to an Oracle8 database.

  1.Install Oracle8 version 8.0.3
  2.Install Developer/2000 version 2.x
  3.Re-install the Oracle Installer & SQL*Net 2.3.3.0.1
        Re-install the Oracle installer from the Oracle8 distribution media
[Quoted] (i.e. downloaded files or CD).
        REMOVE SQL*Net 2.3.4.0.0 and the SQL*Net Adapters 2.3.4.0.0
        Install SQL*Net 2.3.3.0.1 and the SQL*Net TCP/IP Adapter 2.3.3.0.1

        (A different version of SQL*Net may be installed on your system if you are not using version 2.0 of Developer/2000.

        This is OK. The current version of SQL*Net and the SQL*Net TCP/IP Adapter will need to be removed. Then you

        will be able to Install SQL*Net 2.3.3.0.1 and the SQL*Net TCP/IP Adapter 2.3.3.0.1 from the Oracle8 distribution

        media.)

    Please Note: You will need to make sure you have the TCP/IP protocol adapter installed and configured with a valid IP

    address for your operating system before continuing. If you are not connect to a network you can set your IP address to be

    obtained automatically. If you do not know how to configure TCP/IP please check with your network administrator or

    contact Microsoft for assistance.

  4.Configure a SQL*Net ALIAS for your Oracle8 database

        START -> PROGRAMS -> ORACLE FOR WINDOWS95(NT) -> SQL*Net EASY Configuration.

        ADD a database ALIAS.
        Name the database ALIAS anything you would like.
        Select TCP/IP as your protocol adapter.
        Enter 'localhost' for the TCP/IP host name if you are connecting to
a local database.
        The database Instance will be the same as the database SID, which is
ORCL if you are using the default database
        installed with Oracle8.
  5.Start the listener.
        Go to a DOS command prompt.
        Type: lsnrctl80
        At the lsnrct prompt type: start
  6.Start up the database
        START -> PROGRAMS -> Oracle8 for NT/95 -> Start Database
  7.Start up Developer
        START -> PROGRAMS -> Developer 2000 r2.x -> Forms Builder
  8.Connecting to the database from Forms Builder
        FILE -> CONNECT
        Username -> system
        Password -> manager
        Connect String -> (enter in the database ALIAS name that you created

   -**** Posted from Supernews, Discussions Start Here(tm) ****- http://www.supernews.com/ - Host to the the World's Discussions & Usenet Received on Mon Nov 09 1998 - 20:13:29 CET