Re: [R] Run time error when executing sqlQuery using the 64-bit version of R with 64-bit RODBC package in a Solaris 10 Sparc machine.

2010-01-20 Thread Eric Ma
Thanks Marc for the quick reply. I confirmed the R binary I built is indeed 64-bit. sqlplus works fine, so is the odbcConnect() call. Any idea the error is thrown by RODBC or R? Eric -- View this message in context:

Re: [R] Run time error when executing sqlQuery using the 64-bit version of R with 64-bit RODBC package in a Solaris 10 Sparc machine.

2010-01-20 Thread Eric Ma
Wow, this is as much hand-holding as one can expect, and for a R newbie it is unbelievable and invaluable! Thanks again for all this help Marc! Here is the screen print of my entire R session: .Machine$sizeof.pointer [1] 8 library(RODBC) conn - odbcConnect(dsn='qdblocal', uid = ciqxf, pwd

Re: [R] Run time error when executing sqlQuery using the 64-bit version of R with 64-bit RODBC package in a Solaris 10 Sparc machine.

2010-01-19 Thread Eric Ma
I am having the exact same error, and the suggested work-around does not help. My env is: 64-bit SUSE Linux v 10.1 on Xeon processors. gcc and gfortran version is 4.1.2 64-bit R 2.10.1 compiled from soure using CC=gcc -m64 etc. 64-bit unixODBC driver manager 2.2.14 compiled from source