Sqlite

#1

Can an Ignition Project connect to a SQLite database? If so, how?

0 Likes

#2

SQLite isn’t packaged with Ignition as an exposed driver, so you’ll have to use the “Create new JDBC Driver…” procedure with a downloaded driver package. I believe it’s this one.

0 Likes

#3

Thanks! I was able to get the status of the connection to “Valid”. However, when I can’t get the transaction group to write to the database. So I am wondering if the problem lies with the Translator, and needing something custom.

0 Likes

#4

Did you ever resolve this issue? I was able to create a connection to sqlite that was Valid, but I cannot query the db I get an Error:SQL error or missing database (no such table: BASIC_SCHEDULES
even though I know that table exists.

0 Likes

#5

It will be usefull if SQLITE connector was directly available for some user’s db in Ignition 7.9.X or 8.0

0 Likes

#6

I was also able to get a valid connection, and it creates the sqlite file, but I wasn’t able to write data to it. Was anyone able to get SQLite working?

0 Likes