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

[XFM]

apparently the table is created but the data is not sent in the right
format: the date list field is created as float instead of datetime.
Any idea to help me?

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