similar to: RODBC does not like table names >11/12 characters

I''ve been trying to get access to a userland string that''s behind a second level pointer using DTrace, but I can''t seem to get it to work. I started with the example on the Team DTrace Tips and Tricks slides: trace(copyinstr(*(uintptr_t *)copyin(arg0, curpsinfo->pr_dmodel == PR_MODEL_ILP32 ? 4 : 8))); And when I couldn''t get it to work, I started

Hi all, I am very new to R and I'm trying to import data from Microsoft Access. So far, I've managed to do so successfully using the following code: testdb <- file.path("c:\Databse.accdb") channel2 <- odbcConnectAccess2007(testdb) data.table <- sqlFetch(channel2,"data") This successfully imports a table(?) called "data.table". But when I try to

Dear R-community, I'm analysing some noise using the nlme-package. I'm writing in order to get my usage of lme verified. In practise, a number of samples have been processed by a machine measuring the same signal at four different channels. I want to model the noise. I have taken the noise (the signal is from position 1 to 3500, and after that there is only noise). My data looks like

Dear List, I have a problem with RODBC on a Paradox-DB, sqlQuery, and special characters in table names. Unfortunately, some of the latter include the underscore <_>. And I am not able to change them. That's not a problem, when I quote the table name: > sqlQuery(channel2, 'SELECT * FROM "anmeldung-alt"') Btw, if I swap ' and " it does not work: >

Hello r-devel, The attached Code page 437-encoded file contains 245 characters (including the final newline), but readLines only reads 242 of them: > test_text <- readLines(file('437__characters.txt', encoding='437')) Warning message: In readLines(file("437__characters.txt", : incomplete final line found on '437__characters.txt' > test_text [1]

Hello, I'm wondering how I can merge two featuresets into one. My dataset is two sets of microarray data and it looks like followings: > rawData $v1 TilingFeatureSet (storageMode: lockedEnvironment) assayData: 2197815 features, 59 samples element names: channel1, channel2 protocolData rowNames: LT290677RU_D1_2011-02-16 LT286300LU_D1_2010-07-24 ... LT003990RU_D1_2010-11-04 (59

Dear all (copying the package author), I have a question on the vlmc package. I am trying to model a time series, where each element can take one of 11 values (the result of some clustering). When I run the following command (synthetic data to facilitate self-contained example) I get the following warning: ("alphabet with >1-letter strings; trying to abbreviate") +++ START+++ >

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

can somebody that has these hardwares(X101P and S400P) working on his asterisk system please assist.................. you can send the solution to austino@skannet.com..... the error message is what i have below. ---------- Forwarded message ---------- Date: Thu, 1 May 2003 21:01:21 +0100 (WAT) From: austino@skannet.com To: asterisk-user@lists.digium.com Subject: Error working with X101P and

Hello, I've added a Channel Device through virt-manager GUI. virsh dumpxml shows the device as. <channel type='unix'> <source mode='bind' path='/var/lib/libvirt/qemu/channel/target/ubuntusaucy.marx'/> <target type='virtio' name='marx'/> <alias name='channel2'/> <address

Hi there, I have seen this post. https://stat.ethz.ch/pipermail/r-help/2007-June/133606.html have odbc installed in my machine. Now I have the following message: channel2 <- odbcDriverConnect("test.mdb")Warning messages:1: In odbcDriverConnect("test.mdb") : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no

Dear r-helpers! I have trouble reading data from an Oracle data base using RODBC Version 1.0-3, R Version 1.7.1, Windows XP, Oracle8 ODBC Driver Version 8.1.6.4.0: > library(RODBC) > channel <- odbcConnect(dsn="PAV32", case="oracle", believeNRows=FALSE) > # ok, this was succesful > x <- sqlTables(channel) > x[37, ] TABLE_CAT TABLE_SCHEM TABLE_NAME

Dear list - I am having a problem using RODBC to access records from tables in a PostgreSQL database. There is no problem establishing the connection using chnl <- odbcConnect (dsn= ... etc. The DSN seems to be properly set up using the PostgreSQL Unicode ODBC driver, and sqlTables(chnl) works OK and produces a list of tables in the database (they are all in a schema called 'source').

Your error message was >> d <- sqlFetch(channel, District) > Error in odbcTableExists(channel, sqtable) : > object "District" not found and as you had not defined an object 'District' in that session, it seems perfectly plain. If you want to refer to table "District" you have to give a character string (with quotes), not the name of an R

Greetings guRus -- I have successfully queried a large (24,445 rows by 281 cols.) in-house database using the following RODBC query (without the line breaks) testout <- sqlQuery(channel, "select idSchedule,EXCL_Total from dbo.vwC1198_2006_RawData_With_CMPL_EXCL") This returns a dataframe of 24445 rows and two columns (as intended), but the following command testout

All, I'm trying to connect to a remote SAS server using SAS's 9.1 ODBC driver and the RODBC package. I'm running R-2.6.1 on Win XP. I can successfully connect to the database, but no matter which table I query, I get back an empty table with only the column headers. For example: > sqlQuery(con, "select * from PRICES.DB_PRICES") [1] COMMOD_CURVE START_DATE

Hello, I'm using R 2.2.0 on a Mac and attempting to use the RODBC package to connect to a PostgreSQL server on the local network. I can't tell whether my problem is in R, or in ODBC setup. I got drivers from OpenLink, created a dsn and tested it using the iODBC application. then I load the RODBC package, use this code and get the following error. I tried with both the

Dear all, I'm trying to read to a collection of files in a loop using odbcConnectExcel - but not all of the files exist. This is the code I have for(i in 1:no.of.subs){ channel <- odbcConnectExcel(paste(working.dir, subs[i], ".xls", sep="")) datafiles[[i]] <- as.matrix(sqlFetch(channel, "Data")) close(channel) } I'm not sure how to

I am working on a script that takes numeric performance indicators and runs them against a series of regressors (dummy regressors, yes\no stuff via 0 and 1, e.g. Was is Christmas this week 0=no, 1=yes). The script is as follows (Written as a function): -- Begin Script -- doEnv <- function(HOUR,ENVNAME,REPORTNAME) { library(RODBC) library(forecast) library("geneplotter")

Full_Name: Michael Hecht Version: 1.7.1 OS: WinNT Submission from: (NULL) (193.158.76.205) I've got a problem with the RODBC library while trying to access to an MS-Excel file. The Excel file was originally exportet by a commercial software, so I cannot influence it. The problem is, that the names of the tables include spaces, e.g. "Scan 1","Scan 2" etc. If I use RODBC, I