Thank you for the fast replies.
I've set the PATH env var to include the PostgreSQL bin diectory and
it's working fine.
On 29-06-2010 23:44, Joe Conway wrote:
On 06/29/2010 03:35 PM, João Gonçalves wrote:
Error: package 'RPostgreSQL' could not be loaded
exists which makes RPostgreSQL loading to fail. The message appears for
any of the following DLLs (that actually exist on
X:/PostgreSQL_installation_directory/bin):
To "solve" this problem the actual DLLs from the PostgreSQL installation
directory must be copied into the X:/WINDOWS/System32 shared libraries
folder in order to make the package operational.
Is there a way to solve this from the package internals without having
to copy the DLLs? Am I missing something here?
If I am not mistaken, you need to be sure that the directory containing
the DLLs in in your PATH.
HTH,
Joe
On 29-06-2010 23:45, Dirk Eddelbuettel wrote:
On Tue, Jun 29, 2010 at 11:35:44PM +0100, João Gonçalves wrote:
Dear list users,
The problem occurs when library(RPostgreSQL) is issued on R. This issue
has previously appeared on R mailing list without any robust solution.
The error message issued by R:
Loading required package: RPostgreSQL
Loading required package: DBI
Error in inDL(x, as.logical(local), as.logical(now), ...) :
unable to load shared library
'C:/PROGRA~1/R/R-210~1.1/library/RPostgreSQL/libs/RPostgreSQL.dll':
LoadLibrary failure: Unable to locate the specified module.
Error: package 'RPostgreSQL' could not be loaded
At the same time an error box appears saying that a given DLL does not
exists which makes RPostgreSQL loading to fail. The message appears for
any of the following DLLs (that actually exist on
X:/PostgreSQL_installation_directory/bin):
libpq.dll
ssleay32.dll
libeay32.dll
libintl-8.dll
libiconv-2.dll
krb5_32.dll
comerr32.dll
k5sprt32.dll
msvcr71.dll
gssapi32.dll
To "solve" this problem the actual DLLs from the PostgreSQL installation
directory must be copied into the X:/WINDOWS/System32 shared libraries
folder in order to make the package operational.
Is there a way to solve this from the package internals without having
to copy the DLLs? Am I missing something here?
You are missing the correct use of the PATH environment variable.
I'm using R-2.11.1 on WinXP/7.
______________________________________________
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.
