Re: Personal Oracle 8 & Dev/2000

Try this:
Installing Personal Oracle 8.0x:

When you install PO8 you have to install 'Oracle Networking Products 2.3.4.0.2'. This option includes 'SQL*Net 2.3.4.0.2' and the 'Oracle Protocol Adapters' (Named Pipes, SPX & TCP/IP). At the end you should have installed SQL*Net 8.0.x & 2.3.4.0.2 and Oracle Protocol Adapters 8.0.x & 2.3.4.0.0.

Installing Developer 2.1:

SQL*Net is still installed and therefore it will not be installed when you p.e. install FORMS 5 (the SQL*Net-version on the Developer-CD is an older version). You shouldn't install SQL*Net yourself!!

Now you should be able to connect from Developer 2.1 (FORMS 5, REPORTS 3, SQL*Plus 3.3) to the Oracle 8-database.

Ashok Upadhyay <aupadhya_at_earthlink.net> wrote in message news:36548906.9CDCFC7_at_earthlink.net...
>you have to have a tnsname (connect string name) in order to get it
>connected. You can search for tnsnames.ora in your file system, open it
>and copy a name tcp-loopback to some other name (Say Local) with all
>standard parameter like host name /Ip address (Let all this this be
>default) the service name (Protocol) need to be tcpip. (Alternatively
>net8 easy config can be used to create tnsname).
>After this seach for lsnrctl executable in oracle_home/bin (Say
>c:\orawin95/NT\bin) , type start once you get the prompt.
>Now you are all set to use connect string Local.
>
>Hope this helps
>Ashok
>
>Paul Rosenthal wrote:
>
>> I have done a std install of PO8.
>>
>> The supplied sqlplus 8 connects fine, no connect string required.
>>
>> Then Dev/2k R2.1 (i.e. forms5)
>>
>> But it won't connect without a connect string.
>>
>> But what is the connect string when using PO8 under W95 standalone.
>>
>> Am I missing something obvious here?
>>
>> Thanks in advance.
>>
>> Paul Rosenthal
>
Received on Fri Nov 20 1998 - 05:05:13 CET