similar to: Facing error in loading dababase table

Hi Abbas, Before I try to give you answers, I just want to mention that you should send R related reqests to the R-help list, and not me personally because (i) there's a greater likelihood that it will get answered in a timely manner, and (ii) people who might have a similar problem down the road might benefit from any answer via searching the list archives ... anyway: On Sep 5, 2009, at

Hello Experts, how can I use variables in the RODBC environment. Example which does not work: Thanks for your help. Thorsten pn <- '39R5238'; library(RODBC); odbcobj <- odbcConnect("SQUIT21C",uid="muehge",pwd="xxx"); sql <- "select u.unitid, from test where part in ('pn') "; parameter <- sqlQuery(odbcobj,sql);

Hi, I've written some code that fetches data from an Access Database (2003), processes the data, then saves the modified data back into a table in the Access database. It works if I only pass through the code once, but if I put a loop around the code so that I fetch data from a different source table, and then save it again to a different destination table, the code crashes. It is

Dear all, platform i386-pc-mingw32 arch x86 os Win32 system x86, Win32 status major 1 minor 2.3 year 2001 month 04 day 26 language R I wrote the following to import tables in different database formats (Access, Visual FoxPro, etc.): getTable <-

Hi, all. I'm new to R. I've been a SAS programmer for 20 years. I seem to be having trouble with the most basic task - bringing a table in an *.RData file into a data.frame object. Here's how I created the *.RData file. library(RODBC) db <- odbcConnect("*******") df <- sqlQuery( db , "select * from schema.table where year(someDate)=2006" ) save(

Hi, I am trying to query a Sybase database on my new windows 7 machine. I am using native sybase driver "Adaptive server Enterprise" following is example code conn <- sprintf("driver=Adaptive server Enterprise;server=PHKSESMD01;database=smd_live;uid=temp_user;password=temp_pass;port=2301") chan <- odbcDriverConnect(conn) x <- sqlQuery(chan,sql,as.is=as.is)

I am having a problem with RODBC's connections. It appears that my connection to the database is closed by R automatically before I am done with it. Here is my code: foo <- function(dsn) { db <- odbcConnect(dsn) odbcSetAutoCommit(db, FALSE) data <- someDatabaseOperation(db) data2 <- someLongCalculation(data) anotherDatabaseOperation(db, data2) # This often fails b/c the

I have some questions about the RODBC package. library(RODBC) # required for those who want to repeat these lines 1st, I noticed that the following sequence does not work: channel <- odbcConnextExcel("test.xls") tables <- sqlTables(channel) name1 <- tables[1, "TABLE_NAME"] # this should be the name plan1 <- sqlFetch(channel, name1) # bang!

Hi R-Users, I have very recently switched from using R on windows 2000 to windows XP Professional. With XP I am having problems using the "odbcConnect("")" command. I can use the command perfectly well until I close the database channel with the command "odbcClose(channel)". When I try and re-establish connection following the close command no dialog box appears

Dear R Users, I have developed the following code for importing a series of zipped CSV by parallel computing. My problems are that: A) Some ZIP Files (Which contain CSVs inside) are corrupted, and cannot be opened. B) After executing parRapply I can only see the last.warning variable error, for knowing which CSV have failed in each node, but I cannot see all warnings, only 1 at a time. So: *

Dear R-experts, I have got an excel file as attached. I imported it successful with the commands: library(RODBC) channel <- odbcConnectExcel("data2.xls") tables <- sqlTables(channel) # list the names of the spreadsheets name1 <- tables[1, "TABLE_NAME"] # get the name of the 1st spreadsheet plan1 <- sqlQuery(channel, sprintf("select * from [%s]",

I tried to add the databases from the localhost to the database server and changed the every /etc/asterisk/*.conf from host=localhost to host=192.168.10.10 (my dababase server) When I restart asterisk, I do not get any errors, but after a phone call I see: Jun 7 18:11:56 ERROR[7877]: cdr_addon_mysql.c:400 my_load_module: Failed to connect to mysql database cdr on 192.168.10.10 Or if I try

Hi everyone, In relation to the RODBC odbcClose bug which was fixed back in the changelog below: Version: 1.2-3 (2008-01-24, released) * Plug a memory leak in inRODBCClose (closing a connection), reported by Stephan Henne. * Use translateChar() on character data sent in. Background: I am running some data from a SQL Server database, through unixODBC (freetds) into R via the RODBC

Hello! Can I use DBM databases (as they are used in Perl) for the import of large datasets in R? Thanks in advance for your help, Petra Steiner - --------------------------------------------------- Petra Steiner Arbeitsbereich Linguistik Universitaet Muenster Huefferstrasse 27 48149 Muenster

Hello All, I get the following error when i run the following script in Rgui Rgui.exe - Application Error The instruction at "0x7c9109f9" referenced memory at "0xffffffff". The memory could not be "read" Click on OK to terminate the program The script is library(RODBC) channel <- odbcConnect("curve", uid="curve", pwd="curve")

I have several hundred Excel 2007 data files in a folder. I would like to read every file in a single given folder using a loop. I have searched the FAQ, the forum archives here, other or older R boards and the R Import / Export documentation, and have asked some very knowledgeable R users without learning of a solution. I hope someone here can help. I understand that the most common

Hello... After installing the precompiled version of R 2.1.0 (congratulations to the R Development Core Team) for Windows XP (Service Pack 2), I'm having problems with the "odbcCloseAll" and "odbcClose" functions within the "RODBC" package. I get pretty much the same error message for both functions: odbcCloseAll() produces: Error in

Hi, I have a growing voip business Im i looking a solution that can handle at least 3000-4000 concurrent calls with great performance. Also with a billing platform, reports, reseller platform, LCR, call routing,real time reports, SQL dababase access real time Load Reports. Any recommendation? Thanks Ignacio -------------- next part -------------- An HTML attachment was scrubbed... URL:

You could construct your SQL statement as a character string using paste() and pass this as an argument to sqlQuery. Maybe something like this will work for you: >data1<-2.5 >sql.statement <- paste("SELECT * FROM somewhere WHERE something=", data1, ";", sep="") >library(RODBC) >channel <- odbcConnect(...) >sqlQuery(channel, query =

Hi, I have a matrix with column names starting with a character in [0-9]. After some matrix operations (e.g. copy to another matrix), R seems to add a character 'X' in front of the column name. Is this a normal default behaviour of R? Why has it got this behaviour? Can it be changed? What would be the side effect? Thank you. Regards, Gilbert [[alternative HTML version deleted]]