[R] [RPostgreSQL] Fails to load

[james]

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/)

TIA to anyone who can shed some light.

Regards,
Jim Hargreaves