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@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, rip...@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@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. ______________________________________________ R-help@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.