[R-sig-DB] RMySQL error under Windows Server 2008 64-bit

[Michael Styer]

Prof Brian Ripley wrote:
> On Fri, 19 Dec 2008, Michael Styer wrote:
> 
>> Michael Styer wrote:
>>> Prof Brian Ripley wrote:
>>>> Are you running R on that server?
>>>
>>> Yes, it's all happening on the same server.
>>>
>>>> If not (the most likely answer), you need MySQL on the client.
>>>>
>>>> If yes, I think you need 32-bit MySQL for RMySQL, even with a 64-bit 
>>>> server, since R for Windows is 32-bit.  But I've not seen a 64-bit 
>>>> Windows install of MySQL.
>>>
>>> That's interesting. It doesn't seem to be reaching an incompatibility 
>>> with the version of MySQL, though. The installation routine for 
>>> RMySQL doesn't seem to be able to find the MySQL installation at all, 
>>> so I was trying to figure out how to make sure it at least found the 
>>> installation.
>>
>> OK, some further results. I set MYSQL_HOME="C:/Program 
>> Files/MySQL/MySQL Server 5.0". Sys.getenv("MYSQL_HOME") was escaping 
>> the double-backslashes in the value I used before.
>>
>> Now RMySQL is able to find the installation, but I think we do run 
>> into an incompatibility with 64-bit MySQL at this point. Trying to 
>> load the RMySQL library I get this error:
>>
>>  > library("RMySQL")
>>  Loading required package: DBI
>>  Error in inDL(x, as.logical(local), as.logical(now), ...) :
>>    unable to load shared library 
>> 'C:/PROGRA~2/R/R-28~1.0/library/RMySQL/libs/RMySQL.dll':
>>    LoadLibrary failure:  %1 is not a valid Win32 application.
>>
>>
>>  In addition: Warning message:
>>  package 'RMySQL' was built under R version 2.8.1
>>  Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
>>  Error: package/namespace load failed for 'RMySQL'
>>
>> The file RMySQL.dll does exist in that location, but it fails to load. 
>> This is beyond my knowledge; would that be because it needs a 32-bit 
>> version of MySQL to load correctly?
> 
> Yes, it does.  A 64-bit installation should not be under Program Files 
> (at least on the systems I've seen), so install a 32-bit application 
> somewhere else.

OK, thanks. This is the first 64-bit Windows machine I've worked with 
myself. It seems to install 64-bit apps in Program Files and 32-bit apps 
in Program Files (x86).

I'm downloading the 32-bit version as we speak; I'll try installing that 
and pointing R to that installation.

Thanks for your help.

Michael