Displaying 20 results from an estimated 100 matches similar to: ""[RODBC] ERROR: Could not SQLExecDirect""
2007 Jun 08
1
data mining/text mining?
Dear R-user,
Could anybody tell me of the key difference between data mining and text
mining?
Please make a list for packages about data/text mining.
And give me an example of text mining with R (any relating materials
will be highly appreciated), because a vignette written by Ingo Feinerer
seems too concise for me.
Thanks
_____________________________________________
Dr.Ruixin ZHU
Shanghai
2012 Feb 14
1
txtStart creates a NULL file
Hello all:
I'm trying to use the following code to get commands, comments and results to a .txt file. It only appears to capture comments. When I comment those out with #, it creates a NULL file.
Someone seemed to have a similar problem with a mac GUI (https://stat.ethz.ch/pipermail/r-help/2010-September/253177.html) but the result seemed to be ambiguous. Is there a work-around?
2007 Jun 08
1
Dependency 'Design' is not available
Dear R-users,
When I installed "rattle" package with the command:
install.packages("rattle", dependencies=TRUE), I got
Warning message:
Dependency 'Design' is not available
Is this warning serious? How to avoid this warning?
Thanks
_____________________________________________
Dr.Ruixin ZHU
Shanghai Center for Bioinformation Technology
rxzhu@scbit.org
2007 Jun 13
1
How to install RMySQL package in R 2.5 in Windows OS?
Dear R-users,
It seems that install.packages( ) doesn't work to RMySQL package.
Would anybody have the experience of that?
Thanks
_____________________________________________
Dr.Ruixin ZHU
Shanghai Center for Bioinformation Technology
rxzhu@scbit.org
zhurx@mail.sioc.ac.cn
86-21-13040647832
[[alternative HTML version deleted]]
2007 May 28
1
'trim' must be numeric of length one？
Hi everybody,
When I followed a practice example, I got an error as follows:
########################################################################
#######################################
> cc<-read.table('example5_2.dat',header=TRUE)
> cc
EXAM1 EXAM2 EXAM3 EXAM4 EXAM5
1 45 34 23 35 50
2 23 36 66 66 34
3 67 59 72 80 69
4 56
2012 Oct 25
1
How to quit R script & return to R prompt
Hi
can you please tell me how to quit R script & return to R prompt.
As i tried following but still cannot able to return on to R prompt..
R> barplot(Forbes2000$profits)
R> barplot(xtab(`profits,data=Forbes2000))
+ barplot(xtab(~profits,data=Forbes2000))
+ )
+ Q()
+ ?barplots
+
+
+
+
+ barplot?
+ ?
+ ??
+ ????
+ stop()
+ exit()
+
+
+ ctrl+c
+ q()
+
I'm beginner in R &
2008 Jan 20
2
Newbie question on subsets
Hi...
I'm working through the book, A Handbook of Statistical Analyses
using R by Everitt, and I'm trying to do the following (p. 19 of his
book):
boxplot(log(marketvalue)~country,
data = subset(Forbes2000,
country %in% c("United
Kingdom","Germany","India","Turkey")),
ylab="log(marketvalue",
2009 Sep 11
0
ipred bagging segfault on 64 bit linux build
I wanted to report this issue here so others may not find themselves alone
and as the author is apparently active on the list.
I havent done an exhaustive test by any means, cause I dont have time. But
here's a small example. Apparently the "ns" argument is the one that is
killing it. I've gotten several different segfault messages, the only other
one I remember said "out
2012 Sep 11
0
Question about logistic regression with ordered factor variable using the rms package (prev.Design)
Dear R users,
Hopefully someone can help me,
Maybe I just misunderstand the function in the package?
I am working with a logistic regression model.
Until now I always worked with the basic glm function, where for the model
was:
¡§ glm( disease ~ test.value + cnct , family=binomial(link=¡¦logit¡¦) ¡¨.
This works fine when test .value and concentration (cnct) are continuous
vairables.
However,
2006 Jul 25
1
[RODBC] ERROR: Could not SQLExecDirect
Hi,
I've got a problem with RODBC and saving (sqlSave) of a dataframe in Access.
R 2.0.1 is running on windows XP.
When executing the examples in R help for the "USArrests" data set "sqlSAve" works fine, but running sqlSave() for a dataframe "Adat"
> str(Adat)
`data.frame': 1202 obs. of 18 variables:
containing 18 columns and ca. 1200 rows fails.
2009 Jan 18
6
read a xls file
Hello,
i have a xls file. I will read it in r, what library-command i use for
this??
any ideas??
Thanks
Michele
[[alternative HTML version deleted]]
2008 Jan 31
7
Ajax.InPlaceEditor via PHP via prototype widows class = HELP :-)
my window comes up fine and builds a page from some PHP which is all
kosher. this is what the source of the "window" looks like:
-----------------------------------------------------------------------------------------------------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://
www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2017 Jun 01
0
Who's using OpenStack Cinder & Gluster? [ Was Re: [Gluster-devel] Fwd: Re: GlusterFS removal from Openstack Cinder]
Joe,
Agree with you on turning this around into something more positive.
One aspect that would really help us decide on our next steps here is the
actual number of deployments that will be affected by the removal of the
gluster driver in Cinder. If you are running or aware of a deployment of
OpenStack Cinder & Gluster, can you please respond on this thread or to me
& Niels in private
2009 Sep 24
2
RODBC problem
Hi,
I'm attempting to use the RODBC package on Windows Vista to import an
excel spreadsheet. The spreadsheet has three worksheets the last of
which is blank. Following an example in Phil Spector's book (p. 34),
after creating a connection named con I did the following:
> con
RODBC Connection 3
Details:
case=nochange
DBQ=c:\temp\test.xls
DefaultDir=c:\temp
2012 Jul 11
2
How to connect .mdb file
Hi, I'm currently having some problem connect .mdb file into R.
I've installed the RODBC packages and I do the code this way:
channel <- odbcConnectAccess("C:/Users/Documents/XYZ")
channel
and it gave me this :
RODBC Connection 3
Details:
case=nochange
DBQ=C:\USers\JieYi\Documents\NYP\IPP\GCR
Driver={Microsoft Access Driver (*.mdb)}
DriverId=25
FIL=MS Access
2010 Jun 16
2
Reading data from xls..........please help
Can anyone help me how to read xls file into R. I have tried following
library(gdata)
xlsfile <- file.path(.path.package('gdata'),'xls','iris.xls')
read.xls(xlsfile)
I got following error:
Converting xls file to csv file... Error in system(cmd, intern = !verbose) :
perl not found
Error in file.exists(tfn) : invalid 'file' argument
Question *1) What is the way
2007 Mar 13
2
RODBC Excel sqlQuery insert into
I have searched the archives for using insert into to update spreadsheets
using RODBC and have come up short. So, first off, is it possible?
I have put together a dummy xls table (c:\foo.xls)for exploring
possibilities of RODBC. Ultimately, I am interested in replacing much of
our previous use of vba macros with R ( I'd prefer elimination, but will
take what I can get ). In order to
2007 Jul 17
4
[R-sig-DB] RODBC on Oracle DB
essai <- odbcConnect("ORESTE_prod", uid="osis_r", pwd="12miss15" ,case="oracle")
> sqlTables(essai)$ORESTE
...
1315 <NA> ORESTE S_PROFESSIONS_OLD TABLE <NA>
1316 <NA> ORESTE S_PROVENANCES TABLE <NA>
1317 <NA> ORESTE
2013 Oct 14
1
realtime voicemail asterisk 11
Hi list, I'm trying to put my voicemail on asterisk realtime with 11.XX,
generate tables in a couple of files in the folder realtime / mysql ,
voicemail_messages.sql and voicemail.sql
the connection with mysql and odbc works well
isql asterisk useradmin xxx
+---------------------------------------+
| Connected! |
| |
|
2009 May 21
1
Error in importing table from SQL to R
Hi Friends,
I am trying to import a table from SQL server to R(2.9.0), however i am
getting errors while running the below codes. Can anyone identify and let me
know where did i go wrong??? Thanks in anticipation :)
library(RODBC)
myconn <- odbcConnect("RDATABASE")
myconn
RODB Connection 6
Details:
case=nochange
DSN=RDATABASE
Description=Database for R
UID=Madana_Babu