[R] RPostgreSQL: unable to load shared library

[stephenb]

I am trying the same as the post above and the actual error is:

the ordinal 284 could not be located in the dynamic link library
SSLEAY32.dll

I searched for that dll and it is not to be found. windows forums provide
vague directions to reinstall Windows, which I cannot do because this is a
company PC and IT will be happy to tell me that's why open source programs
are not supported and not encouraged.

any suggestions are appreciated.

Stephen


Prof Brian Ripley wrote:
> 
> On Wed, 14 Oct 2009, Fanfaar wrote:
> 
>> Hello list,
>>
>> I'm using R 2.9.2 on a WinXP system, and I installed the RPostgreSQL
>> library using the package installer. When trying to load it, I get the
>> following error:
>>
>>> library('RPostgreSQL')
>> Error in inDL(x, as.logical(local), as.logical(now), ...) :
>>  unable to load shared library
>> 'C:/PROGRA~1/R/R/library/RPostgreSQL/libs/RPostgreSQL.dll':
>>  LoadLibrary failure:  The operating system cannot run %1.
>>
>> Error: package/namespace load failed for 'RPostgreSQL'
>>
>> So one way or the other, the DLL is not found... Does anyone know how
> 
> That is not what it says: it says it cannot *load* the DLL.  You need 
> the PostgreSQL client dll in your path, and I guess that (or its 
> version) is the problem.  (Usually Windows gives you a popup with more 
> information, and indeed on my laptop it told me LIBPQ.DLL could not be 
> found.) And pedump suggests that it is linked against entry points by 
> number not name, a very fragile arrangement.
> 
> I always worry that packages that link to external DLLs can be very 
> dependent on the version of that DLL (and see the above comment).  I 
> could not see a description of the version of PostgreSQL used on Uwe's 
> ReadMe (assuming this is a binary from CRAN), and suggest (as did the 
> rw-FAQ) that you install RPostgreSQL from source against your own 
> PostgreSQL installation.  (That's what I do on my Windows desktop 
> which does have PostgreSQL installed, and when I updated PostgreSQL I 
> had to re-install PostgreSQL ....)
> 
>> to fix this? I don't suppose DLL should be directly in my PATH, right?
>>
>> Thanks for any hints,
>> Arnout
>>
>> ______________________________________________
>> 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.
> 
> Yes another person who thinks that does not apply to them.
> 
> 
> -- 
> Brian D. Ripley,                  ripley at stats.ox.ac.uk
> Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
> University of Oxford,             Tel:  +44 1865 272861 (self)
> 1 South Parks Road,                     +44 1865 272866 (PA)
> Oxford OX1 3TG, UK                Fax:  +44 1865 272595
> 
> ______________________________________________
> 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.
> 
> 

-- 
View this message in context: http://old.nabble.com/RPostgreSQL%3A-unable-to-load-shared-library-tp25895592p26197137.html
Sent from the R help mailing list archive at Nabble.com.