sqlloc information
/sybase/scripts$ more sqlloc.res
sqlsrv.server_name: MY_SERVER_NAME
sqlsrv.sa_login: sa
sqlsrv.sa_password:
sqlsrv.default_language: USE_DEFAULT
sqlsrv.language_install_list: USE_DEFAULT
sqlsrv.language_remove_list: USE_DEFAULT
sqlsrv.default_characterset: cp850
sqlsrv.characterset_install_list: USE_DEFAULT
sqlsrv.characterset_remove_list: USE_DEFAULT
sqlsrv.sort_order: nocase
Usage:
sqlloc -U sa -r sqlloc.res
Other useful queries:
select id, csid, name from syscharsets where type >= 2000
select id, csid, name from syscharsets where type < 2000
sp_helpsort
sp_helplanguage
Error in alert logs
ksctsetlocale: connectivity library error. Operation: cs_locale(CS_SET CS_SYB_SORTORDER nocase_cp850).
From the message in Google groups:
Case ID: 10453916 Product: Adaptive Server Enterprise
Open Date: 10/14/1998 05:32:23 OS: Solaris 2.6
Version/EBF: 1150 Generic Platform: Sun Solaris Generic
Problem Description:
Attempt connect to another ASE/SQL Server via Omni results in error message:
kernel ksctsetlocale - connectivity library error. Operation:
cs_locale(CS_SET CS_SYB_SORTORDER noaccents_iso_1)
Tip or Workaround:
Bug 144097 Description :
------------------------
Login to Adaptive Server Enterprise 11.5 (mine solaris, customer’s aix)
which has a non-binary sortorder configured as default and issue a "connect to" for
OMNI. The following message is generated into the server log:
ksctsetlocale: connectivity library error. Operation: cs_locale(CS_SET CS_SYB_SORTORDER caseless_34).
OR
ksctsetlocale: connectivity library error. Operation: cs_locale(CS_SET CS_SYB_SORTORDER nocase_cp850).
OR
ksctsetlocale: connectivity library error. Operation: cs_locale(CS_SET CS_SYB_SORTORDER nocase_iso_1).
Workaround :
------------
sp_configure "allow updates", 1
go
begin tran
update syscharsets
set sortfile = "noaccents.srt"
where name = "noaccents_iso_1" /*sort order for which error message is
raised */
go
-- Make sure that only 1 row was affected, then ...
commit
go
sp_configure "allow updates", 0
go
Resolution:
"syscharsets.sortfile" was NULL. Needed to be updated to contain the name of
the sort file for the character set: noaccents.srt. Likewise, for other
non-binary character sets, .srt would be required. This issue is being
addressed by Bug 144097 -> non-binary sort order configured as default.
| 