RMySQL crashes R
I havn't tried your mysql-approach, but have with no problems used a very different approach to connect R and mysql (and other databases) I use the folowing setup (everything opensource with no licensing costs): - Linux Redhat 8.0 - Zope 2.6.1 (www.zope.org) - RSessionDA, RSOAP and rpy (find via www.google.com) - R1.6.2 with SESSION package (SESSION package is included in the RSESSIONDA download) - Mysql 3.23.52 (included in Redhat 8.0 distr.) In this setup R and Mysql are webservices connected via Zopes python-based technology. This approach makes it very easy to distribute the use of R and mysql since the userinterface is the web. And the approach also makes it very easy to svitch from mysql to postgresql or Oracle as the backend database. I you want to try this solution before you start building please send me a mail, and I shall open my router for a short while. I also have a few screenshots showing integration to Excel from R (via zope) here. The text is in danish, but the pictures should be selfexplanatory: http://www.zug.dk/Members/Nielssteenkrogh/1049270051696377330/view Regards Niels Cand. Polit. Niels Steen Krogh Solsortvej 44 2000 F. Tlf: 3888 8613 ZiteLab / EmpoweR youR data _________________________________________________________________ Få Hotmail på mobilen http://www.msn.dk/mobile