Google
Web tarasdom.com

 

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.

©
Page was modified 13.08.2006