Re: PO8, D2K and Windows 98

Or, you can use '2:' as the adapter string (service name) and connect directly to the database.

dec98_at_my-dejanews.com wrote:
: All,

: I (and others) have recently had problems getting Personal Oracle 8.0.3 and
: Developer 2000 to work correctly under Windows 98. The problem with PO 8.0.3
: was that the listener (LSNRCTL80.EXE) would crash when you tried to start it.
: The only workaround here is to install PO 8.0.4 - trust me, i've installed PO
: 8.0.4 last night and it works a charm. Oracle has certified PO 8.0.4 on Win
: 98.

: The next problem was to get D2K to connect to oracle. The workaround (which
: I got from Oracle support) is listed here, and yes it also works. Although
: D2K (I am using v2.0) is not currently certified on Win 98. Apparently this
: won't be done until late October. Anyway, here's what Oracle support had to
: say. Hope it helps you all out:

: Personal Oracle8 is supported against Windows98 with the release of 8.0.4
: version. Developer/2000 has not been supported against Windows98. They are
: in the process of testing and hope to be done by late October.
: Developer/2000 uses SQL*Net and Oracle8 uses Net8. Both components must be
: installed and configured. However, when Developer is installed a new
: version of SQL*Net is installed that is not compatible with Oracle8.
: The directions below are to establish a connection between an Oracle 8.0.3
: database and Developer/2000 version 2.0. If you do not have this version of
: the database skip number 3 and continue with the configuration.
: To set up a connection from Developer/2000 2.x to an Oracle8 database you
: must follow the setup steps below:

: 1. Install Oracle8
: 2. Install Developer/2000 version 2.x
: 3. Re-install the Oracle Installer & SQL*Net 2.3.3.0.1
: a. Re-install the Oracle installer from the Oracle8 distribution
: media (i.e. downloaded files or CD).
: b. REMOVE SQL*Net 2.3.4.0.0 and the SQL*Net Adaptors 2.3.4.0.0
: c. Install SQL*Net 2.3.3.0.1 and the SQL*Net TCP/IP Adaptor
: 2.3.3.0.1 from the Oracle8 distribution media.
: Please Note: You will need to make sure you have the TCP/IP protocol
: adaptor installed and configured with a valid IP address for your Operating
: system before continuing. If you are not connected to a network 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
: a. START - PROGRAMS - ORACLE FOR WINDOWS95(NT) - SQL*Net EASY
: Configuration.
: b. ADD a database ALIAS.
: c. Name the Database ALIAS anything you would like.
: d. Select TCP/IP as your protocol Adaptor.
: e. Enter 'localhost' for the TCP/IP Host name.
: f. 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.
: a. go to a DOS command prompt.
: b. type: lsnrctl80
: c. at the lsnrct prompt type: start
: 6. Start up the database
: a. START - PROGRAMS - Oracle8 for NT/95 - Start Database
: 7. Start up Developer
: a. START - PROGRAMS - Developer 2000 r2.x - Forms Builder
: 8. Connecting to the database from Forms Builder
: a. FILE - CONNECT
: b. username - system
: c. Password - manager
: d. Connect String - (enter in the database ALIAS name that
: you created in step 4c)

: Daniel

: -----== Posted via Deja News, The Leader in Internet Discussion ==-----
: http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

--

Jared Hecker	| HWA Inc. - Oracle architecture and Administration
jared_at_hwai.com	|  ** serving NYC and New Jersey **