I have windows xp sp-1a, firstly i have installed developer 2000 in C:\orant and Oracle9i server in C:\oracle folders, i am unable to connect to the oracle9i database through developer 2000 form builder it gives a TNS error.
prem.:confused:
Printable View
I have windows xp sp-1a, firstly i have installed developer 2000 in C:\orant and Oracle9i server in C:\oracle folders, i am unable to connect to the oracle9i database through developer 2000 form builder it gives a TNS error.
prem.:confused:
Since u have installed them in seperate directory there will be 2 TNSNAMES.ORA files in their network folder.So make appropriate changes in the c:\orant\network\tnsnames.ora file.
Ahem..... that would beQuote:
c:\orant\network\tnsnames.ora file.
c:\orant\network\admin\tnsnames.ora file.
Even after doing it is giving the same problem. I replaced the C:\orant\network\admin\tnsnames.ora with the oracle's tnsnames.ora, even then i am getting the same problem.
contents of tnsnames.ora and exact error pleaseQuote:
Originally posted by themaskofzorro
Even after doing it is giving the same problem. I replaced the C:\orant\network\admin\tnsnames.ora with the oracle's tnsnames.ora, even then i am getting the same problem.
Also post the file SQLNET.ORA that resides in the same folder (.../network/admin)
I am getting ORA-12705:INVALID OR UNKNOWN NLS PARAMETER VALUE SPECIFIED Error when i try to connect from d2k to oracle 9i server
SQL> !oerr ora 12705Quote:
Originally posted by themaskofzorro
I am getting ORA-12705:INVALID OR UNKNOWN NLS PARAMETER VALUE SPECIFIED Error when i try to connect from d2k to oracle 9i server
12705, 00000, "invalid or unknown NLS parameter value specified"
// *Cause: The NLS parameter value specified in an alter session statement
// is not valid or not implemented.
// *Action: