SQL logic error or missing database

[IbeDBob]

Hi All, I have to use Zeos 6.6. as I am still on Delphi 5 and am getting this error when opening a database.

In the IDE it works fine.
Running the program directly form the development folder it works fine.
But - if I make a copy of the program, the sqlite.dll and the database in another folder, I get the above error.

Anyone suggest what is going wrong here?

I can't step through the opening process as it all works fine in the IDE.

[marsupilami]

Hello Dyslexic Bob,

could you please check, if the path to your database if hard coded in the source or if the path actually gets set correctly during runtime? Usually you should set it by some statement like

Code: Select all

ZConnection.Database := ExtractFilePath(ParamStr(0)) + 'sqlite.db';

Best regards,

Jan

[Timothykr]

You have hit the mark. It seems to me it is very excellent thought. Completely with you I will agree.