[R] Problems Building RMySQL in Windows

[Christian Schulz]

I get the same,

library(RMySQL)
    Warning message:
    DLL attempted to change FPU control word from 8001f to 9001f

...but until now this never occur in a crash and i develope
a complex direct-marketing-system what get's and put's dynamically
~ 100.000 cases and 50 ~ variables  with this tools!

I experiment something, how i get runing  mysql 4.1.0.alpha!

(1.)  Install with the reimport description and the different path settings
mysql4.0 and RMySQL.
Now, when this works it is possible to unzip the  mysql-4.1.0-alpha.zip and
overwrite
your Mysql4.0 installation.

(2.) Doing the remip libmysql.lib etc. direct for the 4.1.0-alpha occur for
me in problems!?

<MySQLConnection:(620,0)>
  User: root
  Host: localhost
  Dbname: test
  Connection type: localhost via TCP/IP
  MySQL server version:  4.1.0-alpha-max-nt
  MySQL client version:  4.0.15
  MySQL protocol version:  10
  MySQL server thread id:  5
  No resultSet available

regards,christian




----- Original Message -----
From: "Héctor Villafuerte D." <hec.villafuerte at telgua.com.gt>
To: <r-help at stat.math.ethz.ch>
Sent: Thursday, October 16, 2003 3:19 AM
Subject: Re: [R] Problems Building RMySQL in Windows


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.

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help