sqlSave: error 22018 Invalid character value for cast specification
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