similar to: R connectivity to database

Hi All, Can anyone please suggest me from where should I start to learn about 'how to connect to access db' ? How if someone has some written code and I can go over that to understand and make necessary changes... any help would be highly appreciated, -- Xin Ge. [[alternative HTML version deleted]]

Hi all R-Experts, I'm facing one problem in yahoo data downloading. I'm suing Windows XP, R 2.2.0, and i'm using yahoo.get.hist.quote function to download data. I need 500 companies of S&P index daily 'closing price' data for last ten years. My questions are: 1) I have all the ticker names of S&P 500 companies in a .csv format. I'm reading those names in R and

Dear R-list, I am trying to import (all) frames from a Microsoft Access database as individual data frames in a fancy loop, but I'm having troubles figuring out how to use the 'sqlFetch' from the RODBS package in a loop (mostly because I can't figure out how to loop over elements (I came from stata) I would very much appreciate if anyone on the list could help me solve this

Hi, I want to import some data from Access and I am using the following codes: testdb <- file.path("c/../db1") channel <- odbcConnect("testdb") sqlFetch(channel,"tbl",colnames = TRUE, rownames = FALSE) It comes out the error message: 1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default

Hello, I've got a problem with a PHP script, in which I call the system function (to call another processes). The call is : system("R --slave --vanilla < path/to/source/source.R"); if in this R file, I've got the lines: pdf(file="/path/to/file/file.pdf") commands dev.off() the pdf file is perfectly created but if I change the lines to:

Does anyone out there have experience running RedHat 5.2 with Samba on a Dell PERC raid controller? I'm looking for more information. Thanks! John Rauch Clark Nuber, P.S.

I have just installed Samba for the following configuration: AIX 4.2, with NT clients We are trying to print from clients to unix printers through a Progress (database) program. On unix, I would identify my destination as "lp -s -dprinter1". Now, I indicate "//rs6000/printer1". People in our systems department (and therefore, people with "root" privileges) can

'llo, It was suggested that I added "nt acl support = no" to my smb.conf file, in order to get rid of the "error packet at line 588 cmd=115 (SMBsesssetupX)eclass=2 ecode=2" error. (Apparently it has something to do with Word's temporary files that are created with mode 000 which stops it from completing a file save.) I added this to my smb.conf file

We run samba 2.0.3 and it works fine since several weeks, until these days... Since two days I get lots of problems with samba. Oplocks seems to cause troubles, and it crashes MS Word in such messages: "unrecoverable network error" indefinitely until Dr Watson (under NT). We run 2.0.3 with samba as PDC. Quite all the clients run NT 4.0. Here is the entry I encounter very often in the

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 List, I have a rather unique question, that perhaps can be answered easily here.I did search google and only came up with one app that does this exact thing; however, it's an expensive tool. Thusly, not my cup of tea. I have need to convert approximately 100 documents in Openoffice's native format to Microsoft Word's native format.

I'm running Samba 2.0.3 from the pre-built binary (ftp://sunsite.org.uk/packages/samba/Binary_Packages/solaris/samba-2.0.3 -sunos-4.1.3.tar.Z) on a Sun IPX with SunOS 4.1.3_U1. I've defined a printer in smb.conf, from a PC (NT 4.0) I can send prints to it and view the queue OK but I can't manage the queue in any way. Attempts to cancel prints and stop or start the queue from the PC

I've set up Samba and LPRng for HP printers with JetDirect cards. It works for one user at a time. But if the printer is off-line or busy, the samba client does not get an error message, but the job gets lost. :( I would like the print jobs to be spooled on Linux even when there is an active print job or when the printer is off-line. Unfortunately I'm not familiar with lpd. The

Hi guys, Yesterday I posted my first couple of questions (see bottom of this message) to this forum and I would like to thank you guys for all the useful feedback I got. I just would like to make some comments: 1. Exporting R graphs as vector graphics: The best answer came from Thomas Lumley <tlumley at u.washington.edu> He suggested using the RSvgDevice package. As far as I know SVG

Using forecast package. http://www-personal.buseco.monash.edu.au/~hyndman/Rlibrary/forecast/ Best Regards. Message: 50 Date: Thu, 18 May 2006 18:50:15 -0400 From: "Wensui Liu" <liuwensui en gmail.com> Subject: To: Michael <comtech.usa en gmail.com> Cc: R-help en stat.math.ethz.ch Message-ID: <1115a2b00605181550i1e718124p3ec01f4f70ed9f02 en mail.gmail.com>

Hi, I have been a happy user of R for windows for more than a year, however, recently, I started using linux as my operating system and now I have practically switched completely. Of course, I still use R with linux, however, certain nice features of R in windows seem to be missing or hidden. I need help in basically two points: 1. In windows, I could copy the contents of a window graphic's

Dear R-list, I'm queering a M$ Access database with the sqlQuery function from the RODBC library. As I cannot make a working example with a database here is an illustrative example, library(RODBC) mdbConnect<-odbcConnectAccess("S:/data/ ... /databse.mdb") data <- sqlQuery(mdbConnect, "select id, DOB, V1, V2, ..., V1009, V1011, V1013 from someTable") I want

In an OpenOffice.org forum someone asked if it was possible to plot some raw data and then add a line for the confidence interval. Example at? http://www.graphpad.com/help/Prism5/scatter%20-%20grouped.png While it may be possible to do this in OOo's spreadsheet program it looks nasty (both to do and the results ) I can do this in R but I'm not good enough that I can produce a fairly

Is there a utility that compares files word by word, instead of whole lines or single bytes? I found that I can simulate this by replacing all the spaces in a file with linefeeds, then 'diff -B' the results, but that's kind of awkward and hard to read when differences that matter come up. (For the record, I tried using OOo's document comparer, converting to text and using diff,

Hi All, A group of about 3-4 of us are looking into the possibility of incorporating R into OpenOffice's (OO) spreadsheet component (sc) . We wish to use OO's nice ODBC ability to query a postgresql-based gene expression database thus populating an OO sc and then use Bioconductor via R to analyse user-selected parts of this spreadsheet. We've looked at and compiled and used

How do i unsubscribe??