[R] NppToR / RMySQL / loadNamespace() Error

[Peter Meissner]

Thanks a lot for the input (and thanks for R),

but nope, both R versions are  the same ... and I really do not think 
that NppToR is actually causing the problem.

Since RMySQL has problems (as I understand the errors/warnings) to find 
what it expects to find I thought that maybe there is a way to manually 
tell it whatever information is lost when RGUI is started by an external 
program (I already set the MYSQL_HOME system variable to where MySQL is 
installed).

I really do not think that NppToR causes the problem but that the 
startup is somewhat different and therefore path information get mixed 
up or regestry entries are not found anymore - I guess.

(Info: NppToR is a small program that allows to use one of those very 
very popular awesome, professional and allround text editors in 
combination with R by passing through code from the editor to R ... like 
Emacs for Windows or TinR or ... .)

Best, Peter



Am 20.05.2014 18:46, schrieb Brian Ripley:
> We have no idea what NppToR Is.  But as a guess you ran 64-bit R and it ran 32-bit or v.v.
> Why don't you ask NppToR's help service?
>
> The architecture of MySQL must match that of the R under which you installed RMySQL.
>
>
>> On 20 May 2014, at 15:08, Peter Meissner <peter_mei at web.de> wrote:
>>
>> Dear Listeners,
>>
>> I finally managed to install RMySQL on my Win7(64Bit) machine with R.3.1.0.
>>
>> Now, as long as I start R manually and load the package everything is
>> working just fine: the package loads and I can connect to a database and
>> query it.
>>
>> But, when NppToR does start the R session for me something is going
>> wrong and I have no clue where even to start.
>>
>> The R-output reads like this:
>>
>>
>>> require(RMySQL)
>> Loading required package: RMySQL
>> Loading required package: DBI
>> Error : .onLoad failed in loadNamespace() for 'RMySQL', details:
>> call: utils::readRegistry("SOFTWARE\\MySQL AB", hive = "HLM",
>> maxdepth = 2)
>> error: Registry key 'SOFTWARE\MySQL AB' not found
>>
>>
>> Does anybody have an idea how to fix or circumvent this?
>>
>>
>> Best, Peter
>>
>> ______________________________________________
>> 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.