[BioC] RdbiHrishi,

PgSQL() is part of RdbiPgSQL.  RDBI is a generic set of functions for dealing with databases.  You need RdbiPgSQL to connect to postgresql using Rdbi.  

You might look into RODBC instead.  I haven't tried it, but I imagine there is an ODBC driver for postgresql for your system.

Sean

  ----- Original Message ----- 
  From: Hrishikesh Deshmukh 
  To: bioconductor@stat.math.ethz.ch 
  Sent: Saturday, November 05, 2005 2:01 PM
  Subject: [BioC] Rdbi


  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" 

  _______________________________________________ 
  Bioconductor mailing list 
  Bioconductor@stat.math.ethz.ch 
  https://stat.ethz.ch/mailman/listinfo/bioconductor 

	[[alternative HTML version deleted]]

