Package: libsqliteodbc
Version: 0.91-3
Severity: normal
Dear Maintainer,
Querying a SQLite database is not possible through ODBC with libsqliteodbc
neither with isql nor R or LibreOffice Base.
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
echo 'select * from test' | isql testdb
echo 'library(RODBC)
sqlQuery(odbcConnect("testdb"), "select * from test")' |
R --vanilla
# The following indicates, that 'testdb.sqlite' can be accessed directly:
echo 'select * from test;' | sqlite3 testdb.sqlite
echo 'library(RSQLite)
dbGetQuery(dbConnect("SQLite", dbname="testdb.sqlite"),
"select * from test")' |
R --vanilla
# returns a data.frame as expected
Thanks for any help on this issue!
Regards,
Tom
-- System Information:
Debian Release: wheezy/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 3.2.0-3-amd64 (SMP w/4 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages libsqliteodbc depends on:
ii libc6 2.13-35
ii libsqlite0 2.8.17-7
ii libsqlite3-0 3.7.13-1
libsqliteodbc recommends no packages.
Versions of packages libsqliteodbc suggests:
ii unixodbc-bin 2.3.0-3
-- no debconf information
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
