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

[João Gonçalves]

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.
>>      
>