how can I connect to a LibreOffice base odb file using the package odbc for R? I tried with:
> library(odbc) > library(DBI) > con <- dbConnect(odbc::odbc(), + driver = "PostgreSQL Driver", + database = "proof.odb", + uid = "", + pwd = "", + host = "localhost", + port = 5432) Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib 'PostgreSQL Driver' : file not found > con <- dbConnect(odbc::odbc(), + driver = "/usr/local/lib/psqlodbcw.so", + database = "proof.odb", + uid = "", + pwd = "", + host = "localhost", + port = 5432) Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/psqlodbcw.so' : file not found > con <- dbConnect(odbc::odbc(), + driver = "/usr/local/lib/libsqlite3odbc.dylib", + database = "proof.odb", + uid = "", + pwd = "", + host = "localhost", + port = 5432) Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libsqlite3odbc.dylib' : file not found ``` What would be the correct driver/syntax? -- Best regards, Luigi ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.