[R] Problems Building RMySQL in Windows

["Héctor Villafuerte D."]

David James wrote:

>"Héctor Villafuerte D." wrote:
>  
>
>>Thanks David,
>>I tried the binaries you sent me. Here's the warning it gave me:
>>
>>    > library(RMySQL)
>>    Warning message:
>>    DLL attempted to change FPU control word from 8001f to 9001f
>>    
>>
>
>I have seen this, but it has not caused any problem to me, so my
>reaction is that it may be ok to ignore.
>
>  
>
>>Then I tried to do this:
>>
>>    > con <- dbConnect(dbDriver("MySQL"), dbname = "test")
>>
>>but it crashed R.
>>    
>>
>
>I've seen this too.  Typically it is a *.dll conflict between the
>version of the MySQL library included and used for compiling RMySQL
>(MySQL 3.23.56) and the runtime MySQL library you use (say, 4.0.x).
>If this is the problem, you can easily fix it by making sure your
>PATH variable picks the *.dll used in the RMySQL package first
>(ahead of the 4.0.x *.dll).
>
>Hope this helps,
>
>--
>David
>  
>

Here is a  copy of my PATH environment variable:
C:\Perl\bin\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;
"C:\Program Files\NMapWin\bin";c:\cygwin\bin;C:\Python23;
"C:\Program Files\R\rw1071\library\RMySQL\libs";C:\mysql\bin

And yes... running dbConnect still crashes R...
Thanks again for your help.