Displaying 20 results from an estimated 1000 matches similar to: "RMySQL dbConnect"
2003 Nov 11
0
Installing and Loading RMySQL on OS X 2.8
Hello,
I have trouble installing and loading the RMySQL package on OS X 2.8.
The package seems to install from source fine (using R package manager
from within the R environment). I have the following error when I try
to load the package:
loading package: RMySQL
Error in dyn.load(x, as.logical(local), as.logical(now)) :
unable to load shared library
2005 Mar 09
1
RMySQL installed but not availalable
I don't use MySQL but I have seen messages like this before. They often have replies which indicate that you need to follow the instructions more closely. I suggest you search the list for these previous posts as I'm sure there is help there, somewhere!
Tom
> -----Original Message-----
> From: Adriano von Sydow [mailto:pdasilva at xtra.co.nz]
> Sent: Thursday, 10 March 2005 5:13
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
2006 Nov 13
0
segfault in RMySQL dbConnect error handling
Hi there. I see in a post from 2002 that you got the following
problem with RMySQL:
> con <- dbConnect(m)
Process R segmentation fault at Wed Aug 28 08:21:11 2002
I have the same problem today:
drv=dbDriver("MySQL")
dbConnect(drv) # or with pretty much any other failing options
Program received signal SIGSEGV, Segmentation fault.
0x00002b28d60c9fa0 in strlen () from
2012 Aug 09
0
RMySQL dbConnect issues
Hello,
I have access to my database via command line and through workbench, and
have access on the grant tables:
mysql> SELECT host,user,password,select_priv,insert_priv FROM user;
+------+-------+-------------------------------------------+-------------+-------------+
| host | user | password | select_priv
| insert_priv |
2003 Nov 24
0
Re: [RMySQL] unable to establish connection since R-1.8.0 upgrade
Hi Laurent,
The issue is a very simple one to correct --- you only need to
re-install RMySQL with the R version you're currently using.
The issue is that the internal representation of objects in the
methods package changed in 1.8.0, and thus packages that use S4
classes and methods and save their images (like RMySQL) and were
installed prior to 1.8.0 need to be re-installed to be used with
2006 Oct 16
3
Install RMySQL with R 2.4.0
I just installed RMySQL 0.5-9 with R 2.4.0 on Windows XP and got the
following error message when trying to run a script with RMySQL:
Error in library(RMySQL) : 'RMySQL' is not a valid package -- installed
< 2.0.0?
Any ideas?
Thanks,
Frank
2007 Mar 21
2
RMySQL *was* working...
List,
Last week with the help of Uwe and some other folks I was able to get RMySQL 0.5-7 compiled against R 2.4.1 and MySQL 5.0.27. It was working fine--I was able to send select queries to the db, put the results in a data frame, and so forth.
Today, dbDriver() threw an error:
> dbDriver(MySQL)
Error in function (classes, fdef, mtable) :
unable to find an inherited method for
2009 Feb 18
1
Possible Cause of Segmentation Fault
Hi All,
If you have already finished reading my previous emails regarding
segmentation fault , please have a look at this .I think this may help you
to diagnose the reason for the segmentation fault and help me,because i
don't understand much.
Rather than running the script using the command "
source("new_regression.R") ", what I did was ,simply typed in the commands
in
2007 Dec 21
0
RMySQL installation
Hi,
I am having trouble getting RMySQL running on a solaris machine.
[43] bedrock:/home/jayoung/source_codes/R/other_packages> uname -a
SunOS bedrock 5.10 Generic_118833-36 sun4v sparc SUNW,Sun-Fire-T200
I thought I had finally managed to get it installed, albeit with some
warnings that I didn't understand (it took me a while to find where
our mysql libraries were), but when I tried
2016 Mar 15
2
Rsqlite
Estimados
Anteriormente usé sin problemas Rsqlite, pero encuentro un error, comparto el código ¿alguno tiene idea sobre que puede llegar a ser?
library(RSQLite)
con <- dbConnect('SQLite', dbname='/Users/Javier_2/Desktop/SQLiteJavier.db')
// o ? en lugar de ? , el error persiste
> con <- dbConnect("SQLite",
2006 Jun 27
2
RMySQL...Can't initialize driver???
Dear R users,
I would like to query a MySQL database through R. I have installed
the latest required packages (RMySQL and DBI) in R (v2.3.1). A MySQL
server (v5.0.22) is running on my local machine but I can't initialize MYSQL
driver:
------------------------------------------------------------------------------------
> library("RMySQL")
Loading required package: DBI
>
2008 Aug 15
1
dbConnect
Hi everybody,
I'm having a problem with connecting to my MySQL database.
Each time I try to connect
library(RMySQL)
m <- dbDriver("MySQL")
con <- dbConnect (m, host="my_host",username="my_username",
password="my_password", dbname="name_of_db")
it says
Fehler in mysqlNewConnection(drv, ...) :
RS-DBI driver: (could not connect
2007 Nov 11
5
Multivariate time series
Hello to everyone!
I have a question for you..I need to predict multivariate time series, for
example sales of 2 products related one to the other, having the 2 prices
like inputs..
Is there in R a function to do it? I saw dse package but I didn't find what
a I'm looking for..
Could anyone help me?
Thank you very much
Giusy
--
View this message in context:
2008 Apr 23
2
ROracle error at step 1
Hi
I Can't connect to the Oracle database, any tips? Has anybody actually
got ROracle up and running on windows?
>> unable to find an inherited method for function "dbConnect",
for signature "OraDriver"
I can happily connect to the same database through RODBC. Oracle client,
version 9.2 installed, amongst others.
Sean
> library(DBI)
> library(ROracle)
2008 May 01
3
Error in building ROracle in Windows with R 2.6.2 and Oracle 10g.
Hi,
I need to use ROracle to communicate with Oracle from R program in windows
environment. I am using Oracle 10g, R 2.6.2. I found a pre-compiled binary
for ROracle for Oracle version 9.2. When I am trying to use it with Oracle
10g I get the following error:
con <- dbConnect(drv, "user/passwd at dbname");
Error in function (classes, fdef, mtable) :
unable to find an inherited
2008 Oct 08
0
Applying an R script to data within MySQL? How to?
I am trying something I haven't attempted before and the available
documentation doesn't quite answer my questions (at least in a way I can
understand). My usual course of action would be to extract my data from my
DB, do whatever manipulation is necessary, either manually or using a C++
program, and then import the data into R. Now I need to try to do it all
within R+RMySQL+MySQL.
I
2002 Aug 28
0
segfault in RMySQL
Hi all,
I have experimented a segmentation fault error using
RMySQL_0.4-6 library in R 1.5.1.
Look the sequence:
-------------------------------------------
> library(RMySQL)
> m <- dbManager("MySQL")
> m
<MySQLManager:(1137)>
> describe(m)
<MySQLManager:(1137)>
Driver name: MySQL
Max connections: 10
Conn. processed: 0
Default records per
2007 Dec 14
2
connecting RMySQL to and external server
Dear list,
I learned how to connect R to a local MySQL server, using:
drv <- dbDriver("MySQL")
con <- dbConnect(drv, user="root", password="mypass", dbname="mydb")
Is it possible to connect R in this way to an external server (on a different
machine, with a different IP)?
I read the documentation on ?dbConnect (and everything I could find on the
2003 Apr 24
1
RMySQL
Dear laurent,
> This is what I did to make the connection :
> > drv <- dbDriver("MySQL")
> > con <- dbConnect(drv)
Here's the error.
You should give the database name.
drv <-dbConnect(drv, dbname="dfghdfgsdfgsdfgsdfgsdfgsdfgsdf")
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> Then I should be able to send requests. But when I