João Gonçalves
2010-Jun-29 22:35 UTC
[R] RPostgreSQL - Unable to locate required modules/DLLs on WinXP/7
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.
Joe Conway
2010-Jun-29 22:44 UTC
[R] RPostgreSQL - Unable to locate required modules/DLLs on WinXP/7
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 -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 899 bytes Desc: OpenPGP digital signature URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20100629/15e443d1/attachment.bin>
Dirk Eddelbuettel
2010-Jun-29 22:45 UTC
[R] RPostgreSQL - Unable to locate required modules/DLLs on WinXP/7
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. > > Best regards, > Jo?o Gon?alves. > > ______________________________________________ > 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.-- Three out of two people have difficulties with fractions.