On Mar 23, 4:57 pm, crowndbt <crown...@gmail.com> wrote:
> What is the fix for this error message:
> 03/23 16:52:12 - ORA-12737: Instant Client Light: unsupported server
> character set WE8ISO8859P15
> 03/23 16:52:12 - End of connection detected
> 03/23 16:52:12 - Login attempts exhausted.
> 03/23 16:52:12 - Failed to connect to
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=10.16.100.83)
> (PORT=1525))) (CONNECT_DATA=(SERVICE_NAME=FNTST)))
> Thanks a lot
Hi,
There are 3 types of Oracle client (for 10g and 11g): Full, Instant
Basic, and Instant Light. It seems that first two
support all character sets, Instant Light supports only:
* Single-byte character sets include US7ASCII, WE8DEC, WE8MSWIN1252,
and WE8ISO8859P1.
* Unicode character sets include UTF8, AL16UTF16, and AL32UTF8.
So, for WE8ISO8859P15 character set, Instant Basic client is needed.
Lab128 needs only two files from Instant Basic client, two DLL files:
oci.dll and oraociei10.dll
(10g); or oci.dll and oraociei11.dll (11g). These two files can be
extracted from the Instant "Client Package - Basic" zip files
downloaded from Oracle site:
http://www.google.com/url?sa=D&q=http://www.oracle.com/technology/sof...
Put those two DLL files into Lab128 directory and it should work. If
you use this option, I will appreciate if you could confirm that it
worked or not.
Regards,
Sergei