[R] RODBC and portability issue

From: Depiereux Constant <constant.depiereux_at_aqte.be>
Date: Fri 18 Mar 2005 - 07:56:44 EST

Hello,

New user of R I did experience some trouble using R and ODBC on Windows XP, MS Access and PostgreSQL.

While querying a database is relatively simple, the use of sqlSave is a bit more tricky.

After a large series of trial, I finally succeeded to get it work provided :

  1. I leave the application create the table by itself. Once created, reusing it is simple and reliable, although you should not try to adapt the layout of the table to fix you exact needs. In this case, nothing works anymore in about 80% of the cases.
  2. I manage to create the database using a record whici contains the largest possible data item for a given variable, otherwise there is a risk to be limited to a fields that appears to be to narrow to receive largest occurrence of the data/field.

Then the real problem really start : to perform the analysis on time, I have to run it in parallel on several machines, ideally without creating several time the similar table under a different name.

So the question is simple : which 'invisible' information is created either by R, ODBC or the database that should be replicated to avoid this silly scenario of multiple occurrence of the table.

Help me please.

PS :I think that I read carefully the documentation before asking this question, so please avoid refering back to it, unless with a precise item to be re-read.

`

Constant Depièreux
Managing Director
Applied Quality Technologies Europe sprl Rue des Déportés 123, B4800 Verviers
Tel : + 32 87 29 21 75
Fax : +32 87 29 21 71
Mobile : +32 475 555 818
e-Mail : constant.depiereux@aqte.be
Web presence : http://www.aqte.be
Skype : cdepiereux



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 Received on Fri Mar 18 08:01:21 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:30:51 EST