Re: Connecting to Personal Oracle 8 from Dev2k Forms

You are not alone! I have been trying to get the full version to work; I've now given up for the moment and reverted to a trial version of PO7 and Dev/2k. However, this was posted yesterday and I hope it helps.

MRife_at_admin.usf.edu (Michael A. Rife) wrote:

>With the help of Gina at Oracle Web support (web-sup_at_us.oracle.com) I was
>able to get Developer/2000 communicate to Personal Oracle8 via TCP/IP in
>NET8. All the software is running on the same PC. The PC is a standalone
>PC (not connected to a network) running Windows95. Developer/2000 is a
>trial release 2.
>
>I followed the instructions that Oracle support sends out for getting
>Dev/2k to talk to Personal Oracle8. (Connect Oracle Support at
>web-sup_at_us.oracle.com for the instructions.) It did not work. I had to
>do the following to get it to work:
>
>1) I noticed that SQL*Net EASY configuration software (which Oracle
>Support recommended to use to configure SQL*Net) was not updating the NET8
>directory. It was changing the NETWORK directory. I copied the
>TNSNAMES.ORA and LISTNER.ORA files in the C:\ORAWIN95\NETWORK directory to
>the C:\ORAWIN95\NET8 directory.
>
>2) The Oracle Support instructions tell you to go into the TCP/IP
>properties in Windows95 and specify an IP address. This is fine as long
>as you are connected to a network and do not automatically receive an IP
>address at connect time from your ISP (Internet Service Provider). In my
>case specifying an IP address in the TCP/IP properties caused me to lose
>the ability to connect to anything through my ISP including my e-mail
>service. I left my TCP/IP IP address as "obtain the IP address
>automatically". In the NET8 files I used the IP address of 127.0.0.1
>(localhost).
>
>Here is my C:\orawin95\net80\admin\tnsnames.ora file:
>
>ORACL.world=
> (DESCRIPTION =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = localhost)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = orcl)
> )
> )
>
>Here is my C:\orawin95\net80\admin\listner.ora file:
>
>LISTENER =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = 127.0.0.1)
> (Port = 1521)
> )
> )
>STARTUP_WAIT_TIME_LISTENER = 0
>CONNECT_TIMEOUT_LISTENER = 10
>TRACE_LEVEL_LISTENER = ADMIN
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = ORCL)
> )
> )
>
>
>I hope this helps. Thank you very much Gina at Oracle Support!!!
>

"Rose Noel Kamene" <rkamene_at_easynet.co.uk> wrote:

>I have recently downloaded Personal Oracle 8 from the vendor's website and
>successfully installed it on my machine. But when I try to connect to the
>database from FormsBuilder in Developer2000 , I get the error message "No
>Interface Driver". I don't know what to do as all the Required Support
>Files are in place. Any assistance is welcomed. I am using Windows95
>Regards,
>RN Kamene.
>
>
Received on Wed Jul 01 1998 - 06:47:32 CDT