# SQLite relative path doesn't work in windows in ignition 8.1.12 **URL:** \ **Category:** Ignition Early Access\ **Created:** [January 7, 2022, 8:11am UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753 "2022-01-07T08:11:25Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Post date:** [January 7, 2022, 8:11am UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/1 "2022-01-07T08:11:25Z")
As the following image, the relative path jdbc:sqlite:${data} doesn’t work in ignition 8.1.12. If I use a direct path it works correctly: C:\Program Files\Inductive Automation\Ignition\data\projects ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/0/b0aaab32ed2ee1138e40460e437b551e7c879e5f.png) I wonder it is only valid for linux? ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 7, 2022, 3:41pm UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/2 "2022-01-07T15:41:45Z")
We definitely tested on other OSes. Your syntax looks correct, but I’ll look into this some more. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 7, 2022, 7:33pm UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/3 "2022-01-07T19:33:52Z")
The wildcard path worked for me. What was happening on your system - the DB connection was faulted? Any errors in the logs? ---
**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Post date:** [January 8, 2022, 3:58am UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/4 "2022-01-08T03:58:05Z")
In my system the DB Connection is faulted and not valid until I change it to static path. ---
**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Post date:** [January 11, 2022, 8:20pm UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/5 "2022-01-11T20:20:00Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/9/f96916e7b3b05c27caa4e0d9fb240addcb0ae453.png) This is the error log for my configuration. I just want simply access this folder: C:\Program Files\Inductive Automation\Ignition 8.1.12\data\projects ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 11, 2022, 8:35pm UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/6 "2022-01-11T20:35:33Z")
Hm, you’re sure of the version? Can you start a support ticket? I would expect that path to look different if the substitution was working properly. ---
**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Post date:** [January 11, 2022, 8:38pm UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/7 "2022-01-11T20:38:44Z")
Yes, it is 8.1.12 and from 8.1.10 it should have worked correctly. The only thing I did is when installing ignition I change the default folder name to “C:\Program Files\Inductive Automation\Ignition 8.1.12” because I have several instances of ignition on the same machine. Did you check it with 8.1.12? When I put direct path it works OK but both ${local} ${data} get error as you see. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 11, 2022, 9:01pm UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/8 "2022-01-11T21:01:54Z")
The logic is fairly simple, and would always be used on 8.1.10 and up. I tested on ~8.1.15 in the IDE, but that shouldn’t matter (outside of file permissions, theoretically, but since you’re able to hardcode a path I don’t think it’s relevant here). From the screenshots, it looks like you meet all these conditions: ```auto if (field.equals(DatasourceRecord.ConnectURL) && record.getDriver().getVendor().equals(DatabaseVendor.SQLITE) && val != null && !val.contains(":memory:")) { ``` Unfortunately, I don’t think there’s any logging to use to confirm what’s happening. I’d start with support at this point. ---
**Author:** ![Kurt.Larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kurt.larson/32/6426_2.png) [@Kurt.Larson](https://forum.inductiveautomation.com/u/Kurt.Larson)\ **Post date:** [January 11, 2022, 10:26pm UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/9 "2022-01-11T22:26:47Z")
Can you verify that the version is indeed 8.1.12 on the Status → Overview page? I’m just concerned that the Gateway wasn’t installed / upgraded properly and isn’t on 8.1.10+. Also, what are the `local.dir` and the `data.dir` parameter values within `C:\Program Files\Inductive Automation\Ignition 8.1.12\webserver\webapps\main\WEB-INF\web.xml`? ---
**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Post date:** [January 12, 2022, 5:42am UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/10 "2022-01-12T05:42:22Z")
> [@Kurt.Larson](#): > > what Yes it is Version: **8.1.12 (b2021111810)** I just install it from scratch. [web.xml](https://forum.inductiveautomation.com/uploads/short-url/lud1NeXYRY95Qylr9Tv1NVtHqrD.xml) (4.9 KB) ---
**Author:** ![Kurt.Larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kurt.larson/32/6426_2.png) [@Kurt.Larson](https://forum.inductiveautomation.com/u/Kurt.Larson)\ **Post date:** [January 12, 2022, 6:00pm UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/11 "2022-01-12T18:00:10Z")
Did you restore from a gateway backup? If so, what version is that backup from? Can you verify that the SQLite driver type is set to `SQLITE` within `Config -> Drivers`? ---
**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Post date:** [January 12, 2022, 8:04pm UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/12 "2022-01-12T20:04:21Z")
Yes it originally come form 8.1.4 and restore in 8.1.12 and then I try to check for this feature. The driver type is set to Generic. I change it and now it is working thanks. So it is because I import it from older version? ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [January 12, 2022, 8:27pm UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/13 "2022-01-12T20:27:26Z")
I don’t think it’s a problem with the restore or old version, it’s because you had it set to `GENERIC` instead of `SQLITE`. edit: but your screenshot above shows SQLite… maybe that’s not it… ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 12, 2022, 9:04pm UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/14 "2022-01-12T21:04:52Z")
I think a sufficiently old version didn’t have a dedicated translator for SQLite, so you could have a SQLite driver but a ‘generic’ type. That’s the only real problem here. Fresh installs won’t have the issue. ---
**Author:** ![weixionglichina](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/weixionglichina/32/10650_2.png) [@weixionglichina](https://forum.inductiveautomation.com/u/weixionglichina)\ **Post date:** [February 8, 2022, 8:52am UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/15 "2022-02-08T08:52:37Z")
@nader.chinichian Try: jdbc:sqlite:data\projects\user.db ---
**Author:** ![Jose\_Garibay](https://avatars.discourse-cdn.com/v4/letter/j/d6d6ee/32.png) [@Jose\_Garibay](https://forum.inductiveautomation.com/u/Jose_Garibay)\ **Post date:** [July 14, 2022, 12:37am UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/16 "2022-07-14T00:37:41Z")
I had the same issue, this worked: jdbc:sqlite:data\projects\user.d … also I did restore backup for the ignition test btw, i think that might have caused it. ---
**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Post date:** [July 14, 2022, 4:04pm UTC](https://forum.inductiveautomation.com/t/sqlite-relative-path-doesnt-work-in-windows-in-ignition-8-1-12/54753/17 "2022-07-14T16:04:06Z")
My problem is solved by changing translator to SQLITE.