did you try the RODBC package as well.
Regards
Ajay
Websites-
http://decisionstats.com
http://dudeofdata.com
Linkedin- www.linkedin.com/in/ajayohri
On Sat, Nov 13, 2010 at 9:22 AM, Santosh Srinivas
<santosh.srinivas at gmail.com> wrote:> Dear Group,
>
> I'm having lots of problems getting RMySQL on a 64 bit machine. I
followed
> all instructions available but couldn't get it working yet! Please
help.
> See the output below.
>
> I did a install of RMySQL binary from the revolution cran source. It seems
> to have unpacked fine but gives this error when I call RMySQL
> Error: package 'RMySQL' is not installed for 'arch=x64'
>
>
> I set this environment variable on the windows path
>> Sys.getenv('MYSQL_HOME')
> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? MYSQL_HOME
> "C:/Program Files/MySQL/MySQL Server 5.0"
>
>> ?install.packages('RMySQL',type='source')
> trying URL
>
'http://cran.revolutionanalytics.com/src/contrib/RMySQL_0.7-5.tar.gz'
> Content type 'application/x-gzip' length 160769 bytes (157 Kb)
> opened URL
> downloaded 157 Kb
>
> * installing *source* package 'RMySQL' ...
> checking for $MYSQL_HOME... C:/Program Files/MySQL/MySQL Server 5.0
> test: Files/MySQL/MySQL: unknown operand
> ERROR: configuration failed for package 'RMySQL'
> * removing
'C:/Revolution/Revo-4.0/RevoEnt64/R-2.11.1/library/RMySQL'
> * restoring previous
> 'C:/Revolution/Revo-4.0/RevoEnt64/R-2.11.1/library/RMySQL'
>
> The downloaded packages are in
>
>
'C:\Users\Administrator\AppData\Local\Temp\2\RtmpvGgrzb\downloaded_packages'
> Warning message:
> In install.packages("RMySQL", type = "source") :
> ?installation of package 'RMySQL' had non-zero exit status
>> sessionInfo()
> R version 2.11.1 (2010-05-31)
> x86_64-pc-mingw32
>
> locale:
> [1] LC_COLLATE=English_United States.1252 ?LC_CTYPE=English_United
> States.1252 ? ?LC_MONETARY=English_United States.1252 LC_NUMERIC=C
>
> [5] LC_TIME=English_United States.1252
>
> attached base packages:
> [1] stats ? ? graphics ?grDevices utils ? ? datasets ?methods ? base
>
> other attached packages:
> [1] Revobase_4.0.0 ? RevoScaleR_1.0-0 lattice_0.18-8
>
> loaded via a namespace (and not attached):
> [1] grid_2.11.1 ?tools_2.11.1
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>