[R-sig-DB] sqlSave: error 22018 Invalid character value for cast specification
XFM
XFM @end|ng |rom xx
Mon Jul 6 08:12:24 CEST 2009
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
>
More information about the R-sig-DB
mailing list