similar to: ODB : connecting OpenOffice Base with R

Dear all I am trying to use the ODB package to connect to an libreoffice-odb database. The libreoffice package is german, thus, decimal separator is a comma. However, I can open the database and upload a it without error, library(ODB) db <- odb.open("Test.odb") but a soon as the "odb.open" command is executed, the decimal separator in R is changed to comma. Before

(I am not sure if this is a bug or a request for a more understandable warning, or possible something obvious I should be posting on r-help.) I am trying to coerce an new class object to be a DBIConnection and it does not work the way I think it should: R version 2.5.1 (2007-06-27) ... > require("RMySQL") # or require("RSQLite") Loading required package: RMySQL Loading

Under Windows, I have used RODBC to connect to Excel spreadsheets as per the example below: library(RODBC); connect = odbcConnectExcel("testdata.xls"); query = "SELECT [data$.ethn], [data$.sex], [data$.age], [data$.height], [data$.weight], [label$.label] FROM [data$], [label$] WHERE [data$.ethn] = [label$.ethn];" data =

Hi All, Can anyone help me please?I don't know much about segmentation faults.I understand what it is,but why my script's throwing the error i don't know. This is my main function:---- *main<-function()* *{* * dbName<-"xyz_database"* * hostName<-"xyz.com"* * con<-myDbconnect(dbName,hostName) * *

Hi, I'm trying to use R's DBI interface but it appears to be broken. I am using R 1.8.0 on Linux, and have just installed DBI 0.1-6 through the command 'install.packages("DBI")'. Installation went fine, but now when I try to do a simple dbConnect(), it won't do anything besides complaining about an internal error: > library(DBI) > dbConnect(anything) Error

Hi All, Sorry to bother everyone again.Ofcourse Prof Ripley ,Yihui and Uwe had replied to my email.But this segmentation fault error was not solved.I agree with Prof Ripley,as he said my R and all other configurations,are very old.But what i don't understand is ,i was able to run analysis till few days before,and why suddenly this error. *The configuartions i use:---* *R-version * *>

Hi everyone, I tried sending a message as a reply a while back on my previous topic, but it didn't go through. (Tried Gmane), not even when I 'authorized' the reply. So I'll just paste it here for reference, below this message. It might help some people. But now I have one other small problem, and I'm not sure if it is actually my mistake (although I'm pretty sure it is

Hi all, For the R package bujar, the warnings below were generated on CRAN's Windows systems. The package uses some Fortran subroutines. I would appreciate any advice to eliminate the warnings. By the way, similar warnings were generated to some unrelated R packages as well: https://www.r-project.org/nosvn/R.check/r-oldrel-windows-ix86+x86_64/imputeTS-00check.html. Thanks in advance. Zhu

1. I have used gdata::read.xls() with much happiness. But every now and then it breaks. I have not, as yet, been able to construct a mental model about the class of .xls files for which it works. Does someone have a simple rule for predicting the circumstances under which it will work? 2. Just like there is a read.xls(), it'd be great if we have a read.ods() which directly

Hello, since a few days the computer in a branch office the computer take five and more minutes to load the user profile. In the user's samba log I found many lines of the type: [2011/08/17 12:36:09, 0] smbd/service.c:1188(make_connection) tonon-pc11 (::ffff:192.168.10.11) couldn't find service odb$ We don't have a service ODB defined on our samba server and never had. Is

Hi, I have installed OpenOffice 3.1 downloaded from the openoffice.org website on CentOS 5.4 x86_64. The downloaded file is actually an archive containing RPMs. I did not use their setup tool but installed directly the RPMs I was interested in via 'yum localinstall' (my idea is in the future to put them on a custom yum repository, so that they can be managed via regular yum install /

Hi R users, I'm a quite extensive user of the heatmap() function, and as many others i'm frequently frustrated by its fixed square width / height ratio. Here is a typical example : dev.new() heatmap(matrix(rnorm(1200), nrow=10)) I have a non square matrix to plot with heatmap, as there are many more columns than rows, row labels are larger than necessary but column labels

Hi, i have R on ubuntu64 i got ROracle database connection issues as seen below at a loss do to what next > library(ROracle) Loading required package: DBI > m <- dbDriver("Oracle") > con <- dbConnect(m, username="EPICEDF", password="ps39000b", dbname="EPICD2007", address="10.1.16.40") Error in oraNewConnection(drv, ...) : unused

Guys, I am getting lock error box in Officer 2007 and windows 7. It shows the somebody is using this file, but I am sure that is not. That problem always happens when open 2 files in the same folder. Take a look my lock configuration: kernel oplocks = No kernel oplocks = False locking = Yes oplocks = No level2 oplocks = No oplocks = False

CentOS Errata and Security Advisory CESA-2011:0181 openoffice.org and openoffice.org2 security update for CentOS 4 i386: https://rhn.redhat.com/errata/RHSA-2011-0181.html The following updated file has been uploaded and is currently syncing to the mirrors: i386: updates/i386/RPMS/openoffice.org-1.1.5-10.7.el4_8.10.i386.rpm updates/i386/RPMS/openoffice.org2-base-2.0.4-5.7.0.6.1.el4_8.8.i386.rpm

CentOS Errata and Security Advisory CESA-2011:0181 openoffice.org and openoffice.org2 security update for CentOS 4 x86_64: https://rhn.redhat.com/errata/RHSA-2011-0181.html The following updated file has been uploaded and is currently syncing to the mirrors: x86_64: updates/x86_64/RPMS/openoffice.org-1.1.5-10.7.el4_8.10.i386.rpm

All, There is a bug in OpenOffice.org in version openoffice.org-1.1.0-15.EL where the help file doesn't open if you select help. Here is the bug and the fix: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=122263 Basically, edit the file /usr/bin/ooffice and find <value>'$lang'</value> then replace it with <value>$lang</value>. I have tested this on

Hi everyone, I recently ran into an issue where my puppetmaster can''t run puppet on itself. It errors out with the following: Error: Could not retrieve catalog from remote server: execution expired Warning: Not using cache on failed catalog Error: Could not retrieve catalog; skipping run I''m running Puppet 3 with passanger and puppetdb (hsql). I''ve tried restarting

CentOS Errata and Security Advisory 2008:0175 https://rhn.redhat.com/errata/RHSA-2008-0175.html The following updated files have been uploaded and are currently syncing to the mirrors: i386: openoffice.org2-base-2.0.4-5.7.0.4.0.i386.rpm openoffice.org2-calc-2.0.4-5.7.0.4.0.i386.rpm openoffice.org2-core-2.0.4-5.7.0.4.0.i386.rpm openoffice.org2-draw-2.0.4-5.7.0.4.0.i386.rpm

CentOS Errata and Security Advisory 2008:0537 https://rhn.redhat.com/errata/RHSA-2008-0537.html The following updated files have been uploaded and are currently syncing to the mirrors: i386: openoffice.org2-base-2.0.4-5.7.0.5.0.i386.rpm openoffice.org2-calc-2.0.4-5.7.0.5.0.i386.rpm openoffice.org2-core-2.0.4-5.7.0.5.0.i386.rpm openoffice.org2-draw-2.0.4-5.7.0.5.0.i386.rpm