thr3ads.net - R help - [R] Failed exec in Update problem in R [May 2013]

If this information is useful, please help other people find it:
Share via:

Twitter
Facebook
Email

Solomon M Pushparaj

2013-May-28 08:13 UTC

[R] Failed exec in Update problem in R

Hi All,



i try to use sqlSave() in R. i receive the following error.



[RODBC] Failed exec in Update

22018 0 [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification



for the below code.


> library("RODBC")
> dbConnection  CreditCardVista  sqlSave(dbConnection,
CreditCardVista,tablename="CreditCardInfo",append=FALSE,rownames=FALSE,colnames=FALSE)
Error in sqlSave(dbConnection, CreditCardVista, tablename =
"CreditCardInfo",  :

  [RODBC] Failed exec in Update

22018 0 [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
> close(dbConnection)
> 


need your help to solve the problem.



with regards

Solomon
	[[alternative HTML version deleted]]

R help - May 2013 - Failed exec in Update problem in R

[R] Failed exec in Update problem in R