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

[Gabor Grothendieck]

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
>