|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Connection lost to database
Hi
Following code Zquery.Sql.Clear; ZQuery.SQL.Add('INSERT INTO TableDiv ('); ZQuery.SQL.Add('Div,Localite,Commune,DivCode,CadaLang) '); ZQuery.SQL.Add('Values ('); ZQuery.SQL.Add(IntToStr(Division)+','+QuotedStr(Localite) +','); ZQuery.SQL.Add(QuotedStr(Commune) +','+ IntToStr(DivCode)+','+ IntToStr(CadaLang)+')'); Zquery.ExecSQL; runs without any problem on my Pc and some others but on others the last statement generates "Connection lost do database" error. Database is local in Firebird 1.5. Then, I suppose that cannot be a network problem. The error may be produced on PC with the same version of Windows than others where there is no error. My idea is that's a question of Windows configuration (default charset ?). Have anyone a solution. Thank you for advance |
|
#2
|
||||
|
||||
|
Check client library version and explictly set charset in connection.
Hope this helps
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Connection lost to database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|