Re: [R] RMySQL with Windows 7

2014-02-06 Thread Christian Oswald
Hello, I also don't found a solution for this problem. RMySQL works very well under Linux but not under Windows. You can try RODBC. Christian Am 05.02.2014 14:37, schrieb Peretz, Eliran: Hi , I read your post and followed your instructions but still couldn't install RMySQL by getting the

Re: [R] RMySQL with Windows 7

2014-02-06 Thread Duncan Murdoch
On 06/02/2014 8:43 AM, Christian Oswald wrote: Hello, I also don't found a solution for this problem. RMySQL works very well under Linux but not under Windows. You can try RODBC. RMySQL works fine for me in Windows. The most common problem people have installing packages in Windows is that

Re: [R] RMySQL with Windows 7

2014-02-06 Thread Christian Oswald
Hello, how can I install it on a wrong place? install.packages(RMySQL,type=source) don't work correct? Christian Am 06.02.2014 09:28, schrieb Duncan Murdoch: On 06/02/2014 8:43 AM, Christian Oswald wrote: Hello, I also don't found a solution for this problem. RMySQL works very well

Re: [R] RMySQL with Windows 7

2014-02-06 Thread Duncan Murdoch
On 06/02/2014 1:39 PM, Christian Oswald wrote: Hello, how can I install it on a wrong place? install.packages(RMySQL,type=source) don't work correct? Many Windows users have R installed in c:\Program Files, and normal users are not allowed to write there. The .libPaths() function will

Re: [R] RMySQL with Windows 7

2014-02-06 Thread Gabor Grothendieck
On Thu, Feb 6, 2014 at 2:52 PM, Duncan Murdoch murdoch.dun...@gmail.com wrote: On 06/02/2014 1:39 PM, Christian Oswald wrote: Hello, how can I install it on a wrong place? install.packages(RMySQL,type=source) don't work correct? Many Windows users have R installed in c:\Program Files,

Re: [R] RMySQL with Windows 7

2014-02-06 Thread Christian Oswald
I understand, but in my case the R-Library is in my user-folder. But I have investigate the files needed by RMySQL and found that the gcc searchs for libmysql.lib in MYSQL_HOME\lib\opt but it is only in lib. Copying it in lib/opt solved the problem. Thanks, Christian Am 06.02.2014 14:52,

Re: [R] RMySQL with Windows 7

2014-02-06 Thread Gabor Grothendieck
On Thu, Feb 6, 2014 at 3:52 PM, Christian Oswald christian.osw...@diospi-suyana.org wrote: I understand, but in my case the R-Library is in my user-folder. But I have investigate the files needed by RMySQL and found that the gcc searchs for libmysql.lib in MYSQL_HOME\lib\opt but it is only in

Re: [R] RMySQL with Windows 7

2014-02-06 Thread Christian Oswald
I have the 5.5 Server but in the opt directory are only two files libmysql.dll and libmysql.lib Christian Am 06.02.2014 16:29, schrieb Gabor Grothendieck: On Thu, Feb 6, 2014 at 3:52 PM, Christian Oswald christian.osw...@diospi-suyana.org wrote: I understand, but in my case the R-Library is

[R] RMySQL with Windows 7

2014-02-05 Thread Peretz, Eliran
Hi , I read your post and followed your instructions but still couldn't install RMySQL by getting the message: installation of package ‘RMySQL’ had non-zero exit status Can you please walk me through the process from the installation part (version, etc) to all the paths that need to be

[R] RMysql on Windows 7

2011-08-20 Thread Twaha Mlwilo
Hello all, good day I have installed R 1.13.0 on windows 7. then configured R + latex + sweave to use eclipse indigo.Then would like to be able to work with R + mysql 5.5(full package + connectors) which I have already installed.My problem is to build RMYSQL binary package, using

Re: [R] RMysql on Windows 7

2011-08-20 Thread Uwe Ligges
On 20.08.2011 17:22, Twaha Mlwilo wrote: Hello all, good day I have installed R 1.13.0 on windows 7. then configured R + latex + sweave to use eclipse indigo.Then would like to be able to work with R + mysql 5.5(full package + connectors) which I have already installed.My problem is to