RODBC Debian / Ubuntu

First install

- r-cran-rodbc
- unixodbc
- odbc-postgresql for postgres; libmyodbc for mysql ...

using apt-get.

With  dpkg -L odbc-postgres you get the install paths.

The configuration files are odbc.ini and odbcinst.ini - on my computer there were template files in

/usr/share/psqlodbc/odbcinst.ini.template

and

/use/share/doc/odbc-postgresql/examples/odbc.ini.template

different examples here

run

sudo odbcinst -i -d -f template_file_odbcinst.ini

to invoke the driver

sudo odbcinst -i -s -f template_file_odbc.ini

to copy the ini file to the current user

if there are problemsread this

PS: If you install the packages within R and you are behind a proxy do not forget to set the proxy BEFORE you try to install. It have to be set before any download code is used, otherwise you have to restart R. ( Sys.setenv("http_proxy"="http://my_proxy:my_port") )