Message-ID: <5c52ef1d0907060003u5ebbce3s212ef5ce40756d83@mail.gmail.com>
Date: 2009-07-06T07:03:04Z
From: XFM
Subject: sqlSave: error 22018 Invalid character value for cast specification
In-Reply-To: <5c52ef1d0907052312o425ab1c5yf3c24929c606c0b2@mail.gmail.com>
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 at 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 at 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
>>
>