topic Failing to connect and select from sqlite3 in QlikView

Failing to connect and select from sqlite3

Fri, 20 Jan 2012 05:18:39 GMT

Hi! I'm running windows Vista SP2 32bit and using the sqlite driver located here: http://www.ch-werner.de/sqliteodbc/ When I push "connect" in the script editor, choose sqlite3 database, and browse to my database--it seems to work fine. But I only get the text "ODBC CONNECT TO [SQLite3 Datasource];" in the script, not the full path to the file. If I then push "select", I can see the database tables and columns. But, even a simple SQL Select * FROM Documents fails with "no such table Documents". What does a correct sqlite CONNECT and SELECT combination look like? thank you, -david

Failing to connect and select from sqlite3

rbecher — Fri, 20 Jan 2012 09:19:57 GMT

Hi David,

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:

http://www.zentus.com/sqlitejdbc/

Which could be used with our QlikView JDBC Connector:

http://community.qlik.com/docs/DOC-2438

- Ralf

Re: Failing to connect and select from sqlite3

Sun, 22 Jan 2012 02:11:31 GMT

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”?

-david

Failing to connect and select from sqlite3

rbecher — Mon, 23 Jan 2012 20:18:14 GMT

Maybe like this:

ODBC CONNECT TO [SQLite3 Datasource;Database=D:\Users\davideps\Desktop\test.sqlite;];

- Ralf

Re: Failing to connect and select from sqlite3

Tue, 24 Jan 2012 01:40:08 GMT

That did it! Thank you!

-david