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

From: Dirk Eddelbuettel <edd_at_debian.org>
Date: Tue, 29 Jun 2010 22:45:12 +0000

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.

______________________________________________
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.
Received on Tue 29 Jun 2010 - 22:47:24 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 30 Jun 2010 - 00:50:43 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive