tags 686166 +moreinfo unreproducible done On Wed, Aug 29, 2012 at 02:29:01PM +0200, tom wrote:
> Querying a SQLite database is not possible through ODBC with libsqliteodbc > neither with isql nor R or LibreOffice Base. Works for me with isql and LibreOffice Base (my main test setup). > These are the steps to reproduce: > apt-get install r-cran-rodbc libsqliteodbc sqlite3 unixodbc-bin \ > r-cran-rsqlite > sqlite3 testdb.sqlite 'create table test > (id integer primary key, test text); > insert into test values (1, "test");' > ODBCManageDataSourcesQ4 > # add DSN with name 'testdb' referring to > # testdb.sqlite with SQLite3 driver I don't know/have that tool. I added manually to ~/.odbc.ini: [testdb] Description = http://bugs.debian.org/686166 Driver = SQLite3 Database = /path/to/testdb.sqlite SyncPragma = NORMAL JournalMode = DELETE It works for me also when removing the SyncPragma and JournalMode lines. Please check your ~/.odbc.ini to see if the one generated by ODBCManageDataSourcesQ4 is correct. > echo 'select * from test' | isql testdb Works for me. What happens when you try. Do you get an error message? Which one? -- Lionel -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org