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

[XFM]

I have found that, I dont know if it corresponds to my issue and how I
can apply the solution in the case of RODBC
http://support.microsoft.com/kb/269011


On Mon, Jul 6, 2009 at 1:55 PM, XFM<XFM using xx> wrote:
> 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
>