[BioC] Rdbi
Hrishikesh Deshmukh
d_hrishikesh at yahoo.com
Sat Nov 5 20:01:06 CET 2005
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"
More information about the Bioconductor
mailing list