Zeoslib doesn't release the Database file after disconnect.

[zeoslibuser]

I don't understand what is going on. I thought that when you connected to the database dummy.db file through TZConnection tool, you always stayed connected until you disconnected from it. However, no matter what I do once I connect to a database file, it remains connected even though I call disconnect procedure of TZConnection. Thus, it never releases the database file dummy.db until I shutdown the program. Am I missing something?

ZConnection1.Database := 'dummy.db';
ZConnection1.Protocol := 'SQLite-3';
ZConnection1.Connect;

Query1.SQL.TEXT := 'SELECT * FROM test'; (Query1 connection is ZConnection1)
Query1.ExeSQL;

ZConnection1.Disconnect;

But disconnect never releases the dummy.db file. I need to be able to do that for my program... Any hints or clues will be greatly appreciated. Thanks.

[EgonHugeist]

Hi,

yes this WAS true. Which version of Zeos are you using for?

Note this issue should be fixed in 7.1.4 or better 7.2-Beta

[zeoslibuser]

Hello, Thank you for your reply.

I am using 7.1.2 STABLE release.

Is there a latest version that works?

[EgonHugeist]

Of yourse! As i wrote: 7.1.4-stable and (prefered) 7.2-Beta