I would suggest to replace [SQLite3 Datasource] with the full path of the db. I presume this is a missing feature in the ODBC driver.
Btw. there is also a JDBC driver:
Which could be used with our QlikView JDBC Connector:
Thank you Ralph.
What would a correct ODBC Connect statement look like for a sqlite driver? For example, when I put this in the script:
ODBC CONNECT TO “D:\Users\davideps\Desktop\test.sqlite”
I get the error “SQL##f - SqlState: IM010, ErrorCode: 0, ErrorMsg: [ODBC Driver Manager] Data source name too long” when trying to reload the data. It does not work with brackets instead of quotes or with single quotes or with no quotes. Do I need to signal that it is an sqlite file? Something like ODBC CONNECT TO ”sqlite:path”?