Prof Brian Ripley wrote:
On Wed, 14 Oct 2009, Fanfaar wrote:
Hello list,
I'm using R 2.9.2 on a WinXP system, and I installed the RPostgreSQL
library using the package installer. When trying to load it, I get the
following error:
library('RPostgreSQL')
Error in inDL(x, as.logical(local), as.logical(now), ...) :
unable to load shared library
'C:/PROGRA~1/R/R/library/RPostgreSQL/libs/RPostgreSQL.dll':
LoadLibrary failure: The operating system cannot run %1.
Error: package/namespace load failed for 'RPostgreSQL'
So one way or the other, the DLL is not found... Does anyone know how
That is not what it says: it says it cannot *load* the DLL. You need
the PostgreSQL client dll in your path, and I guess that (or its
version) is the problem. (Usually Windows gives you a popup with more
information, and indeed on my laptop it told me LIBPQ.DLL could not be
found.) And pedump suggests that it is linked against entry points by
number not name, a very fragile arrangement.
I always worry that packages that link to external DLLs can be very
dependent on the version of that DLL (and see the above comment). I
could not see a description of the version of PostgreSQL used on Uwe's
ReadMe (assuming this is a binary from CRAN), and suggest (as did the
Good point, I will add that version 8.3.4-1 is used on CRAN.
Best,
Uwe
rw-FAQ) that you install RPostgreSQL from source against your own
PostgreSQL installation. (That's what I do on my Windows desktop which
does have PostgreSQL installed, and when I updated PostgreSQL I had to
re-install PostgreSQL ....)
to fix this? I don't suppose DLL should be directly in my PATH, right?
Thanks for any hints,
Arnout
______________________________________________
R-help@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.
Yes another person who thinks that does not apply to them.
______________________________________________
R-help@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.