[R] how to connect libreoffice base odb using R package odbc?

[Luigi Marongiu]

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