similar to: Connecting R with MS SQL server 2005

i am unable to open a file which is saved as .xlsx format in R . The file contains approximately 1,50,000 rows. So I m not able to save it as csv file.Please suggest ways to open this file -- View this message in context: http://n4.nabble.com/how-to-open-excel-2007-xlsx-file-in-R-tp1017273p1017273.html Sent from the R help mailing list archive at Nabble.com.

Can I save R graphs as a R objects ? IF yes then if I click this R object can I edit my chart as in Excel. Please suggest your views -- View this message in context: http://n4.nabble.com/Can-I-save-R-graphs-as-a-R-objects-tp1014621p1014621.html Sent from the R help mailing list archive at Nabble.com.

Dear All, I want to connnect R with oracle. I am using RODBC package for this connection. Following is my code to connect library(RODBC) channel <- odbcConnect("Vikrant") I am getting following error. 1: In odbcDriverConnect("DSN=Vikrant") : [RODBC] ERROR: state NA000, code 12288, message [Microsoft][ODBC driver for Oracle][Oracle]ORA-12514: TNS:listener does not

Suppose I am reading data from a file and the data contains some outliers. I want to know if it is possible in R to automatically detect outliers in a dataset and remove them -- View this message in context: http://n4.nabble.com/How-to-detect-and-exclude-outliers-in-R-tp1017285p1017285.html Sent from the R help mailing list archive at Nabble.com.

Hi all, I am trying to plot a bar chart and trying to plot a line as a secondary axis as my scale is different for two y axis. I am plotting a clustered bar chart by using besides = True option in barplot function and my y coordinates are not plotted exactly at the center on each two bars. Please help me. I am pasting the code as follows. x =

I have a question for RODBC users out there. I have used the package with good results for some time. However, I have just switched from an OpenLink proprietary driver for MS SQL to the FreeTDS driver (I think it is MS SQL Server 2000 I'm connecting to if it matters). I was/am running them from unixODBC on a Linux Client. I think I have it set up fine since I can use "isql"

Dear R Experts, I have written a following function :- myfunction<- function(servername,dbname,dbtablename){ library(RODBC) channel <- odbcDriverConnect("driver=SQL Server;server=servername") initdata<- sqlQuery(channel,paste("select * from dbname .. dbtablename")) return(dim(initdata)) } I have written this function which has input parameters like servername

I am using R2.6.0 on “Windows Small Business Server 2003”. I apologize if the answer to my question is available…I have searched but have not found anything that I thought helped me. I have a dataframe that contains ~4.5 million rows and 5 columns. (see memory and df details below). I am trying to save the dataframe to a MS SQL Server database, using the “sqlSave” function. The code

Hello All, I am using virDomainSetBlockIoTune() API to set the IO tune parameter for a running guest VM. I observed that after setting the value succesfully i ned to Shutdown and start the VM inorder to take the set value in effect. Is there any way with which these values come in effect in the same session of the VM without Shutting down and starting the VM. Please help regards, Vikrant

I'm trying to pull data from multiple MS SQL Sever databse in R. I can access the databases one at a time, but the tables are to large to pull the entire tables then join then in R. So I need to do a SQL join that will join the tables from the each of the databases. How do I combine the connection so that I can implement it in my sql query below. I'm currently getting the following error:

On 27.05.2013 12:36, vikrant verma wrote: > Hello Michal, > > I am using the following code - > > virDomainSetInterfaceParameters(dom, "vnet0", networkParainfoPtr, > nparams,0); > > before calling this i am assigning the following Inbound values > > inbound.average = 10 (10 kbps) > inbound .peak = 10 > inbound.burst = 10 I suspect this way too

Hi, I want to disable textbox in my page so that user can not modify its contents. How can we do that in ruby? Thanx, Prash -- Posted via http://www.ruby-forum.com/.

Hi, I want to estimate parameters of weibull distribution. For this, I am using fitdistr() function in MASS package.But when I give fitdistr(c,"weibull") I get a Error as follows:- Error in optim(x = c(4L, 41L, 20L, 6L, 12L, 6L, 7L, 13L, 2L, 8L, 22L, : non-finite value supplied by optim Any help or suggestions are most welcomed -- View this message in context:

Hi All, I am setting the value for "read_bytes_sec" using the following API code virDomainSetBlockIoTune(dom, "/mnt/tmpsdb/FileVM1", parainfoPtr, nparams, 2); I am succesfully able to set this value and i can read it back using the API virDomainGetBlockIoTune(dom,"/mnt/tmpsdb/FileVM1",parainfoPtr,&nparams,2); But after setting this value when i shutdown

On 31.05.2013 07:05, vikrant verma wrote: > Hello Michal, > > Throttling is working now after setting inbound.average = 10 (i have > set other values to 0 ) > But i am observing an inconsistent behavior in the observed throttling > bandwidth > > when i set inbound.average = 10 , i observed bandwidth of 24 kbps > when i set inbound.average = 100 , i observed

I want to call R functions from Java. I read a couple of forums that said to install package rJava in R. However I am not able to install rJava package in linux Ubuntu.I tried with two commands. One is install.packages("rJava") and another I downloaded the rJava_0.7-0.tar.gz file from R site. and gave the command R CMD INSTALL rJava_0.7-0.tar.gz. I got the followin Errors :- Warning

Hi Everyone, I hope I get some feedback on my question. Here it goes. I have a situation here, I have a company table and then using Single Table inheritance it is of 3 types: class Company < ActiveRecord::Base end class Vendor < Company end class Customer < Company end class Agent < Company end Now I have a active record Association class QuoteSheet < ActiveRecord::Base

Hi,From within an action called manager within a controller called storedorders, I want to render to the view for the manger action of controller orders. It really seems like the following syntax should work: (within the StoredordersController manager method...) respond_to do |format| format.html {render :controller => ''orders'', :action =>

Olivier Collignon wrote: > I have been doing data analysis/modeling in R, connecting to SQL databases > with RODBC (winXP client with R1.9.0 and win2k SQL server 2000). > > I am now trying to leverage some of the OLAP features to keep the data > intensive tasks on the DB server side and only keep the analytical tasks > within R (optimize use of memory). Is there any package

Hello Everyone,   I'm still quite new to R and am having trouble reading SQL Server Tables using RODBC. I've looked though the RODBC documentation as well as material I found online and in the book "Data Manipulation with R," but I just can't quite seem to get things to work.   Right now, I have code that looks something like:   channel <- odbcDriverConnect