Hi Dirk, That worked beautifully, thanks a lot! I was able to connect to a test database, save to it (sqlSave), and query it (odbcQuery). Some comments below for future reference.
Dirk Eddelbuettel <[EMAIL PROTECTED]> wrote: [...] > ----------------------------------------------------------------------------- > [EMAIL PROTECTED]:~> cat /etc/odbcinst.ini > [PostgreSQL] > Description = PostgreSQL ODBC driver for Linux and Windows > Driver = /usr/lib/postgresql/lib/psqlodbc.so > Setup = /usr/lib/odbc/libodbcpsqlS.so > Debug = 0 > CommLog = 1 > > [MySQL] > Description = MySQL driver > Driver = /usr/lib/odbc/libmyodbc.so > Setup = /usr/lib/odbc/libodbcmyS.so > CPTimeout = > CPReuse = > FileUsage = 1 > ----------------------------------------------------------------------------- Except for PostgreSQL, this was the default configuration that MySQL or unixODBC must have entered here during installation. > ii) /etc/odbc.ini This file was empty in my system, so adapting your recommendation: ,-----[ /etc/odbc.ini (lines: 1 - 7) ] | [test] | Driver = /usr/lib/odbc/libmyodbc.so | Database = test | Servername = localhost | ReadOnly = 0 | Port = 3306 `----- and followed the same template to include the rest of my databases further down. Can the latter go in ~/.odbc.ini as I said before? I hope so, as this would allow for much easier maintenance. Thanks again for the helpful reply. -- Sebastian Luque ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html