search for: odbcupdate

Displaying 9 results from an estimated 9 matches for "odbcupdate".

2007 Nov 24
2
truncated fields with RODBC
I'm changing some functions from storing data in SQLite (using RSQLite) to storing it in PostgreSQL (using RODBC). When trying to store very long character fields I get the following message: > sqlSave(pg, Grids, rownames = FALSE, append = TRUE) Warning messages: 1: In odbcUpdate(channel, query, mydata, paramdata, test = test, verbose = verbose, : character data truncated in column 'grids' 2: In odbcUpdate(channel, query, mydata, paramdata, test = test, verbose = verbose, : character data truncated in column 'grids' 3: In odbcUpdate(channel, query, myd...
2010 May 20
0
RODBC: sqlSave leave primary key and other columns null
...nd additional rows to this database. I omit the primary key, which is a uniqueidentifier type (MS SQL), so that the database can populate that field. However, I get the following error: > sqlSave( ch, result, tablename=thetablename, append=TRUE, rownames=FALSE, colnames=FALSE ) Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, : missing columns in 'data' Enter a frame number, or 0 to exit 1: sqlSave(ch, result, tablename = "CreditLadderData", append = TRUE, rownames 2: sqlwrite(channel, tablename, dat, verbose = verbose, fast = fast, test = te...
2013 Sep 19
1
Vignette problem and CRAN policies
...following Perl modules were not found on this system: Text::CSV_XS If you have more than one Perl installation, be sure the correct one was used he re. Otherwise, please install the missing modules. See the package INSTALL file for more information. Loading required package: RODBC Warning in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, : character data 'Adrian Baddeley <Adrian.Baddeley at uwa.edu.au> and Rolf Turner <r.turner at auckland.ac.nz> with substantial contributions of code by Kasper Klitgaard Berthelsen; Abdollah Jalilian; Marie-Colette v...
2011 Dec 04
1
RODBC sqlSave / append problem (windows XP, R 2.13.2)
...ereby making it a 429 x 13 table). I would ideally like this to be the same name etc as the original table in Access. I have used the following command: R> sqlSave(con,as.data.frame(SA_data),tablename="Const_mats_8301_t1",rownam es=T,fast=T, append=T) And get the error: Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, : missing columns in 'data' Thanks in advance, mj Visit our website at http://www.ubs.com This message contains confidential information and is in...{{dropped:26}}
2010 Feb 24
1
problem with looping on sqlSave()
..., pc = NA), .Names = c("m", "crit", "numsig", "pc")) > xlsFile <- odbcConnectExcel("file.xls", readOnly=F) > for (i in 1:4){ sqlSave(xlsFile, as.data.frame(test[[i]]), tablename="test", rownames=F, addPK=T, append=T) } Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, : missing columns in 'data' > odbcCloseAll() I've tried different combination and the 1st element is always exported but the next ones never. Elements 2 and 3 have the same number of columns; the problem persists in that case....
2012 Feb 06
0
sqsSave() test using Test.R script returning error suggesting no values upon "insert"
...------------------------------------------------------------------------------- #Then we get here.  I have the USArrests data and checked it but tried to save as it produced an error. sqlSave(channel, USArrests,"test.USArrests",rownames = "state", addPK = TRUE) "Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test,  :   no parameters, so nothing to update" The database table exists and upon edit of the table fields, all table info created correctly. Attempted again adding "verbose=TRUE": > sqlSave(channel, USArrests,"test.USArrests&q...
2012 May 29
1
RODBC, Excel, and data truncation when writing
...e received: library(RODBC) d <- data.frame(v1=c(1,2),v2=c(paste(rep("test",100),collapse=""),"test")) z <- odbcConnectExcel2007("test_rodbc.xlsx",readOnly=FALSE) sqlSave(z,d,tablename="Sheet1",rownames=FALSE) odbcClose(z) Warning message: In odbcUpdate(channel, query, mydata, coldata[m, ], test = test, : character data 'testtesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttesttes...
2013 Jan 31
0
RODBC and datetimes
...othing but character and numeric columns things work fine. However, when I attempt to add another column of type POSIXct to the data.frame and redefine the table to incorporate the new column (in the DB),attempting to push the table to the DB using sqlSave results in the following error: Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, : missing columns in 'data' Has anyone successfully been able to insert into a datetime field in ms sql server? If so, what type of variable did you use in R? I'm not really sure where to go or what to try next here. Any advice i...
2005 Sep 05
1
RODBC and 64 bit
...ully working with the RODB package on a 32 bit linux box to connect to a MSSQL Server via the freeTSL driver. After changing to a 64 bit environment I ran into some segmentation faults using function sqlUpdate on large database operations (the actual seg faults occured in the call to the C function ODBCUpdate). I just briefly looked into the code and found some extensive type casting going on so I figured this might be a 64 bit problem with the 'SQL_C_SLONG' and 'SQL_C_DOUBLE' data types. However I can't rule out the possibility that my TSL driver is messing up some things. I also tr...