Displaying 20 results from an estimated 2000 matches similar to: "DBI Package"
2004 Jan 09
1
R and Postgresql (DBI)
Hi,
I'm running Debian (Sid), Postgres (7.3.4) and
R (1.8.1).
I get the following error when I tri to use DBI
>library("DBI")
> p <- dbDriver("PostgreSQL")
Error in do.call(as.character(drvName), list(...)) :
couldn't find function "PostgreSQL"
Is there any other package I need in order to
interface between R and Postgres ?
2008 Jun 30
2
Using ODBC/RODBC with DBI
Hi all, I would like the following code to work, but it doesn't:
library(DBI)
library(RODBC)
m <- dbDriver("RODBC") # Example for dbConnect(DBI), causes error
m <- dbDriver("ODBC") # Example for DBIDriver-class(DBI), causes error
The errors are:
Error in do.call(as.character(drvName), list(...)) :
could not find function "RODBC"
(substitute
2007 Jun 14
2
connecting to DB2 database
Hi,
i am trying to connect to a DB2 server using the DBI library.
getData <- function()
{
driver <- dbDriver("DB2")
conn <- dbConnect(driver,"server","uname","pword")
data <- dbSendquery(conn, "select etc.")
}
When I run the function, i get the error
> data <- getData()
Error in
2005 Jan 21
5
functions not found after installing DBI/RDBI packages
Hi,
I would like to be able to use R with a connection to a PostgreSQL database. I am using R 2.0.1 on windows XP. I have tried installing both the DBI and rDBI packages (which is better?) but in either case I run into the same problem - when i try to use either the dbDriver or dbConnect functions i'm told the function couldn't be found. Seems like the packages aren't installing
2014 Sep 12
1
requireNamespace() questions
I am trying to follow directions at
http://cran.r-project.org/doc/manuals/r-patched/R-exts.html#Suggested-packages
regarding handling suggested packages with requireNamespace() rather
than require(), and I have some questions.
1/ When I do requireNamespace() in a function is the loading of the
namespace only effective within the function?
2/ At the link above in the manual it says "Note
2007 Aug 15
1
Problem Connecting to Oracle with R from Windows XP
Hello,
I installed RGui 2.5.1 and package DBI on Windows XP and tried to connect to Oracle database which is on a Linux server. When I tried to use dbDriver("Oracle"), I got an error as follows:
> drv <- dbDriver("Oracle")
Error in do.call(as.character(drvName), list(...)) :
could not find function "Oracle"
>
Could anyone tell me how
2007 Feb 15
1
Unable to connect to PostgreSQL
Hi R users,
I am a beginner trying to connect to PostgreSQL using R
When I give the following command drv<-dbDriver("PostgreSQL")
I am getting the following error Error in
do.call(as.character(drvName), list(...)) : could not find function
"PostgreSQL"
I have installed PostgreSQL 8.1 in my system. I am currently using R
2.3.1.
Any help would be
2004 Jul 14
3
ROracle - fetch gives empty dataframe
Dear R-users,
I was able to make ROracle package to connect to the DB (Oracle91,
64bit, on Solaris). But after executing siple SQL query, "fetch"
commaned gives me an empty dataframe.
### RORACLE INSTALATION PROCEDURE ###
R CMD INSTALL --configure-args='--enable-extralibs' --enable-oracle32=no
~/tmp/ROracle_0.5-5.tar.gz #since we have 64bit Oracle9i instalation
PROBLEM:
2009 Nov 05
1
Error when adding package RMySQL (PR#14044)
Full_Name: K?re Jonsson
Version: 2.10
OS: WinXP
Submission from: (NULL) (85.225.178.169)
I made a brand new installation of R 2.10 in two machines and got the same
problem.
Machine 1 is Win XP on metal installation
machine 2 is virtual in VMWare running a hacky OS named Tiny XP in which any
Microsoft windows XP siftware always successfully is installed.
Operation 1. Add package RMySQL from
2005 Dec 09
2
Status of PostgreSQL using DBI?
Greetings - is there any update on a PostgreSQL driver for the DBI
package? If not, what's the currently-preferred method of creating a link
from a PostgreSQL database and R?
Thanks.
----------------------------------------------------------------------
Andrew J Perrin - andrew_perrin (at) unc.edu - http://www.unc.edu/~aperrin
Assistant Professor of Sociology; Book Review Editor, _Social
2007 Jan 10
1
using DBI
can anybody provide a reference to a document on using DBI and what is
needed to make it work?
I try: drv=dbDriver("Oracle")
and it complains about not finding a function.
The DBI.pdf does not require anything else installed, but looking at the
archive I discovered there is more stuff to be installed.
This is on Solaris 5.10 with a full Oracle install, so all Oracle libs
are
2004 Dec 09
1
ROracle/DBI problem with dbExecStatement on RH Linux
Hi,
first thanks to Sunny Ho (and David James for the pointer) for resolving
the problem of the empty rows returned from ROracle.
However, I have a problem still:
> library(ROracle)
> ora <- dbDriver("Oracle")
> con <- dbConnect(ora, user = USER, password = PWD, dbname = DBNAME)
> rs <- dbExecStatement(con, "select * from USER_TABLES")
Error in
2002 Sep 12
1
DBI / MySQL problems
Hi.
I frequently use RMySQL package to interface R with MySQL databases. I was
having a try with package DBI and I got the following error:
> library(RMySQL)
> library(DBI)
> drv <- dbDriver("MySQL")
> ch <- dbConnect(drv, dbname="mydb", user="myuser", password="mypasswd")
> ibm <- dbGetQuery(ch,"select * from table where
2019 Jan 25
2
Bacula 9.4.1 Dbdriver issue
Hi list,
I created my rpm for Bacula 9.4.1 reading centos srpm spec files. I made
a single package and not split in several packages because this is my
first rpm so I created my spec file taking a cue from bacula-5.3 spec file.
All works as intended, an rpm was created and installed without any not
fixable issue.
After installing my bacula rpm I run a test to see if all works as
expected.
2006 Oct 03
1
problem installing RdbiPgSQL for 2.4
I just upgraded R to version 2.4.0 and now I can't install packages
RdbiPgSQL. I used the same procedure I did for previous versions of R !
Actually, last time I installed RdbiPgSQL day before upgrading
but now I got:
downloaded 27Kb
* Installing *source* package 'RdbiPgSQL' ...
creating cache ./config.cache
checking for PQconnectdb in -lpq... no
I could not find your PostgreSQL
2007 Feb 05
1
RdbiPgSQL in R 2.4.1
Hi R-users
I recently downloaded RdbiPgSQL 1.8.0 and Rdbi 1.8.0 from Bioconductor to be
installed under R 2.4.1.
When requiring RdbiPgSQL an error message is showed as follows:
> require(RdbiPgSQL)
Loading required package: RdbiPgSQL
Error in library(package, lib.loc = lib.loc, character.only = TRUE, logical
= TRUE, :
‘RdbiPgSQL’ is not a valid package – installed <
2007 Feb 18
1
dbi, rodbc, rmysql, charset problem
Dear List
In my short life as a beginning R-user i've encountered a following
problem that i'm unable to solve myself:
I have a database in MySQL containing table and field names as well as
some data containing Polish accentuated characters (like ????),
utf8-encoded. It works just fine with just any external query browser i
can find, jdbc, odbc, native, whatever. Also mysql is happy
2003 Oct 11
2
Problem in 'methods' package (PR#4525)
Full_Name: Fernando Henrique Ferraz Pereira da Rosa
Version: 1.8.0
OS: Linux 2.4.21
Submission from: (NULL) (200.206.211.169)
After installing R 1.8.0, the R DBI interface stopped working. I tracked it
down as a problem in the 'methods' package, that comes in the default
installation.
Somehow the function '.valueClassTest' which is defined on package
'methods',
2002 Oct 16
5
Database newbee problem...
Hi all,
This is a potentially very stupid question about MySQL <-> R
interaction, but I have not been able to solve it.
I'm just trying to connect R to my MySQL databse, and gets this:
> library(RMySQL)
Loading required package: methods
> m <- dbDriver("MySQL")
> con <- dbConnect(m,group="testdb")
Process R segmentation fault at Wed Oct 16 07:04:30
2011 Jun 28
2
connecting R and PostgreSQL
Dear R-helpers,
I'm an absolute beginner using both R and PostgreSQL, but now I have to work with both programs. I need to connect R and my Postgres-database, but every attempt so far has failed (I tried using the RpgSQL package as well as RdbiPgSQL, the first, following this manual (http://code.google.com/p/rpostgresql/) didn't find any drivers for the database (step no. 1) whereas the