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

From: Rajkumar Ray <raj_dray_at_ix.netcom.com>
Date: 1996/06/24
Message-ID: <4ql48s$mct_at_sjx-ixn3.ix.netcom.com>#1/1


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 !! Received on Mon Jun 24 1996 - 00:00:00 CEST

Original text of this message