Connection Oracle 7 and charset

[derek duncan]

Laurence,

I don't know if this well help, but here are some pointers:

1) Run DBADMIN in debug mode and check the Oracle error reported in the
debug window.

You might find that ORA-1001 reported by DBADMIN is in fact reported in the
debug window as "ORA-01005: null password given; logon denied". This is
due to password encoding problems with the 8 bit characterset (the default
is US7ASCII). Other developers have however reported that 8859P1 works ok.

2) Try NLS_LANG=English_America.WE8ISO8859P1 (this was mentioned in a NAS
support article). Remember to export the variable.

3) Which version of Oracle client are you using? Netscape 3.63 was only
ever certified on Oralce 7.3.4, you may have problems with 8 or 8i client.

The strange thing is that I found this prolbem on NES 4, but 3.63 was fine!

Regards, Derek

Laurence Davi <lauren...@finances.gouv.fr> wrote in message
news:39B6424B...@finances.gouv.fr...
> Hi,
>
> We use Netscape Enterprise 363 (Unix) connecting via SSJS to Oracle.
>
> We would like to use iso-8859-1 and when we try to set
> NLS_LANG=american_america.WE8ISO8859P1 in the file start, we can't
> connect to the database with application dbadmin. If we don't have this
> parameter, the connection is OK but we haven't our character set with
> accents (latin).
> The error code is ORA-01001:invalid cursor.
>
> Thank's for your help.
> Laurence
>

[Laurence Davi]

Derek,

When we try NLS_LANG=English_America.WE8ISO8859P1, with the debug, the error is:

ORA- 12705 Invalid or unknown NLS parameter value specified.

I think that we'll try with client 7.3.4

Thank's
Laurence

derek duncan a écrit :

[Jim Martin]

I'm not sure that this will clear things up, but I've had problems with
international characters in SSJS/Oracle before. My results have always
pointed to the error being in the Oracle Listener's configuration. As well,
we had similar problems with another application that was built using Oracle
Forms with the same listener through a WinFrame client.

Hope that helps.

Jim Martin, B.Sc.
Director, Strategic Web Services
Klay Information Management Consulting Ltd.
(403) 263-6463 (phone)
(403) 263-6437 (fax)
http://www.kimc.com
Brainbench 'Most Valuable Professional' for JavaScript
http://www.brainbench.com

Laurence Davi <lauren...@finances.gouv.fr> wrote in message

news:39C0E980...@finances.gouv.fr...

[Froylan A Loaiza Villanueva]

hi, i have Enterprise Server 3.6 and have been working fine with ISO8859P1
using the environment variable NLS_LANG=English_America.WE8ISO8859P1
before starting the server...

using a 7.3.4 client. ...

recently i have been testing the Iplanet server and i think it won't work ...
i have NES 4.1 and an oracle 7.3.4 client...
i used the NLS_LANG=English_America.WE8ISO8859P1 variable.