Underlying DBMS error[Microsoft SQL Server Native Client 10.0: Invalid character valu

Question

I am trying to append a new SDE from an existing SDE and in doing so I get this message: Underlying DBMS error[Microsoft SQL Server Native Client 10.0: Invalid character value for cast specification. All the domains are correct and the field lengths are correct. Any Thoughts on this matter. I reviewed earlier post to no resolve thanks!

FabianHeredia · Answer

this problem to present in datatable update

CamronHull1 · Answer

Hi Camron,

Do any of these fields you are attempting to append contain dates?  If so, take a look at the following KB article.

Sorry I am just now getting back to you. What it was-- is the new SDE had a String field and the original had a double field.

jskinner · Answer

Hi Camron,

Do any of these fields you are attempting to append contain dates?  If so, take a look at the following KB article.