SQLite_Demo ERROR: unable to open database file.

[drinkpanda 0]

Hi All,

 

When I try to open the SQLite_Demo under Data Explorer I get the below error and don't know how to resolve it;

 

[FireDAC][Phys][SQLite] ERROR: unable to open database file.

 

I've just started learning Delphi and I'm following the youtube playlist Welcome to Delphi by Embarcadero Technologies. I'm on video 4: Accessing Data with FireDAC on Windows VCL.

 

Thanks

 

[Stano 143]

One reason is that the DB is open in another program. You have a DB set as embedded and it is already open, e.g. in the DB manager.
If I missed it, other discussants will describe other scenarios.

[drinkpanda 0]

Thanks for the response Stano. I actually solved it. The problem was the database wasn't in the directory it was pointing to. I searched my PC for "fddemo.sdb", found the correct location and updated it in "SQLite_ Demo" properties.