[R-sig-DB] sqlSave: error 22018 Invalid character value for cast specification

[XFM]

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