|
Posted by Gosling on November 10, 2007, 11:13 am
Please log in for more thread options Origin of the troubles: language NL; this results in LAtin General CI AS.
Solution:
install sql2005(express) uncheck hide advanced sql option during install,
then check sql collation, the suggested default 1285 (this turns out to be
SQL_Latin1_Genral_Cp1_CI_AS)
restore the storebackupfile. then sql-collations between server and bd match
AND most important the TILL starts too....
"Gosling" wrote:
> It has been changed from:
> SQL_Latin1_General_Cp1_CI_AS to
> Latin General Cl AS
>
> I have done this in the past with rms 1.3 / SQL2K SP4 and had no problems
> No I have rms 2.0 with SQL2005EXPRESS and POS does not start; all other
> features work fine
> PS Change of collation was done using RMS_Administrator/Change Collation
>
> "Akber Alwani" wrote:
>
> > hi Gosling, I have doubt that they are using in the bussiness logic some
> > collation statements. but I wanted to investigate it more so please tell me
> > what collation you have change from ? to to??
> >
> > "Gosling" wrote:
> >
> > > found out that db collation and server collation differ giving trouble
when
> > > importing csv at stocktake (collation error on join). so I changed
collation
> > > to the default sql2k one Latin1 etc.. (so server and db match) (from
> > > sql_....) this works fine but when starting the POS it reports immediately
> > > 'row could not be found or could be altered", and the pos program exits
> > > straight away.
> > >
> > > any clues how to solve?
> > >
> > > Thanks Gosling
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap