Page 1 of 1

Zeoslib doesn't release the Database file after disconnect.

Posted: 10.11.2014, 21:04
by 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? :nurse: :doc:

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.

Re: Zeoslib doesn't release the Database file after disconne

Posted: 11.11.2014, 12:39
by 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

Re: Zeoslib doesn't release the Database file after disconne

Posted: 11.11.2014, 14:37
by zeoslibuser
Hello, Thank you for your reply.

I am using 7.1.2 STABLE release.

Is there a latest version that works?

Re: Zeoslib doesn't release the Database file after disconne

Posted: 18.11.2014, 22:20
by EgonHugeist
Of yourse! As i wrote: 7.1.4-stable and (prefered) 7.2-Beta