library(odbc) was built with unixODBC. unixODBC is an installable package on many Linux distributions, and can also be downloaded from http://www.unixodbc.org. You will also need to install the DBMS specific ODBC drivers.
library(odbc)