Changes between Initial Version and Version 1 of Run R program 2014


Ignore:
Timestamp:
Mar 3, 2014 3:21:59 PM (11 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Run R program 2014

    v1 v1  
     1back to first page[..][[BR]] 
     2 
     3 
     4= Running EDA2 again = 
     5 
     6== re -installing  everything with R == 
     7The program should help you load the necessary packages. If not you can copy everything from your previous R version library to the new 
     8and  use update.packages(checkBuilt=TRUE, ask=FALSE) 
     9 
     10{{{#!R 
     11source("EDACCM/init.r") 
     12#########################" 
     13# chargement des données###loading data 
     14############################ 
     15ccm=new("BaseEdaCCMriversegments", 
     16                baseODBC="baseODBCccm", 
     17                schema="ccm21", 
     18                table="riversegments", 
     19                prkey="gid", 
     20                zonegeo="Ireland") 
     21ccm<-loaddb(ccm)# C14 8644 lines 
     22}}} 
     23 
     24#C14 Here I have a crash, ODBC connexion fails. I have to edit the xlm file  
     25# in EDA/EDAload.xml In this file, my ODBC link is called eda2localn 
     26# I need to check if it's in system/administration tools/odbc 
     27# there you might see the 64 bit link if you are running in R 64 bit. 
     28# If you are running R 32 bits on a 64 bits system you need to place a shortcut 
     29# that will point to C:\Windows\SysWOW64\odbcad32.exe. 
     30# I'm recreating the link so I'm using a postgres unicode driver for 64 bit 
     31# Data source eda2local dbname eda server my IP of the server of localhost, usernames and password 
     32# database. I've changed my password also so I need to change it in my xml file  
     33# If you have to redo all, you need to rerun init.r 
     34 
     35 
     36{{{ 
     37H:\base>pg_dump -U postgres -f "ccm21.riversegments2014_beforeelevira.sql" --tab 
     38le ccm21.riversegments -h 192.168.1.104 eda2 
     39}}}