Hello,

>> >The connection to the embedded server is OK, when I run a simple query
>> >like SELECT * FROM SOME_TABLE it is OK too. But when I add an ORDER BY
>> >clause to my query it freezes immediately with no exception and I have
>> >to stop the thread manualy. The same problem is when I use a SUBSTRING()
>> >function and maybe somewhere else.
>> >
>> >Maybe it's caused by WIN1250 chracter set or by PXW_CSY collation
>> >because when I tried to use the example database EMPLOYEE.FDB from
>> >firebird distribution everything works fine.

you need to distribute the intl directory and the fbintl.dll together
with fbembed.dll if you want to use that charset and collation.
Read the docs.

Ciao
--
Nando Dessena
http://www.flamerobin.org