[BioC] Rdbi

[Hrishikesh Deshmukh]

Hi All,

I am trying to connect to PostgreSQL on WinXP using
Rdbi since Rdbi.PgSQL is not available for WinXP.

Here is the error output which i get and sessionInfo()
output.

How does one get PgSQL()
Could someone help/explain what i am doing wrong?

Thanks,
Hrishi


> library(Rdbi)

>
dbconn<-dbConnect(PgSQL(),host="#####",dbname="%%%%%%%%%%",user="postgres",password="calvin")

Error in dbConnect(PgSQL(), host = "localhost", dbname
= "trial", user = "postgres", :

couldn't find function "PgSQL"

>
dbconn<-dbConnect(PgSQL,host="localhost",dbname="trial",user="postgres",password="calvin")

Error in dbConnect(PgSQL, host = "localhost", dbname =
"trial", user = "postgres", :

Object "PgSQL" not found

>
dbconn<-dbConnect(pgsql(),host="localhost",dbname="trial",user="postgres",password="calvin")

Error in dbConnect(pgsql(), host = "localhost", dbname
= "trial", user = "postgres", :

couldn't find function "pgsql"

>
dbconn<-dbConnect(pgsql,host="localhost",dbname="trial",user="postgres",password="calvin")

Error in dbConnect(pgsql, host = "localhost", dbname =
"trial", user = "postgres", :

Object "pgsql" not found

> sessionInfo()

R version 2.1.1, 2005-06-20, i386-pc-mingw32

attached base packages:

[1] "methods" "stats" "graphics" "grDevices" "utils"
"datasets" "base"

other attached packages:

Rdbi

"1.1.2"