back to first page..

Running EDA2 again

re -installing everything with R

The program should help you load the necessary packages. If not you can copy everything from your previous R version library to the new and use update.packages(checkBuilt=TRUE, ask=FALSE)

source("EDACCM/init.r")
#########################"
# chargement des données###loading data
############################
ccm=new("BaseEdaCCMriversegments",
		baseODBC="baseODBCccm",
		schema="ccm21",
		table="riversegments",
		prkey="gid",
		zonegeo="Ireland")
ccm<-loaddb(ccm)# C14 8644 lines

Here I have a crash, ODBC connexion fails. I have to edit the xlm file in EDA/EDAload.xml.

• In this file, my ODBC link is called eda2local. I need to check if it's in system/administration tools/odbc there you might see the 64 bit link if you are running in R 64 bit. If you are running R 32 bits on a 64 bits system you need to place a shortcut that will point to C:\Windows\SysWOW64\odbcad32.exe.

• I'm recreating the link so I'm using a postgres unicode driver for 64 bit. Data source eda2local dbname eda server my IP of the server of localhost, usernames and password. I've changed my password also so I need to change it in my xml file If you have to redo all, you need to rerun init.r

H:\base>pg_dump -U postgres -f "ccm21.riversegments2014_beforeelevira.sql" --tab
le ccm21.riversegments -h 192.168.1.104 eda2