testing database connection

654810

when i test the connection in JDeveloper i get the following error message

ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

i have done this connection test on 2 other machines with similar environments and i had no problems getting the connection established
help!

John Stegeman

Unset the NLS_LANG environment variable if it's set. Also check the registry (if you're on windows) HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE.

John

Timo Hahn

Hi, the second error ORA-12705 indicated something is wrong with the NLS parameter settings on the machine you try the connection with.
Did you check the NLS parameters unter tools->preferences->database->NLS-Parameters?
Can you connect with SQLDeveloper?

Timo

John Stegeman

Hi Timo,

That is only available with JDev 11 - not 10

J

654810

John

It appears that the information you gave me will be helpful but remember that i am new to this

could you give me some guidance on unsetting the nls_lang parameter

thanks

shelley

Timo Hahn

Hi,
to unset an environment variabel, right click on my Computer->preferences->more preferences and click the environment variables button. Check if you find the NLS_LANGUAGE parameter and remove it.

Timo

654810

many thanks

shelley