similar to: rodbc error

Hi list, Is there a way to use sqlQuery function where there is a sql file (ie. sample.sql)? I just want to mention that in my sql file there are some comment lines (starting with --). This means that if I paste all the lines in the sql file, I'll come up with a long string that most part of it is commneted (after commnet sign --). thanks Arvin [[alternative HTML version deleted]]

Hi List, Does any one know what package I need to use in order to fetch/get a large sized dataframe from SQL? I have already used sqldf package which is good for fetching large sized csv files. Thanks Alireza [[alternative HTML version deleted]]

Hi List, Does anybody know what function I need to use for a simple regression? Here is the data: I want to find the value for x1=3.5 data<-data.frame(x=c(1:30),Value=c(31:60)) x1<-3.5 Regards, Alireza [[alternative HTML version deleted]]

I am trying to plot some data, but have got some difficulties with labels on the tick marks on the x-axes. There are 20 data points. All I want to do is to plot the Loss versus Lines. When I use xyplot, the first tick mark starts from 2 rather than 1, and also there is a NA as the final tick mark. Here is the R code you code give it a try: Would any body be able to fix this, please?

Hi List, Would you please send me a good link to talk me through on how to write a R package? thanks Alireza [[alternative HTML version deleted]]

Hi list, I have a real problem with plotting US state map. When I try to plot the northern state, there will be some blank space in the top of graph (see case 1 example), and when I plot southern states, there will be a blank space in the bottom of plot (see case 2). I spent almost 2 days to figure out a solution, but could not. Would you help me if you know what the problem is? Regards, Alireza

Hi List, Is anybody aware of any R console available for Android mobile? I know that there is one for Iphone. thanks, Alireza [[alternative HTML version deleted]]

Hi list, Does anyone know the code behind rlnorm(n, meanlog = 0, sdlog = 1)? I am going to write it in c#. thanks Alireza [[alternative HTML version deleted]]

Hi List, If I have a date format as: d <- "2001/1/1" I can easily convert it to number by using as.Date(d). But if I have d<-"1/1/2001", it does not work. Does anyone know how I can convert it using pre-written function in R? Regards, Alireza [[alternative HTML version deleted]]

Hi list, Does any one know how I can make the red colour transparant? ######################### par() #Set up blank plot to remove plot border type lty="n" xvalue1<- c(1,2,2,1) xvalue2<- c(1,3,3,1) yvalue1<- c(0,0,22,22) yvalue2<- c(0,0,44,44)

Hi list, I want to plot state Texas using map function. I wrote the following code to plot the grid boundary for Texas: ################################ library(maps) require("mapproj") longlatLimit<-c(-106.65, -93.53 , 25.93 , 36.49) par(plt=c(0,1,0,1),cex=1,cex.main=1) #Set plotting parameters map(projection="azequalarea",

Hi list, When I type my question in R console using ? sign (example: ?par, when I want to query for par), the following error message popps up: Error in print.help_files_with_topic("C:/PROGRA~1/R/R-24~1.1/library/maps/chm/map") : CHM file could not be displayed I appreciate if any body comes back to me with the solution. Regards, Alireza [[alternative HTML version deleted]]

Hi list, Does any body know how I can create a margin area around the graphic created by xyplot (the same thing we do using par in plot function)? I tried viewport, but does not work. Here is the code: ============================================== require(grid) vp<- viewport(x=.1,y=.1,width=.6,height=.6,just=c("left", "bottom")) pushViewport(vp)

Hi list, I used to work with RExcel in excel 2003. Now in 2007, I tried the same RExcel, but it did not work. I got R version 12. I downloaded/installed the latest version of RExcel 3.2.0 from http://sunsite.univie.ac.at/rcom/. It has added the RExcel add-ins, but when I click on starting R in add-ins, I get the following sequentional errors: Errors: SCtools not available SCTools can not be

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

Hi, Please excuse these questions if they're obvious. I'm new to R. I need to access a Postgres db from R. I'm currently trying RODBC as I spend part of my time on Windows and rdbi.pgsql seems not to support windows at this time. I unzipped the RODBC win binary download into my library directory and tried to load it using library(RODBC) I get the following error: Error in

All- Does anyone on the list have experience with building RODBC from source on a Linux box for use with DB2? I am using (all from source): R 2.0.1 unixODBC 2.2.9 RODBC 1.1-3 For example: [jcole]$ R CMD INSTALL RODBC_1.1-3.tar.gz 2> rodbc.log * Installing *source* package 'RODBC' ... checking for gcc... gcc checking for C compiler default output file name... a.out checking whether

This is a common pitfall: people think that .text is the first section of the traditional concept "text segment" (which does not apply with LLD layout and GNU ld's -z separate-code layout) You need to use --image-base=0 https://releases.llvm.org/10.0.0/tools/lld/docs/ReleaseNotes.html#breaking-changes On Mon, Nov 16, 2020 at 10:31 AM Moshtaghi, Alireza <Alireza.Moshtaghi at

On Sun, May 27, 2012 at 11:32 AM, Michael <comtech.usa@gmail.com> wrote: > Help! The R Console very quietly closed and exited without giving any > errors/warnings...after I loaded the RODBC library... > > Loading required package: RODBC > > > > > On Sat, May 26, 2012 at 10:27 PM, Michael <comtech.usa@gmail.com> wrote: > >> Hi all, >> >>

If one attempts to install RODBC (via install.packages('RODBC')) without having an ODBC driver installed, this error message results: checking sqlext.h presence... no checking for sqlext.h... no configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package 'RODBC' * removing '/usr/lib/R/library/RODBC' Yes, the RODBC README