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...