4 Replies Latest reply: Jan 23, 2012 8:40 PM by davideps RSS

    Failing to connect and select from sqlite3

      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