Re: [R] Error using 32-bit R and RODBC package on 64-bit Windows Server OS with R version 2.10

2009-11-23 Thread helpme
Thank you for the link to the 32 bit Windows Oracle downloads for the Instant Client. That solved the problem. I'm now able to connect to Oracle database from R using the RODBC library. Thank you Mark! -Melanie On Wed, Nov 18, 2009 at 6:23 PM, Marc Schwartz marc_schwa...@me.com wrote: Just

Re: [R] Error using 32-bit R and RODBC package on 64-bit Windows Server OS with R version 2.10

2009-11-18 Thread helpme
Now that I know RODBC only works with 32-bit ODBC drivers this explains the problem I was having. The system has a 64 bit ODBC driver is definitely installed. I can tell because when you go to system32 folder and click on odbcad32.exe it goes to the Microsoft ODBC manager where I can select the

Re: [R] Error using 32-bit R and RODBC package on 64-bit Windows Server OS with R version 2.10

2009-11-18 Thread Marc Schwartz
Just to clarify on your first point, it is not that RODBC cannot work with 64 bit ODBC drivers. Given your particular configuration of 64 bit Windows, 32 bit R and 64 bit ODBC drivers, you are likely running into compatibility issues. From the error message below, it would seem that you

[R] Error using 32-bit R and RODBC package on 64-bit Windows Server OS with R version 2.10

2009-11-16 Thread helpme
I am receiving an error when trying to connect to the Oracle Database using RODBC on a 64-bit Windows Server OS. The version of R is 2.10.0-win32.exe Is this the wrong version. Does RODBC only work with 32-bit ODBC drivers? 've read over all the posts and documentation manuals. The system is

Re: [R] Error using 32-bit R and RODBC package on 64-bit Windows Server OS with R version 2.10

2009-11-16 Thread Marc Schwartz
On Nov 16, 2009, at 2:39 PM, helpme wrote: I am receiving an error when trying to connect to the Oracle Database using RODBC on a 64-bit Windows Server OS. The version of R is 2.10.0- win32.exe Is this the wrong version. Does RODBC only work with 32-bit ODBC drivers? 've read over all