[R-sig-DB] sqlSave: error 22018 Invalid character value for cast specification
XFM
XFM @end|ng |rom xx
Mon Jul 6 07:55:21 CEST 2009
Hi,
I try to use RODBC to upload dataframes to a SQL Server.
here is what odbcGetInfo returns:
> odbcGetInfo(channel)
DBMS_Name "Microsoft SQL Server"
DBMS_Ver "10.00.1600"
Driver_ODBC_Ver "03.52"
Data_Source_Name "databasefundamental4ecap"
Driver_Name "SQLSRV32.DLL"
Driver_Ver "03.85.1132"
ODBC_Ver "03.52.0000"
Server_Name "name_of_my_server"
I have dowloaded a data.frame using
> PRICE = sqlQuery(channel, query).
PRICE looks like that:
cdate PRICE
1 2009-06-15 0.8242105
2 2009-06-12 0.7942105
3 2009-06-11 0.8236842
4 2009-06-10 0.8178947
5 2009-06-09 0.8531579
6 2009-06-08 0.9715790
7 2009-06-05 0.8984211
8 2009-06-04 0.8536842
9 2009-06-03 0.9510526
10 2009-06-02 0.8547368
I try now to upload it back to the database, in a new table. I have
not changed anything in the format or in the values of the data.frame.
I have done:
> PRICE2 = PRICE
> sqlSave(channel, PRICE2)
It returns me the following error:
> sqlSave(channel, PRICE2)
Error in sqlSave(channel, PRICE2) : [RODBC] Failed exec in Update
22018 0 [Microsoft][ODBC SQL Server Driver]Invalid character value for
cast specification
If a try it again, I have the following error:
> sqlSave(channel, PRICE2)
Error in sqlSave(channel, PRICE2) : table ‘PRICE2’ already exists
Can somebody help me on that?
Thank you
Xavier
More information about the R-sig-DB
mailing list