SQLite-DB in Programs Folder

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Nils
Posts: 9
Joined: Mon 29 Oct 2012 12:31

SQLite-DB in Programs Folder

Post by Nils » Mon 29 Oct 2012 12:42

Hello,

I've got a problem with using a sqlite database file which is situated inside the \programs folder. When i try to access this file as a non-admin the connection needs about 1.5 seconds to be established and then the read-access works without a problem. Connecting to that file with administrator-rights it connects immediately. Is there anything i can do about that connection delay as non-administrator?

thanks in advance,
nils

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: SQLite-DB in Programs Folder

Post by AlexP » Tue 30 Oct 2012 15:36

hello,

Such behaviour is due to that SQLite creates temporary files (journals, inner tables, etc.). And since the Program Files folder is not writable for a user with limited rights, sqlite, first, tries to create these files there, and after this couldn't be done, it tries to find writable folders and to create the files there

Post Reply