[R] RPostgreSQL - Unable to locate required modules/DLLs on WinXP/7

João Gonçalves joaofgo at gmail.com
Wed Jun 30 00:35:44 CEST 2010


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?

I'm using R-2.11.1 on WinXP/7.

Best regards,
João Gonçalves.



More information about the R-help mailing list