[R-sig-DB] [RPostgreSQL] Fails to Load

[Neil Tiffin]

It appears to me that it is looking for the dependency DBI.  When you installed RPostgreSQL did you check the box (at least on Mac) to install all dependencies?  Is DBI installed?

On Apr 13, 2010, at 1:31 PM, Gabor Grothendieck wrote:

> 1. Use dependencywalker at dependencywalker.com to find out where
> RPostgreSQL.dll is looking for the other dll's.
> 
> 2. There is also the RpgSQL package on CRAN which uses JDBC.  See the
> INSTALL file in that package for more info:
> 
> http://cran.r-project.org/web/packages/RpgSQL/INSTALL
> http://cran.r-project.org/web/packages/RpgSQL/index.html
> 
> On Tue, Apr 13, 2010 at 12:14 PM, james <james using ipec.co.uk> wrote:
>> Reposting a message I posted on the R-help list.
>> 
>> |Hi List,
>> | | Running R 2.10.1 on a fresh install of Windows 7. I get the following |
>> error when loading the RPostgreSQL package.
>> | | |  >library(RPostgreSQL)
>> | Loading required package: DBI
>> | Error in inDL(x, as.logical(local), as.logical(now), ...) :
>> |   unable to load shared library |
>> 'C:/Users/james/Documents/R/win-library/2.10/RPostgreSQL/libs/RPostgreSQL.dll':
>> |   LoadLibrary failure:  The specified module could not be found.
>> | | Error: package/namespace load failed for 'RPostgreSQL'
>> | | | I have reinstalled the RPostgreSQL package from several different |
>> mirrors and reinstalled R, and the error remains. I know that | RPostgreSQL
>> depends on libpq.dll and others, so I downloaded and | installed Postgres,
>> then copied the contents of PostgreSQL\8.4\lib to | the RPostgreSQL library
>> | (C:/Users/james/Documents/R/win-library/2.10/RPostgreSQL/libs/)
>> | | Regards,
>> | James Hargreaves
>> 
>> _______________________________________________
>> R-sig-DB mailing list -- R Special Interest Group
>> R-sig-DB using stat.math.ethz.ch
>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>> 
> 
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db