What is wrong with my DB path? GW DB valid, Query error

Ignition
1

I am connecting to a SQLite DB in folder c:\documents\SQLite\xyz.db
Gateway says connection is valid, but query tag give error:
Error_ExpressionEval(“[SQLITE_ERROR] SQL error or missing database (no such table: states)”)

When copy the DB to the same folder as the sample DB and create a connection there it works.
What do I need to change to get a different path to work for the query tag to work?

Thanks,
Sting

2

Sounds like you need permissions for the gateway service to access the folder. (The gateway runs as a service–it doesn’t have the privileges of a user on its desktop.)

3

Thanks for the reply. It ended up that I did not have the full windows file path. Windows was showing me the “shortcut” path. Once entered the full path it found it.