Post reply

ODBC Connections

  • May 26, 2014 at 3:07 am

    #289158

    I have a CRF which I have changed the version by adding few variables. I made all the necessary changes to the form and database. I am using what we call Teleform system for data management. I have managed to commit data of the new version to the database. However, the subsequent forms are giving me this error:

    [Microsoft][ODBC SQL Server Driver] Numeric value out of range (V10.7 10705) Failed committing batch.

    I have tried to check which values on the CRFs are out of range but I can not find one.

    Any help on how I can deal with this error

  • June 4, 2014 at 3:22 am

    #1718762

    Hi,

    I suspect you have a non numeric character in a column which you are trying to populate a column which is numeric datatype. if the column in the source data is a float try casting as a numeric prior to exporting.

    ============================================================
    David

    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • June 11, 2014 at 6:27 am

    #1720721

    Thanks David. I have identified the field which was bringing this error and I have resolved.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply