Entering edit mode
hrishikesh deshmukh
▴
420
@hrishikesh-deshmukh-1008
Last seen 10.4 years ago
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="postg
res",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="postgr
es",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"