[SOLVED] Oracle Connection Error

[btayfun]

Failed to connect to the oracle9i of ScriptCase error.

?Connection Error ocilogon(): ORA-12735: Instant Client Light: unsupported client character set NA?

Can you help?

Oracle9i language features ;
NLS_LANGUAGE = TURKISH
NLS_TERRITORY = TURKEY
NLS_CHARACTERSET = TR8MSWIN1254

Oracle 9i runtime installed on my computer.

Oracle Connection Test ;

?My Computer (right button)–> Properties—> tab ?Advanced --> Environment Variables?
ORACLE_HOME = C:\oracle\ora92
Path = C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;
TNS_ADMIN = C:\oracle\ora92
etwork\admin
NLS_LANG = TURKISH_TURKEY.TR8MSWIN1254

lines activated in php.ini
extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client
extension=php_oci8_11g.dll ; Use with Oracle 11gR2 Instant Client
extension=php_pdo_oci.dll
extension=php_pdo_odbc.dll

Scriptcase diagnosis.php ;

[aducom]

mmm, we’re running on Oracle. Will ask ‘rr’ tomorrow to respond.

[rr1]

Scriptcase uses the oracle instant client by default. Yet the oracle instant client basic lite does NOT support all character sets.
See: http://docs.oracle.com/cd/B19306_01/server.102/b14357/ape.htm
You should use the full oracle instant client basic, not the basic lite one.
oracle clients: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
Alternatively you can also use the normal oracle client which is what I do.
Be very aware of the fact that if you are on windows your oracle instant client should be reachable via the path variable (also for services) and that on your development server that the oci.dll and the ociw32.dll may need to be renamed to _oci.dll and _ociw32.dll to force the instant client versions to load. And remember to restart your service for netmake after you have done the rename.
Of course I assumed you use windows…

[btayfun]

I solved the problem by changing registry settings.
Look for the NLS_LANG subkey in the registry at \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE, and rename it.

Thank you for your help.