[R-sig-DB] Need help with database library DBI and ODBC

[Dirk Eddelbuettel]

On 18 February 2008 at 11:16, Daniele Amberti wrote:
| I need an example on how to use library DBI coupled with a ODBC driver.
| I get this error:
| Error in do.call(as.character(drvName)
| As many other trying to use PostgreSQL
| I think it is possible but I'm not able to find the way.

Sorry, but you're wrong. You're mixing two incompatible ingredients.  The DBI
system for R has no ODBC plugin, and no Postgres plugin either. 

You can use RODBC for ODBC, with proper ODBC drivers and settings.  Not for
the faint of heart, see the README in the source and consult your IT
department if you have questions.

PostgreSQL has not DBI module. There is however a working pair of packages at
the BioConductor repositories: Rdbi and RdbiPgSQL. Note that Rdbi != DBI.  

Hope this helps, Dirk

-- 
Three out of two people have difficulties with fractions.