The unixODBC site (www.unixODBC.org/odbcinst.html) has a useful tutorial, too.
On Mon, 21 Feb 2005, Sebastian Luque wrote:
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
-- Brian D. Ripley, [EMAIL PROTECTED] Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595
______________________________________________ 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
