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

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 Marc Schwartz
On Jan 20, 2010, at 1:36 PM, Eric Ma wrote: > > 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 If you are getting the same error as in the or

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: http://n4.nabble.com/Run-time-error-when-executing-sqlQuery-using-the-64-b

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 Marc Schwartz
On Jan 19, 2010, at 10:04 PM, Eric Ma wrote: > > 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

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 Orac

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.

2009-12-20 Thread Marc Schwartz
On Dec 19, 2009, at 11:39 AM, Alex Chelminsky wrote: I have compiled and linked a 64 bit version of R (R 2.9.2) and the corresponding unix ODBC 64 bit package The red highlighted text below is the error I'm getting trying to when invoking a sqlQuery library(RODBC) channel <- odbcConnect("Ora

[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.

2009-12-19 Thread Alex Chelminsky
I have compiled and linked a 64 bit version of R (R 2.9.2) and the corresponding unix ODBC 64 bit package The red highlighted text below is the error I'm getting trying to when invoking a sqlQuery > library(RODBC) > channel <- odbcConnect("OraLSH", , ) > sqlQuery(channel,"select sysdate from dua