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

[Neil Tiffin]

Sorry, I did not see your reply on r-help and way too much going on.  Thanks for the clarification.

On Apr 13, 2010, at 7:47 PM, Dirk Eddelbuettel wrote:

> 
> On 13 April 2010 at 18:59, Neil Tiffin wrote:
> | 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?
> 
> I think I disagree
> 
> | >> 'C:/Users/james/Documents/R/win-library/2.10/RPostgreSQL/libs/RPostgreSQL.dll':
> | >> |   LoadLibrary failure:  The specified module could not be found.
> 
> It fails to load the dll for the package.  As I told James when he first
> posted to r-help, he should try to added the Postgresql binary directory to
> the path.
> 
> Dirk
> 
> | 
> | 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
> | 
> | _______________________________________________
> | 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
> 
> -- 
>  Registration is open for the 2nd International conference R / Finance 2010
>  See http://www.RinFinance.com for details, and see you in Chicago in April!