application with Firebird Embbeded works on win10, not working on
win11
lazarus / 16-Databases

----------------------------------------------------------------------
mirecko · 2023-07-02 17:06

Hi everyone,
i have an issue i can't solve myself, so any help is appreciated very
much.

I have an application which works with Firebird embbeded v2.5.9 OK on
windows 10, it was created and compiled on Win10 machine.
The same app is not working / can't acces table in database, picture
is attached when running on Windows 11

i tried to instal laz 2.2.6 32bits in VMware virtual machine with
win11, used FB emb. dll's in aplication dir, compiled the project,
and i am still getting the same message.

TIBconnection is defined like this:

 With  DBConnection do
    begin
      HostName:='';
      DatabaseName:='price_test.fdb';
      UserName:='';    i found the issue  just here - really needs
username to run on different PC
      Password:='';
      Charset := 'UTF8';
      Dialect := 3;
      Transaction := SQLTransaction1;
    end;                                   

on first point of use :

 SQLQuery1.Close;
  SQLQuery1.SQL.Text := 'select * from prices_t where
datum='+quotedstr(qt_date);
  SQLQuery1.Open;    

i get the error message attached.

thank you all for answers and advice
Miro