Monday, March 12, 2012

how to set sort order for MSDE 2000 A

I'm trying to make MSDE 2000A sort order case-insensitive accent-insensitive.
I have this in my setup.ini file:
[Options]
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
DATADIR="D:\"
AutoStart=255
[DlgCpSortUnicode-0]
SortId=54
LCID=1033
CompStyle=196611
It installs but sp_helpsort still says:
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page
1252 for non-Unicode Data
Is this supported? What do I have to do?
TIA
hi Evan,
evan[at]irtech[dot]com wrote:
> I'm trying to make MSDE 2000A sort order case-insensitive
> accent-insensitive.
> I have this in my setup.ini file:
> [Options]
> DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> DATADIR="D:\"
> AutoStart=255
> [DlgCpSortUnicode-0]
> SortId=54
> LCID=1033
> CompStyle=196611
> It installs but sp_helpsort still says:
> Latin1-General, case-insensitive, accent-sensitive,
> kanatype-insensitive, width-insensitive for Unicode Data, SQL Server
> Sort Order 52 on Code Page 1252 for non-Unicode Data
> Is this supported? What do I have to do?
> TIA
try using the SQL Server collation instead of Windows codes, like
setup.exe .... COLLATION="Latin1_General_CI_AI_KS_WS"
= Latin1-General, case-insensitive, accent-insensitive, kanatype-sensitive,
width-sensitive
you can inspect all available LatinXX collations executing
select * from ::fn_helpcollations()
where name like 'Latin%'
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks! I didn't know you could do that. I will give that a try later on
today.
Evan
"Andrea Montanari" wrote:

> hi Evan,
> evan[at]irtech[dot]com wrote:
> try using the SQL Server collation instead of Windows codes, like
> setup.exe .... COLLATION="Latin1_General_CI_AI_KS_WS"
> = Latin1-General, case-insensitive, accent-insensitive, kanatype-sensitive,
> width-sensitive
> you can inspect all available LatinXX collations executing
> select * from ::fn_helpcollations()
> where name like 'Latin%'
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||thanks Andrea. You rock! This worked.
Is there a list of collations somewhere?
When I try:
setup.exe .... COLLATION="Latin1_General_CI_AI_KI_WI"
which would match my SQL Server 2000 setup, the MSDE setup blows up during
cnfgsvr.
This is not a problem for me, but might be useful for future reference.
Thanks again!
"Andrea Montanari" wrote:

> hi Evan,
> evan[at]irtech[dot]com wrote:
> try using the SQL Server collation instead of Windows codes, like
> setup.exe .... COLLATION="Latin1_General_CI_AI_KS_WS"
> = Latin1-General, case-insensitive, accent-insensitive, kanatype-sensitive,
> width-sensitive
> you can inspect all available LatinXX collations executing
> select * from ::fn_helpcollations()
> where name like 'Latin%'
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Evan,
evan[at]irtech[dot]com wrote:
> thanks Andrea. You rock! This worked.
> Is there a list of collations somewhere?
> When I try:
> setup.exe .... COLLATION="Latin1_General_CI_AI_KI_WI"
> which would match my SQL Server 2000 setup, the MSDE setup blows up
> during cnfgsvr.
> This is not a problem for me, but might be useful for future
> reference.
http://msdn.microsoft.com/library/de...ation_6gfn.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I read the msdn article but im a little bit confused about the counting.
For instance if i login and transmit a batch of sql statements and log off
i use 3 operations ? or only 1 ? At the moment i use some like this : m_pRs-
>Open((LPCTSTR) strSQL, (LPCTSTR)strConnection, adOpenStatic,
adLockPessimistic , adCmdUnknown);
where m_pRs is a RecordSet.
Message posted via http://www.sqlmonster.com
|||Ups sorry wrong section ,(
Message posted via http://www.sqlmonster.com
|||What do AUTOSTART=255 ? I didnt find it in "Customizing Desktop Engine
Setup.exe"
Message posted via http://www.sqlmonster.com
|||hi Alexander,
Alexander Baumgart via SQLMonster.com wrote:
> What do AUTOSTART=255 ? I didnt find it in "Customizing Desktop Engine
> Setup.exe"
where did you find that parameter?
AFAIK, AutoStart is part of the [DlgServices-0] for unattend installation fo
SQL Server 2000, feature not available for MSDE...
and it refers to autostart services..
http://msdn.microsoft.com/library/de...setup_6nz9.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||1st posting:
AutoStart=255
[DlgCpSortUnicode-0]
thx for the link.
Message posted via http://www.sqlmonster.com

No comments:

Post a Comment