Re: developer 2000 --> SQL net --> personal Oracle 7

From: Keith Majkut <kmajkut_at_netcom.com>
Date: 1996/07/13
Message-ID: <kmajkutDuGIuC.B00_at_netcom.com>#1/1


In article <4ql48s$mct_at_sjx-ixn3.ix.netcom.com>, Rajkumar Ray <raj_dray_at_ix.netcom.com> wrote:
>n <31C7C777.422A_at_pve.agro.nl> Peter de Wolff <P.C.de.Wolff_at_pve.agro.nl>
>writes:
>>
>>Jose Omar Mosquera wrote:
>>>
>>> I hope somebody can help me;
>>>
>>> I am having great difficulties getting forms4.5 to communicate with
>>> personal Oracle 7; this I believe, is because I haven't set up SQL
 Net
>>> properly.
>>>
>>> I have windows 95, and the windows 95 version of personal Oracle 7.
>>> I can connect to the local database using SQL plus 3.2 ( The one
 that
>>> comes with personal Oracle 7), but if I try SQLplus 3.1 or Oracle
 net
>>> test i get the following error messages:
>>>
>>> With user ID: SCOTT PASSWORD: TIGER and CONNECT STRING blank
>>>
>>> ORA 12203 TNS: Unable to connect to destination.
>>>
>>> With user ID: SCOTT PASSWORD: TIGER and CONNECT STRING: 2:
>>>
>>> ORA 03121: No interface driver connected - function not performed.
>>> ------
>>> I have TCP/IP loaded in my machine, which I use for my dial up
>>> internet connection ( I assume I cannot use for Oracle); I have been
>>> trying to get named pipes to work with Oracle, but I am unsure of
 what
>>> I need in settings/control panel/networks and how to set up named
>>> pipes.
>>>
>>> I have also installed V2 of SQL NET into my machine.
>>>
>>> What am I doing wrong ? How do I get this to work??
>>>
>>> HELP, HELP please !!!
>>>
>>> Jose Omar Mosquera
>>> London
>>>
>>> Jose Omar Mosquera
>>> jose_at_jomh.demon.co.uk
>>>
>>> London
>>
>>
>>Hi,
>>
>>since the connection SQL*Plus 3.2 -> SQL*NET V2(.2) -> Personel Oracle
 works
>>and
>>the connection SQL*Plus 3.1 -> SQL*NET V2 -> Personel Oracle does not
 work
>>your problem is that you have olny installed one version of SQL*Net
 (32-bit) and not the 16-bit
>>version of SQL*NET.
>
>I am also facing the same problem while trying to connect to the local
>database from FORMS4.5 or Reprts 2.5. I would really appreciate if
>anybody can help !!

I can help. Read the README file that came with PO7Win95. It will tell you exaclty what to do. Received on Sat Jul 13 1996 - 00:00:00 CEST

Original text of this message