Displaying 20 results from an estimated 7000 matches similar to: "requireNamespace() questions"
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
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
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
2008 Sep 15
2
S4 coercion responsibility
Should functions or the user be responsible for coercing an S4 object
argument containing the proper object (and thus should below be
considered a bug in the packages or not)?
The example is with RSQLite but the same thing happens with RMySQL, and
other DBI packages.
> library("RSQLite") Loading required package: DBI
> m <- dbDriver("SQLite")
> con <-
2007 Oct 31
2
DBI Package
Hello everyone!
Congratulations by this gorgeous software.
My name is Germán Carrillo, I'm writting from Colombia. I don't have much
experience with R, reason why I use the R-GUI (version 2.5.1) on Windows.
I have some problems with DBI package, I want to connect to PostgreSQL
database but I don't know the way to do it.
I was reading the DBI manual and I tried write in my R Console
2007 Jul 16
1
S4 coerce
(I am not sure if this is a bug or a request for a more understandable
warning, or possible something obvious I should be posting on r-help.)
I am trying to coerce an new class object to be a DBIConnection and it
does not work the way I think it should:
R version 2.5.1 (2007-06-27) ...
> require("RMySQL") # or require("RSQLite")
Loading required package: RMySQL
Loading
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 ?
2005 Jan 29
2
Database Connection Problem with RMySQL package
Folks,
I failed to create a connection to the database under MySQL DBMS in
the R system via RMySQL's method dbConnection(...).
My setup is as follows:
Microsoft Windows XP 5.1.2600
MySQL 4.1.9
R 2.0.1
DBI 0.1-8
RMySQL 0.5-5
Both of DBI and RMySQL packages were downloaded from bell lab:
http://stat.bell-labs.com/RS-DBI/download/index.html
My case in R is as follows:
> library(DBI)
2003 Oct 19
1
Running RMySQL with SuSE 8.2?
Since there doesn't appear to be an RMySQL rpm for SuSE 8.*, does
anyone know if the 7.3 version will work with the SuSE 8.2 rpms of R and
DBI?
The package installs without complaint, but when I try to run
con <- dbConnect(dbDriver("MySQL"),dbname="test")
I get the error
Error in dbConnect(dbDriver("MySQL")) : couldn't find function
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
2005 Oct 18
1
RMySQL problems
I get the following error trying to connect to a MySQL database:
> library(RMySQL)
Loading required package: DBI
> drv<-dbDriver("MySQL")
> con<-dbConnect(drv, user="hothand", password=xxx,
host="localhost", dbname="hh03");
Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not
connect hothand at localhost on dbname
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
2003 Dec 10
1
How to start RMySQL
I am a newbie in R and want to use MySQL database. Here is what I have and
done.
R 1.8.0
mysql 4.0.16
Both running in Windows XP. I download the RMySQL.zip from the internet and
used the Packages installer in the RGui to install RMySQL. I also installed
DBI packages. I ran the following and got the error.
> mgr<-dbDriver("MySQL")
Error in dbDriver("MySQL") :
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
2012 Aug 22
1
loading both RPostgreSQL and RSQLite leads to problems
hello,
if i load the RSQLite package in addition to the RPostgreSQL package,
i get various errors when trying to use RPostgreSQL functions. here is
an example transcript showing one such error:
==========================================================
R version 2.15.0 (2012-03-30)
[...]
> packageVersion('RPostgreSQL')
[1] 0.3.2
> packageVersion('RSQLite')
[1] 0.11.1
2003 May 13
2
RMySQL crashes R
I have justed upgraded R v1.7.0 on Windows NT 4 and have installed the
latest RMySQL (version 0.5-1)and DBI (version 0.1-5) packages.
When I issue the following commands (tactfully adjusted) R just crashes and
disappears, any ideas?
require(RMySQL)
m <- dbDriver("MySQL")
con <- dbConnect(m, dbname="xxx", user="xxx", password="xxx",
2009 Jan 19
1
[Win] Hangup RGui with RMySQL (PR#13453)
Full_Name: Apfel Schmied
Version: 2.8.1 (2008-12-22)
OS: WinXP SP2
Submission from: (NULL) (134.106.122.139)
RMySQL Version: 0.7-2
DBI Version: 0.2-4
MySQL Version: 5.1.30 (Enviroment Variable MYSQL_HOME is set)
Updated R from 2.60 to 2.8.1. Now Gui.exe hangs up (100% CPU Useage) when
requesting data from a mysql database.
Example Code:
2007 Mar 20
1
RMySQL load error
I'm having trouble getting RMySQL to load. I was able to build it and install
it (RMySQL_0.5-11.tar.gz). I was also able to build and install mysql-5.0.37.
I've read many postings about this but have not found a mention of my
particular problem (some closely related). I get the "unable to load shared
library, no such file" error, but all the files do exist, RMySQL.so and
2003 May 14
2
abrupt end to R
Dear All,
I haven't seen any further comments about the problem that John Marsland
first noted and that I also have:
> library(DBI)
> library(RMySQL)
Warning message:
DLL attempted to change FPU control word from 8001f to 9001f
> mgr <- dbDriver("MySQL")
> con <- dbConnect(mgr, host="localhost", dbname="marketing")
upon which R dies...