Weird TSQLite3Connection problem

[JanRoza]

YES!!
Your hint about sqlite3.dll version did it.
In my Lazarus folder I had version 3.8.9 and in my stand-alone test folder was a newer version (maybe 64-bit whereas the project is 32-bit).
After replacing the dll the exe file works.
Man, something so simple and yet so hard to find! 
Thanks for your time, you really put me on my way again.

[zoltanleo]

I will try to leave this message for those who also encounter a similar error.

My project used writing and reading datasets. I set the following options for these datasets:

Code: Pascal  [Select][+][-]

1. qryMasterSelect.Options:= Options + [sqoAutoCommit, sqoKeepOpenOnCommit];

I was getting the same error when I tried to programmatically close the DB connection after connect/disconnect more than 1 time. It didn't depend on the bitness of the library used sqlite3.

As a result, I found a workaround. I began to programmatically create/destroy SQLite3Connection during connection/disconnection, respectively.

Perhaps my experience will be useful to someone.